Access 2016 Intermediate

Access 2016

Lesson 5 – Creating Action Queries



Procedures

1. Display All Access Objects in the Navigation Pane. 2. On the Ribbon , select the Create tab.

3. Select the Query Design button . 4. Add the desired tables to the query. 5. Close the Show Table dialog box. 6. Add the first desired field to the design grid. 7. Add additional fields to the query as desired. 8. Select the desired Criteria row. 9. Type the desired criteria.

10. Select the Make Table button . 11. Type the desired table name in the Table Name field.

12. Select

.

13. Run the query.

14. Select

.



Step-by-Step

From the Student Data directory, open ACTION1.ACCDB . Create a make-table query.

Steps

Practice Data

1. On the Ribbon , select the Create tab. The Create tab appears.

Click Create

2. Select the Query Design button.

A blank query opens in Design View .

Click

OFFICEPRO, Inc.

Page 91