Create queries - Microsoft Access 2013 - page 221

10

In the Update To row of the UnitPrice column, enter [UnitPrice]*1.1 . Then press the
Enter key.

TIP Enclosing UnitPrice in square brackets indicates that it is a database object—in
this case, a field in a table. If you use the Expression Builder to insert this expression,
it looks like this:

[Products]![UnitPrice]*1.1

Because this description of the field includes the table in which it is found, you can
insert this expression in other tables.

11

Without running the query, switch to Datasheet view to display a list of the same unit
prices you viewed earlier; they have not been changed yet.

TIP In a select query, clicking the View button on the Home tab or the Datasheet
View button on the View Shortcuts toolbar is the same as clicking the Run button.
But in an update query, clicking the View button or the Datasheet View button sim-
ply displays a list of the fields that will be updated.

12

Switch to Design view. Then run the query, which displays a message box asking you
to confirm that you want to update the records.

7

This message box cautions that you can't undo the changes you are about to make.

13

In the message box, click Yes , and then switch to Datasheet view. Notice that the
prices in the UnitPrice field have been increased by 10 percent.

CLEAN UP Close the Categories Query, saving your changes. Keep the
GardenCompany07 database open for use in the last exercise.