Microsoft Office Tutorials and References
In Depth Information
Consider an example. Suppose you want to give all nonsalaried workers a $0.50 per hour pay raise.
Because you have only three nonsalaried workers, it would be easy to change the Wage Rate data in the table.
However, if you had 3,000 nonsalaried employees, it would be much faster and more accurate to change the
Wage Rate data by using an Update query that adds $0.50 to each nonsalaried employee
s wage rate.
AT THE KEYBOARD
Now you will change each of the nonsalaried employees’ pay via an Update query. Figure B-40 shows how to
set up the query.
Query setup for an Update query
So far, this query is just a Select query. Click the Update button in the Query Type group, as shown in
Selecting a query type
Notice that you now have another line on the QBE grid called Update To:, which is where you specify the
change or update to the data. Notice that you will update only the nonsalaried workers by using a filter under
the Salaried field. Update the Wage Rate data to Wage Rate plus $0.50, as shown in Figure B-42. Note that the
update involves the use of brackets [ ], as in a calculated field.