Coronavirus (COVID-19) information: Live classes available in-person or online from our fully vaccinated instructors. Learn more about our reopening.


Access Training Class - Advanced

Access Training Class - Advanced

Gain advanced Access skills and learn advanced database concepts in this advanced Microsoft Access course. Find out how to organize data more efficiently, develop advanced queries, analyze data, summarize data, apply security, create macros, and to use VBA.

Questions about this advanced Microsoft Access class? Interested in a private or customized training? Call to speak with a training consultant: 781-376-6044.

Access Training Class - Advanced Course Dates

All classes are led by a live instructor. Class times listed are Eastern time.


Please call 800-851-9237 or 781-376-6044 to schedule a course.

Contact AGI to request course dates.

Access Training Course - Advanced: Complete Class Topics

Advanced Form Design in Access

  • Adding Controls to Forms
  • Enhancing Form Navigation
  • Improving Form Organization
  • Applying Conditional Formatting

Sharing Data Across Applications

  • Import ingData into Access
  • Exporting Access Data
  • Linking Tables to External Data Sources
  • Creating Mail Merges

Using Macros to Improve User Interface Design

  • Create Macros
  • Restricting Records Using Conditions
  • Validating Data Using Macros
  • Automating Data Entry Using Macros

Using VBA

  • Understanding VBA and when it is used
  • Enhancing Access Using VBA

Using Advanced Database Management

  • Manage Databases
  • Determining Object Dependency
  • Documenting Databases

Distributing and Securing Access Databases

  • Splitting Databases for Multiple User Access
  • Implement Security
  • Converting an Access Database to an ACCDE File
  • Packaging a Database with a Digital Signature

Managing Switchboards

  • Creating Database Switchboard
  • Modifying Database Switchboard
  • Set Access Database Startup Options

We recommend that you have Microsoft Access installed on your computer before starting this class.

You will receive a comprehensive course manual for this Advanced Access class developed by the instructors at AGI. AGI instructors have created many of the official training guides and books for Microsoft.

Available Delivery Methods For This Class