Microsoft Access 2007 Advanced

Course Aims
This intensive hands-on one-day training course has been designed to provide delegates with a solid understanding of advanced Access tools and concepts in order to increase their knowledge and productivity.
Who Should Attend?
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: Microsoft Access 2007 Advanced
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