O'Reilly logo

F. Scott Barker's Microsoft® Access 2000 Power Programming by F. Scott Barker

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

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

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