(800) 716-4324
company catalog schedule discounts register contact

Training Links


Access Advanced Class

This course, builds on the skills and concepts taught in Access Intermediate. Students will learn how to query with SQL; create crosstab, parameter, and action queries; create macros; import, export, and link database objects; work with XML documents; work with Windows SharePoint Services; optimize databases; password-protect and encrypt databases; set Access options and properties; create hyperlink fields; and use Microsoft Outlook to update data.

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


  • 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 the AutoKeys and AutoExec macros
  • Creating macros for data transfer

Importing, exporting, and linking

  • Importing and Exporting objects
  • Interacting with XML documents
  • Linking Access objects
  • Working with Windows SharePoint Services

Database management

  • Optimizing resources
  • Protecting databases
  • Setting options and properties

Internet integration

  • Hyperlink fields
  • Working with Outlook

Access classes are offered at four locations::

Adobe Authorized Training Center Microsoft Certified Partner Google Certified Partner
Newsletter subscribers can win $100 credit! | Privacy Policy | Terms of Use    Social Media Buttons AcademyX on Facebook AcademyX on Google+ AcademyX on LinkedIn AcademyX on Twitter AcademyX on Youtube