Microsoft® Office Access™ 2007 Plain & Simple

Chapter 9. Creating Queries

In this section:

• Creating a Query Using the Query Wizard

• Editing a Query in Design View

• Using Criteria to Focus Query Results

• Using Queries to Calculate Values

• Finding Duplicate Records

• Finding Unmatched Records

• Writing Query Results to a New Table

• Creating an Update Query

• Creating a Crosstab Query

• Finding the Largest and Smallest Values in a Field by Using a Query

The database object used to store data is the table, but even the best-designed table has limitations. For example, if a table holds more than a few dozen records, it’s difficult to look through the table and find records that meet a particular criterion. You may want to display all orders from a specific customer without having to wade through the entire table to find ...