Microsoft® Office Access™ 2007 Plain & Simple

Creating an Update Query

One exciting aspect of business is how quickly things change—of course, it can be difficult to keep track of all those changes! One useful task you can perform with an Update query is to modify values in a table to reflect changes in your business environment. For example, if a supplier increases prices by 5 percent, you can create an Update query that moves through your Products table and updates the records for that supplier’s products.

Update Table Values with a Query

1. Open a query in Design view.

2. Click Update.

3. In the Criteria ...