Access 2016 Intermediate

Access 2016

Lesson 5 – Creating Action Queries

Close the query, saving it as Current .

Open the CurrentSlip table in Datasheet view to verify that it was created with the selected records. Then, close the CurrentSlip table.

C REATING AN U PDATE Q UERY



Discussion

An update query is used to change data values in an existing table. Update queries save time because they allow you to update a large number of records at one time. You can use an update query, for example, to increase all the values in a Unit Price field by 10%.

Also use an update query to calculate and enter values in a table field. For example, use an update query to multiply the value in the Unit Price field by 75% and place the result of the calculation in the Sale Price field of the same record.

If you do not want to update all records in the table, use criteria to select only those records you want to update. For example, add criteria to an update query to increase the unit price on only one product line, rather than on all products.

Not all table fields have to be included in an update query. Include only those fields you want to update and those to where you want to add criteria.

NOTE When you use field names in any expression, they must be enclosed in square brackets ( [ ] ). An update query permanently alters field values; make sure that the correct records are selected and that the expression in the Update To row of the design grid is correct.



Procedures

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

OFFICEPRO, Inc.

Page 93