The query that is used to create a new table from all or part of the data in one or more tables is Make-Table query.
- A make table query retrieves data from one or more tables, and then loads the result set into a new table. That new table can reside in the database that is opened, or it can be created in another database.
