Access 2003 Level 1

About This Courseware

Courseware Conventions

Basic Windows Skills Checklist

A Quick Review of Basics

System Requirements

Obtaining Support

Starting Access

Moving Around

Getting Help

Exiting Access

Introducing Access

Objectives of Section 1

Overview

What is a Database?

What is Access?

Looking at the Screen

Creating a Database with the Wizard

Using the Wizard Dialogs

Using the Switchboard

Looking Around Access

Using the Database Window

Planning a Database

Determining the Scope of the Project

Designing the Table Structure

Determining Inputs and Outputs

Creating a Database Manually

Creating a New Database

Summary of Section 1

Creating & Modifying Tables

Objectives of Section 2

Creating Tables in Access

New Table Dialog Box

Creating a Table Using the Wizard

Entering Data

Defining Data Types & Properties

Changing Views

Setting Data Types

Setting Field Properties

Date Formats

Setting a Primary Key

Creating a Table Manually

Creating a Table in Datasheet View

Saving a Table

Creating a Table in Design View

Moving Around in the Table

Using the Mouse

Using the Keyboard

Using the Navigation Buttons

Restructuring Tables

Adding a Field

Modifying a Field

Deleting a Field

Changing the Field Order

Formatting Tables

Changing the Column Order

Freezing Columns

Changing Column Widths

Changing Fonts

Changing Cell Formats

Printing and Distributing Tables

Printing Records

Saving a Table as a Web Page

Summary of Section 2

Data Manipulation

Objectives of Section 3

Inserting & Deleting Records

Changing Data & Undoing Changes

Editing Data in Datasheet View

Undoing Changes

Importing & Exporting Data

Importing Data from Other Applications

Exporting Data to Other Applications

Finding Data

Exact Matching

Partial Matching

Case Sensitive Searching

Using Wildcard Characters

Replacing Data in Multiple Records

Sorting Records

Sorting by a Single Field

Sorting by More than One Field

Filtering Records

Filter By Selection

Filter Excluding Selection

Filter For

Filter By Form

Advanced Filter/Sort

Summary of Section 3

Simple Select Queries

Objectives of Section 4

What is a Query?

Creating a Simple Query

Creating a Query using the Wizard

Creating a Query from Scratch

Saving Queries

Selecting Specific Fields

Adjusting the Dynaset

Sorting the Dynaset

Deleting Fields

Selecting Records

Using Simple Criteria

Using Comparison Operators

Using Wildcard Characters

Excluding Fields from a Dynaset

Using Multiple Selection Criteria

Using the AND Operator

Using the OR Operator

Using AND & OR Operators in the Same Field

Functions & Calculated Fields

Using the Date Function

Calculated Fields

Changing Field Properties

Summary of Section 4

Relating Multiple Tables

Objectives of Section 5

Establishing Table Relationships

Understanding Relationships

Types of Relationships

Prerequisites to Defining Relationships

One-To-Many Relationships

Viewing Related Tables

One-To-One Relationships

Many-To-Many Relationships

Enforcing Referential Integrity

Using the Table Analyzer

Database Maintenance

Backing Up and Restoring a Database

Compacting and Repairing a Database

Object Dependencies

Summary of Section 5

Forms and Reports

Objectives of Section 6

What is a Form or Report?

Creating a Form

Creating an AutoForm

Using the Form Wizard

Switching Views

Using Forms

Moving Within Records

Moving Between Records

Entering and Editing Data

Modifying a Form

Moving and Resizing Fields

Aligning, Sizing and Spacing Controls

Using Drawing Tools

Adding and Modifying Text

Calculated Fields

Creating a Report

Creating an AutoReport

Using the Report Wizard

Modifying Reports

Creating Mailing Labels

Printing Forms and Reports

Printing Forms

Printing Reports

Summary of Section 6

Appendices

Productivity Tools

Glossary of Terms

Index

Microsoft Office Access 2003 Exam Objectives