Access 2016 Intermediate

Lesson 5 – Creating Action Queries

Access 2016

Steps

Practice Data

1. Select the Create tab on the Ribbon . The Create tab appears.

Click Create

2. Select the Query Design button.

A blank query opens in Design View .

Click

3. Add the desired tables to the query. The corresponding field list appears in the query.

Double-click Packing Slip

4. Close the Show Table dialog box. The Show Table dialog box closes.

Click

5. Add any fields to which you want to add criteria to the design grid. The corresponding fields appear in the design grid. 6. Select the desired Criteria row. The insertion point appears in the corresponding Criteria row.

Double-click the Ord Date field in the Packing Slip field list

Click in the Criteria row of the Ord Date field

7. Type the desired criteria.

Type between 1/1/2010 and 12/31/2011

The text appears in the Criteria row under the appropriate field.

8. Select the Delete button.

A Delete row is added to the design grid.

Click

9. Run the query.

A Microsoft Office Access warning box advises you that the changes cannot be undone.

Click

10. Select Yes .

Click

The Microsoft Office Access warning box closes, and Access runs the delete query, removing the corresponding records from the table.

Close the query; save it as Delete Old Slips .

Page 100

OFFICEPRO, Inc.