O'Reilly logo

Microsoft® Access® 2010 In Depth by Roger Jennings

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required