This class covers advanced concepts in Microsoft Access and is designed for students with significant experience using Access who would like to take their database skills to the next level. ​


Familiarity with creating databases in Microsoft Access.


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 objects
  • 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 2007


Don't see what you are looking for?

Contact Us