Microsoft® Access® 2010 Plain & Simple

Chapter 8. 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

• Creating a Parameter Query

• 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

Database tables store data, 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 might, for example, want to display all orders from a specific customer without having to wade through the ...