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 16.6).

Figure 16.6. The results of the query appear as a table datasheet.


graphics/datasheetview.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.

Microsoft Office 2003 All-in-One
Microsoft Office 2003 All-in-One
Year: 2002
Pages: 660
Authors: Joe Habraken

Similar book on Amazon © 2008-2017.
If you may any questions please contact us: