Microsoft Office Access 2003 - Intermediate Course Outline

Microsoft Office Access 2003 - Intermediate

SECTION 1: Advanced File Tasks

Lesson 1.1: Using My Computer within Access

Navigating with My Computer

Performing Basic Tasks with My Computer

Changing Views with My Computer

Using the My Places Toolbar

Practice Exercise

Lesson 1.2: Database Management

Repairing a Database

Compacting a Database

Backing up Your Database

Editing Database Properties

Practice Exercise

Lesson 1.3: Saving Your Files

Using the Save As Dialogue

Using Object Properties

Using AutoRecover

Practice Exercise

Lesson 1.4: Exporting Files

Exporting to Word

Exporting to Excel

Exporting to Older Versions of Access

Exporting vs. Save As

Practice Exercise

Lesson 1.5: Linking Files

Linking to an Excel Spreadsheet

Linking to Another Database

Creating a Hyperlink

Inserting an OLE Object

Practice Exercise

Section 1: Review Questions

SECTION 2: Working with Tables

Lesson 2.1: Customizing Tables

Understanding Field Properties

Adding a Primary Key to a Table

Indexing a Field

Inserting, Deleting, and Moving Fields

Importing a Table from Another Source

Practice Exercise

Lesson 2.2: Formatting Tables

Formatting Number Fields

Formatting Text Fields

Adding Field Descriptions

Changing Field Data Types

Adding Captions

Practice Exercise

Lesson 2.3: Controlling Table Data Entry

Setting a Default Value

Setting a Required Value

Creating and Using Input Masks

Creating and Removing Table Relationships

Practice Exercise

Lesson 2.4: Managing Table Data Entry

How to Validate Data

Creating a Lookup Field

Modifying a Lookup Field

Creating a Value List

Modifying a Value List

Practice Exercise

Section 2: Review Questions

SECTION 3: Working with Forms

Lesson 3.1: Basic Form Controls

Adding a Control

Using the Control Wizard

Cutting, Copying, Pasting, and Moving a Control

Formatting a Control

Practice Exercise

Lesson 3.2: Advanced Form Controls

Modifying a Control's Properties

Changing a Control's Data Source

Changing a Control's Default Value

Creating a Calculated Control

Using Form Properties

Practice Exercise

Lesson 3.3: Formatting a Form

Formatting Gridlines

Modifying the Font

Adding Images

Using AutoFormat

Practice Exercise

Section 3: Review Questions

SECTION 4: Reports

Lesson 4.1: Organizing Report Data

Adding and Removing Fields

Using Report Sections

Changing Section Properties

Grouping and Sorting in a Report

Changing Group Properties

Using Calculated Controls in a Report

Practice Exercise

Lesson 4.2: Formatting Reports

Formatting Gridlines

Modifying the Font

Adjusting the Layout of your Report

Using AutoFormat

Practice Exercise

Lesson 4.3: Common Report Tasks

Adding a Photo

Adjusting Page Properties

Adding Headers and Footers

Adding Page Numbers

Using the Label Wizard

Practice Exercise

Section 4: Review Questions

SECTION 5: Working with Queries

Lesson 5.1: Basic Queries

Review of Queries

Creating a Query

Sorting a Query

Filtering a Query

Hiding Fields

Using AND/OR Operators

Using IIF Functions

Practice Exercise

Lesson 5.2: Multiple Table Queries

Creating a Multiple Table Query

Creating a Calculated Field

Using the Expression Builder

Using Queries to Summarize

Using Make-Table Queries

Practice Exercise

Lesson 5.3: Management (Action) Queries

Append Queries

Delete Queries

Update Queries

Exporting Queries

Practice Exercise

Section 5: Review Questions