Which query is used to copy records to a new table based on criteria?

The Make Table query is specifically designed to create a new table from the results of a query. This type of query allows you to define criteria for which records to include, effectively copying the selected records into a new table.

When you set up a Make Table query, you can specify fields from an existing table and apply criteria to filter which records should be transferred to this new table. This is particularly useful for organizing data or creating subsets of data based on specific needs.

In contrast, an Update query modifies existing records in a table rather than creating new ones, and an Append query adds records to an existing table instead of creating a new one. A Select query is used to retrieve data and display it but does not create new tables or copy records, meaning it does not fulfill the requirement of copying records to a new table based on criteria.