Queries are great for getting information from a database. With a query, you can filter the data that you view in a table. You establish a set of criteria when you create the query. Then when you run the query, Access 2000 returns only those fields or records that are of interest to you. The results appear in a table in Datasheet view.

The following procedure shows you how to create a query that displays only a select set of fields in a table.

CREATE A SELECT QUERY IN DESIGN VIEW

1. From the list of objects in the Student Census database window, click Queries.

2. Double-click Create query in Design view.

3. In the Show Table dialog box, select the table containing the data you want to access and then click Add. You can add as many tables as you like.

4. Click Close.

5. In the query window, select the fields that you want to include in your query from the table list by double-clicking each one. When you double-click a field, it appears in the field columns of the datasheet.

6. To run your query with the limited fields, click Run  on the Query Design toolbar.

7. Save and close your query.

RUN A QUERY

Once you’ve created a query and saved it in the database, you never need to create that query again. Even when you change or add new records, the new data automatically appears in the query the next time you run it.

1. Click Queries in the database window.

2. Double-click the query you want to run. Access 2000 runs the query and displays the results in Datasheet view.