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

Action Queries

With Action queries, you can easily modify data without writing any code, and these queries are often more efficient than performing the same task by using code. Four types of Action queries are available: Update, Delete, Append, and Make Table. You use Update queries to modify data in a table, Delete queries to remove records from a table, Append queries to add records to an existing table, and Make Table queries to create an entirely new table. Each type of query and its appropriate uses are explained in the following sections.

Update Queries

Update queries are used to modify all records or any records meeting specific criteria. They can be used to modify the data in one field or several fields (or even tables) at one time, such as a query that increases the salary of everyone in California by 10 percent. As mentioned, using Update queries is usually more efficient than performing the same task with VBA code, so they're considered a respectable way to modify table data.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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