Access 2016 Intermediate

Lesson 5 – Creating Action Queries

Access 2016

C REATING A M AKE - TABLE Q UERY



Discussion

A make-table query creates a new table from data in existing tables and queries. Make-table queries have many uses. The new table can be a duplicate of an existing table to serve as a data backup. You can then delete old records from the original table, for example, leaving them stored in the backup table.

Make-table queries can create a compact version of an existing table, displaying only those fields you want to see. They can also bring fields from many tables into one table, making reports and queries based on the new, single table run faster.

Limit both records and fields in a new table as needed. If you use criteria in a make- table query, only records that meet the criteria will be added to the new table.

Creating a make-table query

NOTE The fields in the new table retain the data type and field size properties assigned to them in the source tables.

Page 90

OFFICEPRO, Inc.