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.
If necessary, click the Shutter Bar Open/Close Button.
Click the Shutter Bar.
Double-click a query.
For more information on ...