Access 2013 Expert

40,00EUR

This course is designed to teach you a deeper understanding of Access 2013 in a practical way. This course is designed for advanced users of Access 2013. This course incorporates a hands-on approach to learning. They will get a chance to practice some of the advanced features right on a computer.

This course is meant to provide a safe learning environment where they can practice and learn Access 2013 Expert functions without worrying about making mistakes. Access 2013 features a new framework that is designed for one purpose―enable users to create data-centric web applications. Taking the time to develop a deep understanding of Access 2013 will increase their knowledge on how databases work and make creating and managing an Access 2013 database easier for everyone.

Course Outline

Module One: Getting Started

Module Two: Customizing Apps (I)

  • Creating a Custom App from Scratch
  • Adding a Template Table Adding a Blank Table
  • Importing Access 2010 Tables
  • Module Two: Review Questions

Module Three: Customizing Apps (II)

  • About Custom Actions
  • Adding a Custom Actin
  • Editing a Custom Action
  • Deleting a Custom Action
  • Module Three: Review Questions

Module Four: Customizing Apps (III)

  • About User Interface Macros
  • Creating an Embedded Macro
  • Creating a Standalone macro
  • Saving Your App as a Package
  • Module Four: Review Questions

Module Five: Working with Validation Rules and Messages

  • Creating a Field Validation Rule
  • Creating a Field Validation Message
  • Creating a Validation Rule
  • Creating a Validation Message
  • Testing Validation Rules
  • Module Five: Review Questions

Module Six: Working with Macros

  • Creating a Before Change Event
  • Working with the Macro Tools Design Tab
  • Working with the Action Catalog
  • Creating an After Event
  • Creating a Named Macro
  • Renaming or Deleting Macros
  • Module Six: Review Questions

Module Seven: Advanced Query Tasks

  • Using Query Design View
  • Creating Ad Hoc Relationships
  • Creating an Update Query
  • Creating a Parameter Query
  • Comparing Two Tables by Using a Join
  • Module Seven: Review Questions

Module Eight: Designing Forms

  • Common Formatting Tasks
  • Using Themes
  • Working with Controls
  • Adding Header and Footer Elements
  • Arranging Form Elements
  • Formatting Forms
  • Module Eight: Review Questions

Module Nine: Advanced Reporting Tasks

  • Using Report Sections
  • Using Conditional Formatting
  • Grouping and Sorting Data
  • Adding Calculated Controls
  • Creating Labels
  • Module Nine: Review questions

Module Ten: Advanced Database Tools

  • Using the Database Documenter
  • Analyzing Table Performance
  • Analyzing Database Performance
  • Repairing a Database
  • Compacting a Database
  • Module Ten: Review Questions

Module Eleven: Working with the Access Environment

  • Working with Database Properties
  • Encrypting a Database with a Password
  • Using Save Object As
  • Setting Access Options
  • Module Eleven: Review Questions

Shopping cart

Subtotal
Shipping and discount codes are added at checkout.
Checkout
Skip to toolbar