Access Intermediate

This course builds on the introductory skills of the Introduction course. You will learn how to ensure that data is entered correctly, how to create more sophisticated and complex queries, and how to use basic automation techniques involving macros.


Duration: 1 day

Version: 2010, 2013, 2016

Target Audience: Experienced

Prerequisites: Completion of the MCI Access Introduction course or equivalent

Learning outcomes

At the end of this program you will be able to:

  • Use various data validation features in Access to protect data
  • Format the data in a table
  • Perform more advanced queries using a variety of querying techniques
  • Create and use parameter queries
  • Create calculated queries
  • Modify and adapt an existing form according to specific needs
  • Create a navigation form for a database in Access 2016
  • Create forms using a combination of wizards and manual techniques
  • Create and use macros in Access
  • Work with a number of macro techniques
  • Create and work with macros in forms
  • Create and manage custom categories and groups in the Navigation Pane