Course outline for
Microsoft Office Access 2007 - Foundation

Section 1: Getting Started

Lesson 1.1: Starting Out

What is Microsoft Access?

What's New in Access 2007?

Basic Terminology

Opening Microsoft Access

Interface Overview

Closing Microsoft Access

Step-By-Step

Skill Sharpener

Lesson 1.2: Using the Getting Started Window.

Overview of the Window

Navigating Through the Window

Creating a Database from a Template

Creating a Blank Database

Step-By-Step

Skill Sharpener

Lesson 1.3: The Trust Center

Warnings You May See when Opening a Database

Enabling Content

About Digital Signatures

About Trusted Locations

Opening the Trust Center

Assigning a Password to your Database

Step-By-Step

Skill Sharpener

Lesson 1.4: Getting Help

Opening the Help Screen

Overview of the Help Screen

Online Help vs. Offline Help

Searching for Help

Step-By-Step

Skill Sharpener

Section 1: Case Study

Section 1: Review Questions

Section 2: The New Interface

Lesson 2.1: Using the Quick Access Toolbar

About the Default Buttons

Adding Buttons

Removing Buttons

Customizing the Toolbar

Step-By-Step

Skill Sharpener

Lesson 2.2: Basics of Tabs

About Tabs

Opening Dialog Boxes from the Ribbon

About the Office Menu

Step-By-Step

Skill Sharpener

Lesson 2.3: The Home Tab

Views

Clipboard

Font

Rich Text

Records

Sort and Filter

Find

Step-By-Step

Skill Sharpener

Lesson 2.4: Create Tab

Tables

Forms

Reports

Other

Step-By-Step

Skill Sharpener

Lesson 2.5: External Data Tab

Import

Export

Collect Data

SharePoint Lists

Step-By-Step

Skill Sharpener

Lesson 2.6: Database Tools Tab

Macro

Show/Hide

Analyze

Move Data

Database Tools

Step-By-Step

Skill Sharpener

Section 2: Case Study

Section 2: Review Questions

Section 3: Creating a Database

Lesson 3.1: First Steps

Planning a Database

Creating a Database from a Template

Creating a Blank Database

Using Database Objects

Setting Navigation Options

Step-By-Step

Skill Sharpener

Lesson 3.2: About Records

What is a Record?

Navigation Tips

Adding Records

Editing Records

Deleting Records

E-Mailing Records

Printing Records

Step-By-Step

Skill Sharpener

Lesson 3.3: Creating a Table

About Tables

Creating a Table

Entering Data into a Table

Formatting a Table

Step-By-Step

Skill Sharpener

Lesson 3.4: Formatting Text

Using the Zoom Box

Selecting Data

Cutting, Copying, and Pasting

Using the Format Painter

Using Undo and Redo

Checking your Spelling

Step-By-Step

Skill Sharpener

Section 3: Case Study

Section 3: Review Questions

Section 4: Doing More with your Database

Lesson 4.1: Creating Forms

What is a Form?

Bound vs. Unbound Controls

Creating a Form with the Wizard

Using Design View to Modify Your Form

Using Forms

Step-By-Step

Skill Sharpener

Lesson 4.2: Creating Queries

What is a Query?

Creating a Query with the Wizard

Using Design View to Modify a Query

Using Queries

Step-By-Step

Skill Sharpener

Lesson 4.3: Reports

What is a Report?

Creating a Report with the Wizard

Using Design View to Modify a Report

Using Reports

Step-By-Step

Skill Sharpener

Lesson 4.4: Sorting and Filtering Data

Using Find and Replace

Sort Ascending or Descending

Toggling Filter

Using Selection Sort

Using Advanced Sort

Step-By-Step

Skill Sharpener

Lesson 4.5: Viewing Data

Using the View Menu

Using the View Icons

Using the Tabs

Closing Individual Tabs

Step-By-Step

Skill Sharpener

Lesson 4.6: Printing a Database Object

Using the Print Menu

Using Print Preview

Using the Print Preview Tab

Printing vs. Exporting

Step-By-Step

Skill Sharpener

Section 4: Case Study

Section 4: Review Questions

Index