Question: access how to do an update query?
Answer: Create a standard Select query. ...  Select Query → Update to change the type of query to an update action query. Drag the field to be updated in the target table to the query grid. ...  Optionally specify criteria to limit the rows to be updated.