Microsoft Access 2003 Advanced

Course Aims
This intensive, hands-on one-day training course has been designed to delegates a solid understanding of advanced Access tools and concepts in order to increase their knowledge and productivity in the shortest possible time.
Who Should Attend?
Proficient users of Microsoft Access 2003 or XP who want to consolidate and expand on their knowledge 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 2003 Advanced
Customizing Access
Customizing Menus and Toolbars:· Customizing Menus · Creating Menus · Showing and Hiding Toolbars · Customizing Toolbars · Creating Toolbars
Setting Access Options, Part 1:· Setting General and View Options · Setting Editing and Keyboard Options · Setting Datasheet, Form, and Report Options · Setting Page and Tables/Queries Options · Setting Error Checking Options · Setting Advanced Options
Setting Access Options, Part 2:· Setting International Options · Setting Spelling Options · Setting AutoCorrect Options · Setting Start-Up Options · Setting Macro Security Options
Creating Macros:· The Macro Design Toolbar · Creating a Macro · Running a Macro · About Macro Groups
Advanced Macro Uses:· Editing a Macro With the Visual Basic Editor · Assigning a Macro to a Keystroke · Assigning a Macro to a Toolbar · Viewing and Printing Macro Definitions
Advanced Data Tools
Switchboards:· Using a Switchboard · The Switchboard Manager · Creating a Switchboard · Editing a Switchboard · Deleting a Switchboard
Creating Data Access Pages:· The Data Access Page Wizard · Using Design View to Create a Data Access Page · Using an Existing HTML Page
Modifying Data Access Pages:· Adding a Theme · Adding Text and Controls · Formatting Text and Controls · Aligning and Sizing Content · Adding Images
Data Access Pages:· Basics of Using Data Access Pages · Viewing Data Entered Via a Data Access Page · Protecting Data
Advanced Queries
Table Relationships:· Normalizing Your Data · Establishing Referential Integrity · Using Cascade Update and Cascade Delete · Setting Fields for Indexing · Using Indexing
CrossTab Queries:· Understanding CrossTab Queries · Creating a CrossTab Query Using the Wizard · Creating a CrossTab Query Manually
Using Parameter Queries:· Setting Up Parameter Queries · Using a Parameter Query
Advanced Reporting Features:· Using AutoFormat · Aligning and Formatting Controls · Adding Pictures and Lines
Pivot Tables and Pivot Charts
Creating a PivotTable:· Creating a PivotTable Using the Wizard · Continuing Where the Wizard Left Off · More About Fields · Completing Your PivotTable
Using AutoForm and Creating PivotCharts:· Creating a PivotTable Using AutoForm · Creating a PivotChart Using AutoForm · About PivotChart Fields · Completing A PivotChart
PivotTables and PivotCharts:· Using a PivotTable · Using a PivotChart · Editing a PivotTable or PivotChart · Common PivotChart Editing Features · Turning a PivotTable Into a PivotChart and Vice-Versa