Online Microsoft Office Access 2002 - Advanced Course
Microsoft Office Access 2002 - Advanced
SECTION 1: Customizing Access
Lesson 1.1: Customizing Menus and Toolbars
Customizing Menus
Creating Menus
Showing and Hiding Toolbars
Customizing Toolbars
Creating Toolbars
Practice Exercise
Lesson 1.2: 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 Advanced Options
Practice Exercise
Lesson 1.3: Setting Access Options, Part 2
Setting Training Materials Options
Setting Spelling Options
Setting AutoCorrect Options
Setting Start-Up Options
Practice Exercise
Lesson 1.4: Creating Macros
Using the Macro Design Toolbar
Creating a Macro
Running a Macro
About Macro Groups
Practice Exercise
Lesson 1.5: 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
Practice Exercise
Section 1: Review Questions
SECTION 2: Advanced Data Tools
Lesson 2.1: Switchboards
Using a Switchboard
Using the Switchboard Manager
Creating a Switchboard
Editing a Switchboard
Deleting a Switchboard
Practice Exercise
Lesson 2.2: Creating Data Access Pages
Using the Data Access Page Wizard
Using Design View to Create a Data Access Page
Using an Existing HTML Page
Practice Exercise
Lesson 2.3: Modifying Data Access Pages
Adding a Theme
Adding Text and Controls
Formatting Text and Controls
Aligning and Sizing Content
Adding Images
Practice Exercise
Lesson 2.4: Using Data Access Pages
Basics of Using Data Access Pages
Viewing Data Entered Via a Data Access Page
Protecting Data
Practice Exercise
Section 2: Review Questions
SECTION 3: Advanced Queries
Lesson 3.1: Table Relationships
Normalizing Your Data
Establishing Referential Integrity
Using Cascade Update and Cascade Delete
Setting Fields for Indexing
Using Indexing
Practice Exercise
Lesson 3.2: Using CrossTab Queries
Understanding CrossTab Queries
Creating a CrossTab Query Using the Wizard
Creating a CrossTab Query Manually
Practice Exercise
Lesson 3.3: Using Parameter Queries
Setting up Parameter Queries
Using a Parameter Query
Practice Exercise
Lesson 3.4: Advanced Reporting Features
Using AutoFormat
Aligning and Formatting Controls
Adding Pictures and Lines
Practice Exercise
Section 3: Review Questions
SECTION 4: Pivot Tables and Pivot Charts
Lesson 4.1: Creating a PivotTable
Creating a PivotTable Using the Wizard
Continuing Where the Wizard Left Off
More about Fields
Completing Your PivotTable
Practice Exercise
Lesson 4.2: Using AutoForm and Creating PivotCharts
Creating a PivotTable Using AutoForm
Creating a PivotChart Using AutoForm
About PivotChart Fields
Completing a PivotChart
Practice Exercise
Lesson 4.3: Using 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
Practice Exercise
Section 4: Review Questions