Final answer:
A Make-Table query applies criteria to a table and saves the results in a new table. It's used to manage large databases or to focus on a subset of data. An example could be creating a table of customers from a specific region.
Step-by-step explanation:
A query that will apply criteria to a table and store the results in a new table is known as a Make-Table query.
Make-Table queries are particularly useful when you need to create a new table from a subset of data, or when you are working with large databases and want to make a separate smaller table that contains only the information you need. For example, if you have a large customer database, and you want to create a new table that only includes customers from a specific region, you would use a Make-Table query with the appropriate criteria to extract this information. The new table would be stored within the existing database.
A query that will apply criteria to a table and store the results in a new table is a select query.
For example, in SQL, you can use a select query with a WHERE clause to apply criteria to a table. The result of the query can then be stored in a new table using the CREATE TABLE AS statement.
Here's an example:
CREATE TABLE new_table AS SELECT * FROM original_table WHERE criteria;