Microsoft Access Advanced - Online Classroom

Course Aims:

This intensive hands-on one-day training course has been designed to provide delegates with a solid understanding of advanced tools and concepts in Access in order to increase their knowledge and productivity.

Who Should Attend?

Users with a good understanding of Microsoft Office Access who want to expand on their capabilities in a short space of time. TSome of the lessons are quite technical and delegates must have a good working knowledge and understanding of the concepts covered in the Introduction and Intermediate courses.

Course Outline:

Advanced Data Management

- Referential Integrity
- Table Relationships
- An Introduction to SQL
- Modal Dialog Boxes

Advanced Form Tasks

- Using Subforms
- Creating a Navigation Form
- Advanced Form Controls
- Exporting a Form
- Other Form Tasks

Pivoting Data

- Creating a PivotTable
- Using PivotTables
- Advanced PivotTable Tasks
- Creating a PivotChart
- More on PivotCharts

SQL and Microsoft Access

- Understanding SQL
- Using the SELECT Statement
- Using Subqueries
- Using SQL Joins