Viewing Query Results
After you have selected the fields for the query and have set your field criteria, you are ready to run the query. As with tables created in the Design view and forms created in the Design view, you should save the query after you have finished designing it.
Just click the Save button on the Query Design toolbar. Supply a name for the query and then click Yes.
Now, you are ready to run the query. Click the Run button on the Query Design toolbar, or choose Query, Run. The query results appear in a datasheet that looks like an Access table (see Figure 18.6).
After you have reviewed the results of your query, you can quickly return to the Query Design view to edit the query fields or criteria. Just click the Design View button on the toolbar.
Figure 18.6. The results of the query appear as a table datasheet.
In this lesson, you learned how to choose the fields for a query and specify criteria in the Query Design view. In the next lesson, you learn how to create reports in Access by using the AutoReport feature and the Report Wizard.