• 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. In fact, using Action queries is often a more efficient method than 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

You use Update queries to modify all records or any records meeting specific criteria. You can use an Update query to modify the data in one field or several fields (or even tables) at one time (for example, a query that increases the salary of everyone in California by 10%). As mentioned, using Update queries is usually more efficient than performing the same task with Visual Basic for Applications (VBA) code, so Update queries are 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