How to Create Update Query MS Access

Quick summary

An MS Access Update Query lets you modify existing records in a table using a structured Query Design interface. This step-by-step demo shows how to create, configure, and run an Update Query without writing SQL manually.

Steps

1. Click on the Create tab in the MS Access ribbon.
2. Click Query Design to open a new query in Design view.
3. Select the table you want to update and click Add Selected Tables.
4. In the Query Design tab, click Update in the Query Type group to switch the query type.
5. Drag the fields you want to update into the grid, or double-click them from the table to add them.
6. In the Update To row for each field, enter the value or expression to apply to that field.
7. Click the Run button on the ribbon to execute the Update Query.
8. When MS Access prompts you to confirm, click OK to proceed and apply the updates.