13. Creating and Updating Access Tables with Action Queries

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

image Make-table queries create new tables from the data contained in query resultsets. 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. ...

Get Microsoft® Access® 2010 In Depth now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.