Skip to main content
Search all of Office.com
Warning: This site requires the use of scripts, which your browser does not currently allow.
See how to enable scripts.
Course summary: Use Update queries to change data in Access 2013
Build an Update query
Start with a Select query, add parameters to it, and run it to make sure it returns only the data you want to change.
Back to Design view, click
Enter your new value on the
row, run the query.
, enter the value from step 3 in the
row, run the query to check your changes.
Update multiple fields or tables
Follow steps 1 and 2 above, but enter criteria in each field or table you want to change, then run the query to make sure you’re seeing just the records you want to change.
Query design view >
> new values, run.
Staying out of trouble
Don’t update calculated fields.
Don’t update primary keys, unless they’re part of a relationship that allows cascading updates. Also, changes to a primary key cascade to all related foreign keys.
Don’t update queries set to return unique values.
Don’t try to update Union queries.
Create and run an update query
Create a select query
Introduction to queries
Video: Use query criteria in Access 2013
Examples of query criteria
More training courses
Office Compatibility Pack