Access 2016 Intermediate

Access 2016

Lesson 5 – Creating Action Queries

13. Have the query select only those records that have the Hire? field check box selected. ( Hint: Use a criteria of true .) Run the query to view the results. Then, return to Design view. 14. Create an Append Query to the Trainer table. Then, run the append query. Select Yes to append the records. 15. Close the append query, saving it as New Trainers . 16. Open the Trainer table in Datasheet view to verify that the new records were added. Then, close the Trainer table. 17. Create a new query to remove all the newly hired trainers from the Interviews table, since they are now listed in the Trainer table. Add only the Interviews table to the query, and then add only the Hire? field to the design grid. 18. Add a criterion of true to the Hire? field. Create a delete query. Then, run the query, selecting Yes at the prompt. 19. Close the delete query, saving it as Delete Hires . 20. Open the Interviews table in Datasheet view to verify that the records were deleted. Then, close the Interviews table. 21. Close the database file.

OFFICEPRO, Inc.

Page 103