Action Queries
If a select query were a film, the credits at the end would announce with complete confidence: “No underlying values have been harmed in the making of this query.” If it were an action query, however, the People for the Ethical Treatment of Data would want to keep a close eye on the production.
Until now, you've been working with queries that retrieve records from tables. You have manipulated and calculated the records in various ways. But the values stored in the underlying tables remain untouched.
The action query, as its name implies, is a “do something” query. It is indeed a query, and it's created on the design grid. But instead of simply retrieving records, the action query can have a powerful impact on your tables. I next ...
Get Hands-On Microsoft Access: A Practical Guide to Improving Your Access Skills now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.