O'Reilly logo

Ten Minute Guide to Access 97 by Faithe Wempen

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

Creating a Simple Query Using Query Wizard

The easiest way to create a query is with a Query Wizard, and the easiest Query Wizard is the Simple Query Wizard. (The other Query Wizards are "special-use" ones that you'll probably never need; they're described later in this lesson.)

The Simple Query Wizard lets you select the fields you want to display. You don't get to set criteria for including individual records, or specify a sort order. (You'll learn to do those things in Lesson 20.) This kind of simple query is useful when you want to weed out extraneous fields, but you still want to see every record.

Select Query

The query that the Simple Query Wizard creates is a basic version of a Select query. The Select query is the most common query ...

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