Access 2016 Intermediate

Lesson 5 – Creating Action Queries

Access 2016

Steps

Practice Data

11. Select the Append To list.

Click Append To

A list of available fields appears .

12. Select the matching field.

Click the Order Number field Click in the Criteria row of the Ord Date field

The field is added to the design grid.

13. Select the desired Criteria row. The insertion point appears in the corresponding Criteria row.

14. Type the desired criteria.

Type between 1/1/2012 and 12/31/2012

The text appears in the Criteria row.

15. Run the query.

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

Click

16. Select Yes .

Click

The Microsoft Office Access warning box closes, and Access runs the query, appending records to the table accordingly.

Close the query; save it as Append Slips . Open the CurrentSlip 2 table in Datasheet view. Notice that the CurrentSlip 2 table now has 166 records. Then, close the CurrentSlip 2 table.

C REATING A D ELETE Q UERY



Discussion

Use delete queries to maintain the appearance, usefulness, and efficiency of tables in a database. When records have been appended or archived to a secondary table, or they are simply no longer needed, it is a good idea to delete them. Deleting records saves disk space and makes tables more efficient; the more data there is in a table, the more time it takes to save, sort, and query a table.

Delete queries enable you to apply criteria to select and delete groups of records at one time.

Page 98

OFFICEPRO, Inc.