WORKING WITH ACTION QUERIES: FOUNDATIONS FOR POWER
Action queries can manipulate large numbers of records very quickly. They also provide the basis for moving data into a database and managing data once it resides in tables. The best way to develop an Action query is to develop a standard Select query, and then convert it to an Action query. This way, you can view the records that will be used or affected by the query and then determine whether the query criteria is correct before creating the Action query.
Tip
By choosing to have the query design grid switch to Datasheet view instead of using the Run command, you can also check out what the Action query will affect. To do so, click the Datasheet View button on the far left of the Query Designer ...
Get F. Scott Barker's Microsoft® Access 2000 Power Programming 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.
