Starting Access

Using Database Objects

Navigating Pages

Opening a Database Object

Closing a Database Object

Closing a Database

Using the Table Wizard

Creating a Blank Database

Designing Tables

Creating a Table in Design View

Using the Table Design Window

Adding Field Names

Assigning Data Types

Adding Field Descriptions

Setting a Primary Key

Saving a New Table

Using Datasheet View

Navigating Fields in Tables

Adding Records

Moving through Records

Selecting Records

Editing Records

Saving Records

Deleting Records

Using Field Properties

Limiting Field Size

Setting Number Formats

Setting Date/Time Formats

Setting Yes/No Formats

Setting Default Values

Setting Validation Rules/Text

Changing Row Height

Changing Column Width

Changing a Font Attribute

Changing a Cell Effect

Selecting a Column

Moving a Column

Hiding a Column

Unhiding a Column

Freezing a Column

Sorting Records

Finding Specific Records

Finding Using Wildcards

Using Replace

Using Filter By Selection

Applying/Removing a Filter

Using Filter Excluding Selection

Using the Filter For Feature

Using Filter By Form

Using Related Tables

Creating a Relationship

Setting Referential Integrity

Adding a Table to the Window

Using Queries and RecordSets

Using the Simple Query Wizard

Creating a Query - Design View

Opening a Query

Adding a Table to a Query

Joining Tables in a Query

Running a Query

Sorting a Query

Adding Criteria to a Query

Hiding a Field in a Query

Printing a Query

Adding a Record Using a Query

Analyzing a Table

Using Relationships in Splits

Using the Table Analyzer Wizard

Using Forms

Using the Form Wizard

Viewing Records in a Form

Printing Records in a Form

Basing a Form on a Query

Using AutoForm

Adding a Record Using a Form

Using Reports

Using the Report Wizard

Using Print Preview

Printing Pages of a Report

Basing a Report on a Query

Using AutoReport