Which of the following would you use to create a history table,which you could then use to store old records?
A) update query
B) append query
C) delete query
D) make table query

Question

Quizplus · Accepted Answer

A "make table query" creates a new table based on the data and structure of an existing table or tables. This would be the best choice for creating a separate history table to store old records.

Which of the Following Would You Use to Create a History