Return to Access 2007 Users Guide Page

Creating Queries

 

Click the Create tab, see screen-shot listed below.

 

 

Click Query Design button on the Create ribbon.
 

 

The following Show Table dialog box will appear, asking what tables to use in the query. Click
the Students table in the list and click the Add button, then click the Close button.

 

 


Double-click on the Last_Name and First_Name fields in the Students fields list in the top-pane
of the window to cause the fields to appear in the bottom pane (QBE grid) of the window.
See screen-shot listed below.

 

 

Click Run button (!) on the Design ribbon to get the dynaset (dynamic set of records).
See screen-shot listed below.
 

 

This is the dynaset (dynamic set of records). The records that satisfy the query parameters.
See screen-shot listed below.
 

 

Return to Access 2007 Users Guide Page