Page 39 - Code & Click - 8

4. Click the Tables/Queries list down arrow and select the table on which you want to base the query.
5. In the Available Fields list, select a field that you want to include in the query and click the
button.
6. Repeat Step 5 to add more fields to your query.
7. Click the Next button.
The Query Wizard displays options to create a Detail or Summary query.

8. Select the Detail (shows every field of every record)
radio button and click the Next button.
The Query Wizard asks you to specify a name for
the query.
9. Type a name for the query. 8
10. Select the Open the query to view information radio button.
11. Click the Finish button.

9

10

11
Access creates the query and displays the result of the query in the Datasheet view.

Creating a Query Using Query Design
You can also create a query by using the Query Design. A Query design allows you to specify the
fields covered, the condition to retrieve specific records, change the order of fields, and arrange the
retrieved data in a desired manner.
To create a query using Query Design:

1. On the Create tab, click the Query Design button in the
Queries group.
The Show Table dialog box opens.
1

2. Select the table to use for the query and click
the Add button.
3. Click the Close button.

The Query Design view opens. The Query
2 Tools Design tab appears on the Ribbon.
3

37