Understanding How You Can Update Query Results
If you haven't realized it yet, you can usually update the results of your query. This means that if you modify the data in the query output, the data in the tables underlying the query is permanently modified.Pitfalls of Multitable Queries" and "Row Fix-Up in Multitable Queries."