Monday, July 28, 2014

How To Getting Information with a Query in Access 2003

How To Getting Information with a Query in Access 2003

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