Access 2016 Intermediate

Access 2016

Lesson 5 – Creating Action Queries

NOTE A delete query always deletes entire records; you cannot use one to delete data only in specific fields. The records deleted by a delete query are not retrievable. Therefore, you should always preview the selected records by first running a select query. Only after you confirm the selected records are correct, run the delete query.



Procedures

1. Display All Access Objects in the Navigation Pane. 2. Select the Create tab on the Ribbon .

3. Select the Query Design button . 4. Add the desired tables to the query. 5. Close the Show Table dialog box. 6. Add any fields to which you want to add criteria to the design grid. 7. Select the desired Criteria row. 8. Type the desired criteria.

9. Select the Delete button

.

10. Run the query.

11. Select

.



Step-by-Step

Create a delete query.

Open the Packing Slip table in Datasheet view; notice that the order dates start in 2010. Then, close the Packing Slip table and display All Access Objects in the Navigation Pane, if necessary.

OFFICEPRO, Inc.

Page 99