How to Create Update Queries in Access 2007

Access queries extract information out of the database and let you question the data in the database. Action queries are used to perform actions in the Access 2007 database. There are four action queries available: update, append, make-table and delete. When using the update query, you can do a mass update in the database in just a few steps. The update query option appears on the ribbon when working with queries.

Instructions

1. Open Access 2007. In the right pane, select one of the databases in the "Recent Open Database." The database opens.

2. Click the "Create" tab and select the "Query Design" button. The "Show Table" dialog box appears. Add a table to the query by clicking the table name and the "Add" button. Close the Show Table dialog box by clicking the "Close" button.

3. Add fields to the query by double clicking field names from the table box. Transform this query into an update query by clicking the "Update" button. The update field appears in the query.

4. Add criteria in the field's "Criteria" section. For example, if you are looking for all sales accounts belonging to Jacobs, enter "Jacobs" in the "Account" field. If his accounts have been transferred to Jenkins, change the update field to "Jenkins."

5. Run the query by clicking the red "!" button. Access informs you about the quantity of records that will be updated. Click "Yes" to confirm this update. Locate the table in the Navigation Pane and double click it to open it. Review the newly changed records.

References

• Microsoft: Update Data By Using A Query