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 ...

Get Microsoft® Office Access™ 2007 Plain & Simple now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.