Home > Sample chapters > Microsoft Office > Access

Creating Queries in Access 2010

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 cell of the column you’ll use to select the records to update, type the expression used to select which values should be updated.

  4. In the Update To cell of the column that contains the value to be updated, type the expression used to update the values.

  5. Click Run.

    httpatomoreillycomsourcemspimages613762.jpg