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
Open a query in Design view.
In the Criteria ...