Course Description

After completing this 1-day Access 2010 Advanced training course, students will know how to:

  • Use SQL statements in Access;
  • Create aliases for fields;
  • Write SQL statements to create queries;
  • Attach SQL statements to command buttons;
  • Create crosstab queries to summarize grouped data;
  • Create parameter queries to view results based on specified criteria;
  • Create action queries to add, delete, and modify data in tables and to make new tables;
  • Create and run macros to automate tasks;
  • Attach macros to the events of database objects;
  • Create data validation and data entry macros;
  • Create macros that run parameter queries;
  • Create AutoKeys and AutoExec macros;
  • Create macros to import and export database objects;
  • Import Access objects from another Access database, from Excel, and from a CSV file;
  • Export objects from one database to another;
  • Export and import XML documents;
  • Save objects as XPS files;
  • Link Access objects between databases and to Excel workbooks;
  • Create hyperlink fields;
  • Save databases in file formats for previous versions of Access;
  • Use the Performance Analyzer;
  • Split, compact, repair, and back up databases;
  • Encrypt and password-protect database files;
  • Configure Access Options;
  • Populate database file properties.


Attendance at our Access 2010 Intermediate training course or equivalent experience.

Who is this Course for ?

For experienced Access 2010 users who are ready to use the more advanced features of Access 2010.

Further Training

After some further on-the-job experience using Access 2010 at an advanced level, we recommend students attend our Access 2010 VBA Programming course to gain skills in the usage of the VBA programming language to add programming power to Access 2010 applications.

Course content

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, & 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, & 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