Course outline for
Microsoft Office Access 2007 - 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

Step-By-Step

Skill Sharpener

Lesson 1.2: Database Management

Compact and Repair a Database

Backing up Your Database

Editing Database Properties

Step-By-Step

Skill Sharpener

Lesson 1.3: Saving Your Files

Using the Save As Dialog

Using the Save As Menu

Using File Properties

Using AutoRecover

Step-By-Step

Skill Sharpener

Lesson 1.4: Exporting Files

Exporting to PDF or XPS

Exporting to Word or Excel

Exporting to Other Destinations

Using Saved Exports

Exporting to a CAB File

Exporting to Older Versions of Access

Step-By-Step

Skill Sharpener

Lesson 1.5: Linking Files

Linking to an Excel Spreadsheet

Linking to Another Database

Linking to a SharePoint Site

Other Types of Linked Documents

Creating a Hyperlink

Step-By-Step

Skill Sharpener

Section 1: Case Study

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

Step-By-Step

Skill Sharpener

Lesson 2.2: Formatting Tables

Formatting Number Fields

Formatting Text Fields

Adding Field Descriptions

Changing Field Data Types

Adding Captions

Step-By-Step

Skill Sharpener

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

Step-By-Step

Skill Sharpener

Lesson 2.4: Managing Table Data Entry

Using the Table Design Tab

How to Validate Data

Creating a Lookup Field

Modifying a Lookup Field

Creating a Value List

Modifying a Value List

Step-By-Step

Skill Sharpener

Section 2: Case Study

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

Step-By-Step

Skill Sharpener

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

Step-By-Step

Skill Sharpener

Lesson 3.3: Formatting Your Form.

Formatting Gridlines

Modifying the Font

Adding Logos

Changing the Layout

Step-By-Step

Skill Sharpener

Lesson 3.4: Formatting Controls

Changing the Color of a Control

Using Control Properties

Aligning Controls

Applying Special Effects

Step-By-Step

Skill Sharpener

Lesson 3.5: Formatting Records

Modifying Fonts

Using AutoFormat

Using the Format Tab

Using the Arrange Tab

Step-By-Step

Skill Sharpener

Section 3: Case Study

Section 3: Review Questions

Section 4: Working with 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

Step-By-Step

Skill Sharpener

Lesson 4.2: Formatting Reports

Formatting Gridlines

Modifying the Font

Adding Logos

Changing the Layout

Using AutoFormat

Step-By-Step

Skill Sharpener

Lesson 4.3: Common Report Tasks

Adding a Photo

Adjusting Page Properties

Adding Headers and Footers

Adding Page Numbers

Using the Label Wizard

Step-By-Step

Skill Sharpener

Section 4: Case Study

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

Use of IIF Functions

Step-By-Step

Skill Sharpener

Lesson 5.2: Multiple Table Queries

Creating a Multiple Table Query

Creating a Calculated Field

Using the Expression Builder

Using Queries to Summarize

Step-By-Step

Skill Sharpener

Lesson 5.3: Advanced Queries

Creating a Parameter Query

Using Parameter Queries

Creating Crosstab Queries

Using Crosstab Queries

Using Make-Table Queries

Step-By-Step

Skill Sharpener

Lesson 5.4: Management (Action) Queries

Append Queries

Delete Queries

Update Queries

Exporting Queries

Step-By-Step

Skill Sharpener

Section 5: Case Study

Section 5: Review Questions

Index