Access Advanced (2013, 2016, 2019, Office 365) Training


( - Eastern)
Access Advanced (2013, 2016, 2019, Office 365) Logo

This course builds on the skills and concepts taught in the Introduction and Intermediate courses. Students will learn advanced querying techniques, how to work with macros, how to import, export and link objects, and how to utilize advanced database management techniques. This course will help students prepare for the Microsoft Office Specialist exam. For comprehensive certification training, students should complete the Introduction, Intermediate, and Advanced courses for Access.

If you need customized content or another version of this course please contact us.

Live Online Schedule

  • Jan 21 CLOSED
  • Feb 22
  • Mar 29
  • Apr 10
  • May 3
  • Jun 12


Microsoft Access Intermediate or equivalent knowledge.


You will need the following software/setup for this class:

  • Microsoft Office 2013 or higher


Access Advanced (2013, 2016, 2019, Office 365)

  • Querying with SQL
    • SQL and Access
    • Writing SQL statements
    • Attaching SQL queries to controls
  • Advanced queries
    • Creating crosstab queries
    • Creating parameter queries
    • Using action queries
  • Macros
    • Creating, running, and modifying macros
    • Attaching macros to the events of database objects
  • Advanced macros
    • Creating macros to provide user interaction
    • Creating macros that require user input
    • Creating AutoKeys and AutoExec macros
    • Creating macros for data transfer
  • Importing, exporting, and linking objects
    • Importing objects
    • Exporting objects
    • Working with XML documents
    • Linking Access objects
    • Using hyperlink fields
  • Database management
    • Optimizing resources
    • Protecting databases
    • Setting options and properties