Microsoft Access 2007 Advanced

Who Should Attend the Course?

Users with a good understanding of Microsoft Access 2007 who want to expand on their capabilities in a short space of time. Delegates should 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 • Switchboards • Modal Dialogue Boxes

Advanced Form Tasks

• Using Subforms • Advanced Form Tasks • Exporting Your Form • Using Outlook and SharePoint with Access

Pivoting Data

• Creating a PivotTable • Creating a PivotChart • Using PivotTables and PivotCharts

Access and Windows

• Access and Windows • Using the Access Viewer

Action Queries

• Management (Action) Queries