Viewing Query Results

Team-Fly    

 
10 Minute Guide to Microsoft Access 2002
By Joe Habraken
Table of Contents
Lesson 18.  Creating Queries from Scratch

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.

graphics/save.gif Just click the Save button on the Query Design toolbar. Supply a name for the query and then click Yes.

graphics/runbutton.gif 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).

graphics/designviewicon.gif 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.

graphics/18fig06.gif

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.


Team-Fly    
Top
 


10 Minute Guide to Microsoft Access 2002
10 Minute Guide to Microsoft Access 2002
ISBN: 0789726319
EAN: 2147483647
Year: 2000
Pages: 160
Authors: Joe Habraken

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net