How to Create an Update Action Query in Microsoft Access

Use an Update query to make global changes to a group of records or to many tables at once. For example, if you have changed the price on a product you are selling, you could update all pricing records simultaneously. These instructions apply to MS Access 97.

Instructions

Difficulty: Moderate

Things You’ll Need:

• Microsoft Access

1. Create a query with the tables containing the records you want to update.
2. From Query Design view, open the Query menu and select Update Query.
3. Locate the fields you want to update on the design list, and drag them to the grid.
4. In the Criteria cell that appears, type in the criteria to be used, if any.
5. Use the Update To cell to enter the value you are using to change the fields. Switch to Datasheet view to view the records that will be updated.
6. Go back to Design view to return to the query. Make any changes needed.
7. Click Run on the toolbar to update the records.

Who Can Help:

• Find Computer, Electrical and Telephone Services Here. Compare Up to 4 Quotes, Free Service & No Obligation.
• Find Electrical Services Here. Compare Up to 4 Quotes, Free Service & No Obligation.