Make Table Query in MS Access - Office 365

"Make Table" query is used when you need to copy the data in a table, archive data or save query results as a table. A Make Table query retrieves data from one or more tables and then loads the result set into a new table. The new table can be created in the current database or another database. This video explains in detail how to use "Make Table" query in MS Access.