Hands-On Microsoft Access: A Practical Guide to Improving Your Access Skills

Building Queries

Let's say you're building a query from a single field list—that is, one table or one query. The fastest way to get started is to select the table or query that contains the data you want to use in the Database window and choose Insert, Query. In the New Query dialog box, you have several choices for creating a query. The Simple Query Wizard is simple—so simple, in fact, that it doesn't help much in creating queries. The other query wizards—Crosstab (discussed in Chapter 9) and Find Duplicates and Find Unmatched (both described in this chapter)—all have their uses. But they will likely represent a minority of the queries you create. Most of the time, you'll use the default Design View selection.

Adding All Fields to the Design ...