Question: how to do a update query in access?
Answer: Step 1: Create a select query to identify the records to update. Open the database that contains the records you want to update. On the Create tab, in the Queries group, click Query Design. ...  Step 2: Update the records. On the Design tab, in the Query Type group, click Update.