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

Get Microsoft® Office Access™ 2007 Plain & Simple now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.