O'Reilly logo

Microsoft® Office Access™ 2007 Plain & Simple by Curtis D. Frye

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

Examining a Query

When a table has just a few rows, it’s easy to scroll through it to find a few records with the data you want. For larger tables, though, you can create queries to find records that meet a criteria, such as orders from a particular customer. This type of query is known as a select query. Access enables you to create quite a few other types of queries, including queries that create new tables from the query’s results, find duplicate records, or update the values in a table.

View a Query

  1. If necessary, click the Shutter Bar Open/Close Button.

  2. Click the Shutter Bar.

  3. Click Queries.

  4. Double-click a query.

    See Also

    For more information on ...

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