O'Reilly logo

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

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required