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.