7. 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 Chapter 6.
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 .