[ Team LiB ] Previous Section Next Section

Getting Information with a Query

Access saves and lists the queries you create on the Queries tab in the Database window. You can double-click a query to run it and display the results. When you run a query, the query results show only the selected fields for each record in the table that matches your selection criteria.

Open and Run a Query

graphics/1_icon.jpg

In the Database window, click Queries on the Objects bar.

graphics/2_icon.jpg

Click the query you want to run.

graphics/3_icon.jpg Click the Open button.

The query opens in a table called a dynaset. The dynaset displays the records that meet the specifications set forth in the query.

graphics/06inf03.jpg

    [ Team LiB ] Previous Section Next Section