How to Update Columns Using Queries in Access 2007
- 1). Open Access 2007 and click the "Office" button. Select "Open." Browse your files and locate a database. Click the database and the "Open" button. The database opens.
- 2). Click the "Create" tab and select the "Query Design" option. The Show Table window opens. Select a table from the Show Table window. Close the Show Table window by clicking the "X."
- 3). Drag fields to the query by clicking the field name and placing them into the query window. Add criteria to locate the fields you plan to update. For example, if you are looking for all of the sales records for your Joe, enter "Joe" in the "Salesman" criteria field. On the ribbon, select the "Update" button. Your query is updated with the update option.
- 4). Change the update field to your desired result. For example, if Joe's sales records are now managed by Nancy, enter "Nancy" in the Saleman update field.
- 5). Run the query by clicking the red "!" button. Access gives you quantity of records that will be updated. Click "Yes." View the updated records by opening the table in the Navigation Pane. Noticed the updated columns in the the table.
Source...