Microsoft Office Access 2002 - Foundation Course Outline

Microsoft Office Access 2002 - Foundation

SECTION 1: Access Basics

Lesson 1.1: Database Terminology

What is a Table?

What is a Record?

What is a Form?

What is a Report?

What is a Query?

Lesson 1.2: Meeting Access

Starting Access

The Microsoft Access Environment

Working with Toolbars

Working With the Task Pane

Practice Exercise

Lesson 1.3: Creating a Database

Plan Your Database

Creating a New Database Using the Wizard

The Database Window

The Relationships Window

Understanding Join Lines

Practice Exercise

Lesson 1.4: Creating Tables

About Referential Integrity

Viewing Tables and Entering Data

Viewing Table Properties

Practice Exercise

Lesson 1.5: Creating Forms

Previewing a Form's Design

Previewing Reports

Viewing a Report's Design

Practice Exercise

SECTION 2: Tables

Lesson 2.1: Table Basics

Table Structure

Primary Key Field

Changing Field Properties

Practice Exercise

Lesson 2.2: Creating a Table

Creating a Table Using the Wizard

Creating a Table Using NewObject:Table

Creating a Table in Design View

About Table and Field Names

Practice Exercise

Lesson 2.3: Working With a Table

Editing a Table

Changing Table and Field Names

Deleting Fields

Practice Exercise

Lesson 2.4: Finishing a Table

Saving a Table

Editing a Table in Design View

Changing a Table Structure

Entering Table Data

Importing Data from Excel

Practice Exercise

SECTION 3: Forms

Lesson 3.1: Creating a Form

Creating a Form Using NewObject

Creating a Form Using the Wizard

Creating a Form in Design View

Practice Exercise

Lesson 3.2: Modifying a Form

Designate the Record Source

Place the Fields

Move and Place Controls

Delete Controls

Practice Exercise

Lesson 3.3: Using Controls

Use the Toolbox

Format Controls

Changing Formatting Using the Format Painter

Using the Navigation Bar to Move Through Your Form

Viewing Your Work

Practice Exercise

SECTION 4: Reports and Queries

Lesson 4.1: Creating a Report

Create a Report Using NewObject:Report

Create a Report Using the Wizard

Create a Report in Design View

Grouping and Sorting

Practice Exercise

Lesson 4.2: Using Report Controls

Bound Controls

Unbound Controls

Option Buttons


Control Properties

Practice Exercise

Lesson 4.3: Finishing a Report

Report Sections

Add a Report Header or Footer

Sort and Group

Previewing Your Report

Practice Exercise

Lesson 4.4: Queries

Working with Queries

Manipulate Tables in the Query Window

Arrange the Query Design Window

About the Design Grid

Multi-Table Queries

About Calculated Fields

Practice Exercise