Access 2016 Intermediate

Access 2016

Lesson 5 – Creating Action Queries

Steps

Practice Data

6. Add the first desired field to the design grid. The field appears in the design grid.

Scroll as necessary and double-click the Unit Price field in the Current Slip 2 field list Click in the Update To row of the Unit Price field

7. Select the Update To row in the desired field. The insertion point appears in the corresponding Update To row. 8. Type the desired update expression. The criteria appear in the Criteria row.

Type [unit price]*1.06

9. Run the query.

A Microsoft Office Access warning box advises you that you cannot undo your changes.

Click

10. Select Yes .

Click

The Microsoft Office Access warning box closes, and Access runs the make- table query, pasting the selected records into the new CurrentSlip table.

Close the query, saving it as Update Slips .

Open the Current Slip 2 table in Datasheet view to verify that the records were updated. Notice that the unit prices have been increased by 6%, then close the table.

C REATING AN A PPEND Q UERY



Discussion

An append query copies records from one table or query and adds them to the end of a different table. Append queries are useful in transferring data from one table to another.

Also use an append query to archive some or all table data. If you have two tables, Current Orders and Old Orders , for example, you can use an append query to copy records from the Current Orders table and add them to the Old Orders table, eliminating the need to manually type the records into the Old Orders table.

OFFICEPRO, Inc.

Page 95