Access 2016 Intermediate

Lesson 5 – Creating Action Queries

Access 2016

3. Select the Query Design button . 4. Add the desired tables to the query.

5. Select the Update Query button . 6. Add the field you want to update to the design grid. 7. Select the Update To row in the field you want to update. 8. Type the desired update expression. 9. Run the query.

10. Select

.



Step-by-Step

Create an update query.

Open the CurrentSlip 2 table in Datasheet view. Notice that the first three values in the Unit Price field are $1.75, $40.99, and $3.82. Close the CurrentSlip 2 table and display the Queries object list.

Steps

Practice Data

1. Select the Create tab on the Ribbon . The Create tab appears.

Click Create

2. Select the Query Design button.

A blank query opens in Design View.

Click

3. Add the desired tables to the query. The corresponding field list is added to the query. 4. Close the Show Table dialog box. The Show Table dialog box closes. 5. Select the Update Query button. An Update To row is added to the design grid .

Double-click CurrentSlip 2

Click

Click

Page 94

OFFICEPRO, Inc.