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

Introducing Query Design View

In Lesson 19, you created a simple query using the Simple Query Wizard, which selected and displayed fields from a table. There's a lot more you can do with your query when you enter Query Design view.

Query Design view is much like Table Design view and Form Design view, both of which you've encountered earlier in this book. In Query Design view, you can change the rules that govern your query results.

Opening a Query in Query Design View

To open an existing query in Query Design view, follow these steps:

  1. Open the database that contains the query you want to edit.

  2. Queries tab.

  3. Click the query you want to edit; then click the Design button.

The query created in Lesson 19 is shown in Query Design view in Figure 20.1 ...

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