What is the function of a Make Table Query?

What is the function of a Make Table Query?

• A. Creates a brand new table from query results
• B. Updates data
• C. Appends data
• D. Deletes data

Answer: (A)

A Make Table Query creates a brand new table from the results of a query. It takes the data produced by a SELECT (with any filters, joins, or aggregations you specify) and writes those rows into a new table you define. The original source data remains unchanged, while you gain a fresh table that holds exactly that result set at the moment the query runs. This is handy for creating static subsets or summarized datasets for reporting or further processing, without altering any existing tables. The other options describe modifying existing data (updating), adding new rows to an existing table (appending), or removing rows (deleting), which is why they aren’t the correct function.

A Make Table Query creates a brand new table from the results of a query. It takes the data produced by a SELECT (with any filters, joins, or aggregations you specify) and writes those rows into a new table you define. The original source data remains unchanged, while you gain a fresh table that holds exactly that result set at the moment the query runs. This is handy for creating static subsets or summarized datasets for reporting or further processing, without altering any existing tables. The other options describe modifying existing data (updating), adding new rows to an existing table (appending), or removing rows (deleting), which is why they aren’t the correct function.