Microsoft Office Tutorials and References
In Depth Information
Changing data in a table with an Update query
Change data based on data in another table
1 Start with a select query, and click Update.
2 Select the fields to be updated.
3 Type the name of the joined table and field. (IntelliSense will assist
4 Click Run to execute the query.
TIP When running an action query that has been saved, you
do not need to open the query in design view. If you
doubleclick the query in the navigation window, it will run the query after
asking you whether you’re sure you want to proceed.