MS-Access 2010 Advanced

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.

Pre-requisites

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