Access 2002 Level 1

Database Introduction

Overview

What is a Database?

What is Access?

Introducing the Access Window

Using the Menu Bar

Using the Toolbars

Creating a Database with the Wizard

Using the Wizard Dialogs

Using the Switchboard

Looking Around Access

Using the Database Window

Creating a Database Manually

Creating a New Database

Creating and Modifying Tables

Creating Tables in Access

Creating a Table Using the Wizard

Using the Wizards

Entering & Editing Data

Entering Data

Defining Data Types & Properties

Changing Views

Setting Data Types

Setting Field Properties

Recognizing 21st Century Dates

Setting a Primary Key

Creating a Table Manually

Creating a Table in Datasheet View

Saving a Table

Creating a Table Using 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 Field Order

Formatting Tables

Changing Column Order

Freezing Columns

Changing Column Widths

Changing Fonts

Changing Cell Formats

Data Manipulation

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

Queries

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

Functions & Calculated Fields

Using the Date Operator

Calculated Fields

Changing Field Properties

Advanced Table Design

Advanced Field Properties

Using Input Masks

Using the Input Mask Wizard

Creating Lookup Fields

Establishing Table Relationships

Understanding Relationships

Types of Relationships

Defining Relationships

Viewing Related Tables

Enforcing Referential Integrity

Database Maintenance

Backing Up and Restoring a Database

Compacting and Repairing a Database

Forms, Reports and Pages

What is a Form or Report?

Creating a Form

Creating an Auto Form

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

Using Drawing Tools

Adding and Modifying Text

Calculated Fields

Creating a Report

Creating an AutoReport

Using the Report Wizard

Modifying Reports

Printing Forms and Reports

Printing Forms

Printing Reports

Creating a Data Access Page