

•	Table of Contents
•	Index

Easy Microsoft® Office Access 2003
By Shelley O'Hara

Publisher	: Que
Pub Date	: September 15, 2003
ISBN	: 0-7897-2959-8
Pages	: 256

About the Author

Acknowledgments

We Want to Hear from You!

It's as Easy as 1-2-3

Introduction

Part 1. Learning Access Basics

Database Window

Starting Access

Opening a Sample Database

Using the Menu Bar

Using Toolbars

Using the Objects Bar

Getting Help

Closing a Database

Quitting Access

Part 2. Creating Databases and Tables

Creating a Database from a Template

Creating a New Blank Database

Opening an Existing Database

Creating a Table Using a Wizard

Creating a Database Table from Scratch

Displaying a Table in Design View

Adding a New Field

Changing a Field Name

Setting a Field's Data Type

Setting the Field Size for a Text Field

Setting the Field Size for a Number Field

Adding a Field Description

Deleting a Field

Setting the Primary Key

Saving the Data Table

Part 3. Entering Data

Opening and Closing a Table in Datasheet View

Entering Data in a Table

Displaying Records

Creating a New Record

Selecting an Entry

Selecting Records and Columns

Freezing and Unfreezing Columns

Hiding and Unhiding Columns

Copying an Entire Record

Sorting Records in Datasheet View

Finding Data

Replacing Data

Formatting the Datasheet

Changing the Font

Checking Spelling

Previewing and Printing a Table

Part 4. Editing a Database's Table Structure

Viewing Field Properties

Using Display Formats

Using an Input Mask

Adding a Field Caption

Entering a Default Value

Requiring an Entry

Indexing a Field

Applying a Smart Tag

Creating a Yes/No Field

Creating a Hyperlink Field

Creating a Memo Field

Creating an Object Field

Adding an Entry to an Object Field

Part 5. Creating and Using Forms

Creating a Form Using an AutoForm

Creating a Form Using a Wizard

Saving a Form

Opening a Form

Using a Form to Add a New Record

Using a Form to Display Records

Using a Form to Edit Data

Using a Form to Select Records

Using a Form to Delete a Record

Using a Form to Search for a Record

Filtering Data by Selection

Filtering Data by Form

Viewing a Form in Design View

Selecting a Form Control

Deleting a Field from a Form

Resizing a Form Control

Moving a Form Control

Adding a Field to a Form

Changing the Tab Order

Viewing and Formatting Form Controls

Formatting Forms

Part 6. Creating Queries

Creating a Select Query with a Wizard

Building a Query from Scratch

Viewing the Query Design

Entering Criteria to Query for an Exact Match

Entering Criteria to Query for a Range of Matches

Entering Multiple Criteria with the OR Operator

Entering Criteria to Match More Than One Field

Sorting Query Results

Adding a Field to a Query

Removing a Field from a Query

Saving a Query

Running a Query

Creating a New Table with Query Results

Deleting Records with a Query

Part 7. Creating Reports

Creating an AutoReport

Creating a Report Using a Wizard

Saving a Report

Opening a Report

Viewing a Report's Design

Selecting a Report Control

Deleting a Field from a Report

Resizing a Report Control

Moving a Report Control

Adding a Field to a Report

Adding Labels to a Report

Adding Headers or Footers to a Report

Drawing on a Report

Adding a Picture to a Report

Sorting and Grouping Data in a Report

Using a Report AutoFormat

Setting Up the Page

Previewing a Report

Printing a Report

Part 8. Managing Your Database

Renaming an Object

Deleting an Object

Password-Protecting a Database

Backing Up the Database

Viewing Database Properties

Setting Up Relationships

Editing Relationships