Microsoft Access 2003 Advanced

Who Should Attend the Course?

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

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