Make Table Query Creating a new Table using SQL in MS Access - Office 365

A Make Table query creates a new database table from the results of a SQL query. A make table query retrieves data from one or more tables based on a criteria and then inserts the results into a new table. The new table can be in the database that you have open or you can create it in another database. Make Table queries use the SELECT...INTO new table statement to create table. A summary query also can be used to create a new table. This video explains in detail the different ways you can use SQL statements to create a new table.

To download the example Access file please click on the link below