O'Reilly logo

Microsoft® Office Access™ 2007 Plain & Simple by Curtis D. Frye

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required