Access 2016 Intermediate

Lesson 5 – Creating Action Queries

Access 2016

E XERCISE

C REATING A CTION Q UERIES



Task

Create action queries.

1. Open ACTION1X.ACCDB . 2. Create a query in Design view. Add the Client Balance Due query and the Client , Courses , and Project tables. 3. Add the following fields to the design grid, in the order listed:

Table/Query

Field

Client Client Client Client Client

Client Name

Address

City

State

Zip

Courses

Course Name

Client Balance Due Balance Due 4. Enter criteria in the Balance Due field to select only those records with an outstanding balance. ( Hint: >0 .) 5. Create a Make-Table Query . Name the table Invoice . Then, run the make-table query, selecting Yes at the prompt. 6. Close the make-table query, saving it as Create Invoice . 7. Open the Invoice table in Datasheet view; notice that the table contains all the information you need to send an invoice. Then, close the Invoice table. 8. Create a query in Design view. Add the Invoice table and then add the Balance Due field to the design grid. 9. Create an Update Query . Then use the Update To row to increase the values in the Balance Due field by five percent. ( Hint: Try using [Balance Due]*1.05 .) Run the query, selecting Yes at the prompt. 10. Close the update query, saving it as Surcharge . 11. Open the Invoice table in Datasheet view; notice that the Balance Due field has been updated. Then, close the Invoice table. 12. Create a query in Design view. Add the Interviews table, and then add each field to the design grid, in the same order as in the table. Run the query and scroll to view the Hire? field. Then, return to Design view.

Page 102

OFFICEPRO, Inc.