Starting Access

Opening an Existing Database

Using Menu Commands

Displaying and Hiding Toolbars

Changing Menu and Toolbar Options

Using Database Objects

Using the Database Window

Selecting Object Types

Opening a Database Object

Exiting Access

Using the Office Assistant

Finding an Answer

Hiding/Displaying the Office Assistant

Changing Office Assistant Options

Working with the Office Assistant

Creating a New Database

Designing Tables

Creating a Table in Design View

Using Design View

Adding Field Names

Assigning Data Types

Adding a Field Description

Setting a Primary Key

Saving a New Table

Using the Table Wizard

Creating Tables

Using Datasheet View

Navigating Fields in Tables

Adding Records

Moving through Records

Selecting Records

Editing Records

Saving Records

Deleting Records

Working with Tables

Changing the Row Height

Changing the 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

Editing Tables

Sorting Records

Finding Specific Records

Finding Records 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

Finding and Filtering Data

Printing Table Data

Changing the Page Setup

Printing Selected Records

Printing Data

Using Related Tables

Creating a Relationship

Setting Referential Integrity

Adding a Table - Relationships Window

Creating Relationships

Using Queries and RecordSets

Using the Simple Query Wizard

Creating a Query in Design View

Opening a Query

Adding a Table to a Query

Joining Tables in a Query

Running a Query

Using Simple Queries

Sorting a Query

Adding Criteria to a Query

Hiding a Field in a Query

Adding a Record using a Query

Printing a Query

Modifying Query Results

Analyzing a Table

Using Relationships in Splits

Using the Table Analyzer Wizard

Analyzing Tables

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

Creating Basic Forms

Using Reports

Using the Report Wizard

Using Print Preview

Printing Pages of a Report

Basing a Report on a Query

Using AutoReport

Creating Basic Reports

Working with Online Help

Viewing ScreenTips

Using Help Contents

Showing and Hiding the Help Tabs

Using the Help Answer Wizard

Using the Help Index

Using Online Help

Return to Table of Contents