Getting Started

• Why Use a Database?
• What Does a Database Consist of?
• Starting Access
• Opening a Database
• Understanding the Screen
• Using the Navigation Pane
• Giving Commands
• Closing a Database and the Application
• Opening a Table
• Closing a Table
• Displaying Records with the Mouse/Keyboard
• Editing and Deleting Data in a Record
• Adding Data in a Table
• Deleting a Record from a Table
• Finding Data

Basic Query

• What is a Query?
• Opening and Closing a Query
• Designing a Query
• Switching Between Design and Datasheet
• Creating a Query
• Adding and Removing a Table from a Query
• Adding a Field in a Query
• Deleting a Field in a Query
• Saving a Query

Sorting in a Query

• Sorting Data with Visible Columns
• Moving the Fields in a Query
• Adding All Fields in a Query
• Deleting All Fields in a Query
• Sorting Data with Hidden Columns
• Quick Sort

Query with Single Criterion

• Selecting the Records in a Query
• What is a Value?
• Clearing a Single Criterion
• Using Logical Criteria
• Using Wildcards in Criteria
• Searching for No Value (Nulls)
• Using Criteria with Hidden Columns

Query with Multiple Criteria

• Searching for a Range of Values
• Searching for Multiple Values in a Single Field
• Using "And" Criterion in Multiple Fields
• Using "Or" Criterion in Multiple Fields
• Deleting and Inserting Criteria Rows

Building the Database/Tables

• Creating a Database
• Creating a Table
• Naming a Field in a Table
• Selecting Field Data Types and Properties
• Saving a Table
• The Primary Key Field
• Inserting a Field
• Moving a Field
• Deleting a Field
• Renaming a Field

Formatting and Printing a Datasheet

• Changing the Field Width
• Changing the Record Height
• Freezing Fields on the Screen and
  Printout
• Formatting Cells
• Printing a Table or Query
• Changing the Page Setup
• Exporting a Table or Query
• Changing the Font (Optional)
  I. Moving a Field (Optional)
  J. Hiding a Field (Optional)
  K. Unhiding a Field (Optional)