Students leave this class feeling confident with the advanced features in Microsoft Access and be able to develop complex detailed databases. ​


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




0.70 Continuing Education Units
Course ID #TECH250

Class Details

No offerings for the remainder of the year. Check our new course catalog coming out this fall.

Don't see what you are looking for?

Contact Us