• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 8. Queries > Building Queries

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 Grid

Often you'll want to select specific fields from a field list to include in the query. But sometimes you'll want to add every field in the list. You can add all the fields by using either the “asterisk” method or the “drag-'em-all” method.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint