Access 2007[c] The Missing Manual

8. Queries That Update Records

Queries are most famously known for their ability to show small subsets of huge amounts of information. This type of query's called a select query , and it's the variety you learned about in the previous two chapters.

Many Access fans don't realize that queries have another identity. Not only can you use them to search for information, but you can also use them to change data. Queries that take this more drastic stepwhether it's deleting, updating, or adding recordsare known collectively as action queries .