O'Reilly logo

Hands-On Microsoft Access: A Practical Guide to Improving Your Access Skills by Bob Schneider

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required