Microsoft Office Access 2003 - Foundation Course Outline

Microsoft Office Access 2003 - Foundation

SECTION 1: Getting Started

Lesson 1.1: Starting Out

What is Microsoft Access?

What's New in Access 2003?

Basic Terminology

Opening Microsoft Access

Interface Overview

Closing Microsoft Access

Practice Exercise

Lesson 1.2: Using the Access Interface

Using the Access Menus

Using Access Task Panes

Using Toolbars

Adding, Removing, and Moving Toolbars

Using the Switchboard

Using the Database Window

Practice Exercise

Lesson 1.3: Getting Help

Using the Help Menu

Using the Help Task Pane

Using the Office Assistant

Configuring the Office Assistant

Using the Type a Question Box

Getting Help in a Dialog Box

Using the Sample Databases

Practice Exercise

Section 1: Review Questions

SECTION 2: Creating a Database

Lesson 2.1: First Steps

Planning a Database

Creating a Blank Database

Using Database Objects

Practice Exercise

Lesson 2.2: Records

What is a Record?

Adding Records

Editing Records

Deleting Records

Printing Records

Practice Exercise

Lesson 2.3: Creating a Table

About Tables

Creating a Table in Design View

Creating a Table using the Wizard

Entering Data into a Table

Formatting a Table

Practice Exercise

Lesson 2.4: Formatting Text

Using the Zoom Toolbar

Selecting Data

Cutting, Copying, and Pasting

Using the Format Painter

Using Undo and Redo

Checking your Spelling

Practice Exercise

Lesson 2.5: Formatting Controls

Changing the Colour of a Control

Using Control Properties

Aligning Controls

Applying Special Effects

Practice Exercise

Section 2: Review Questions

SECTION 3: Doing More with Your Database

Lesson 3.1: Creating Forms

What is a Form?

Bound vs. Unbound Controls

Creating a Form with the Wizard

Creating a Form in Design View

Using Forms

Practice Exercise

Lesson 3.2: Creating Queries

What is a Query?

Creating a Query with the Wizard

Using Design View to Modify a Query

Using Queries

Practice Exercise

Lesson 3.3: Reports

What is a Report?

Creating a Report with the Wizard

Creating a Report in Design View

Using Reports

Practice Exercise

Lesson 3.4: Sorting and Filtering Data

Using Find and Replace

Sort Ascending or Descending

Using Filter by Form

Using Filter by Selection

Creating a Filter

Practice Exercise

Section 3: Review Questions

SECTION 4: Viewing and Printing Your Data

Lesson 4.1: Formatting a Datasheet

Adjusting Row Height and Column Width

Rearranging Columns

Freezing a Row or Column

Hiding a Column

Changing the Datasheet Font

Practice Exercise

Lesson 4.2: Viewing Data

Using the View Menu

Using the Window Menu

Hiding and Unhiding Windows

Arranging Windows

Closing Individual Windows

Practice Exercise

Lesson 4.3: Printing a Database Object

Using the Print Icon

Using Print Preview

Using Page Setup

Practice Exercise

Section 4: Review Questions