• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 8. USING QUERIES TO GET THE MOST... > WORKING WITH ACTION QUERIES: FOUNDAT...

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



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint