Microsoft Office Access 2003 - Advanced Course Outline

Microsoft Office Access 2003 - 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 Error Checking Options

Setting Advanced Options

Practice Exercise

Lesson 1.3: Setting Access Options, Part 2

Setting International Options

Setting Spelling Options

Setting AutoCorrect Options

Setting Start-Up Options

Setting Macro Security 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