Page 55 - Computer - 8

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.

2

3
3. Click the Close button.
The Query Design view opens. The Query
Tools Design tab appears on the Ribbon.
4. Select the fields to be included in the query 4
by using one of the following ways:

• Double-click a field name in the table box.
• Drag a field name from the table box and
drop it in the required column in the grid.
• Click the down arrow in a column and select the required field from the list that opens.

• Type the required field name in the Field box in a column.
5. Drag a column to a required position to change the order of fields in the query.

5

6. Click the Sort box of the field on which you want to sort the result of the query, and choose one
of either Ascending or Descending option.
7. Clear the check mark in the Show box of a field to hide it from display in the datasheet view.
8. Specify the condition for the query in the Criteria box of the desired field.

6

7

8

53