A new table created by a(n)____ query may contain a subset of the fields and records in an existing table.
A)append
B)make-table
C)delete
D)update

Question

Quizplus · Accepted Answer

A make-table query creates a new table based on a subset of fields and/or records from an existing table. This is useful when you want to work with a smaller or differently formatted version of an existing table, without modifying the original data. Append queries add records to an existing table, delete queries remove records from a table, and update queries modify existing data within a table. None of these choices fit the description of creating a new table with a subset of fields and records.

A New Table Created by A(n)____ Query May Contain a Subset