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

Chapter 13. Creating and Updating Jet Ta... > Getting Acquainted with Action Queri...

Getting Acquainted with Action Queries

Action queries create new tables or modify the data in existing tables. Access offers the following four types of action queries:

  • Make-table queries create new tables from the data contained in query result sets. One of the most common applications for make-table queries is to create tables that you can export to other applications or that summarize data from other tables. A make-table query provides a convenient way to copy a table to another database. In some cases, you can use make-table queries to speed the generation of multiple forms and reports based on a single, complex query.

  • Append queries add new records to tables from the query's result set.

  • Delete queries delete records from tables that correspond to the rows of the query result set.

  • Update queries change the values of existing fields of table records that correspond to rows of the query result set.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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