What query would you use if you were given an Excel spreadsheet of old customers and asked to incorporate these records into the Customers table of your database?
A)Make table
B)Append
C)Update
D)Crosstab

Question

Quizplus · Accepted Answer

The most appropriate choice for adding the old customer records into the Customers table in the database is the Append query. An Append query is designed to add new records to an existing table. In this case, the Excel spreadsheet of old customers can be imported into Access and then used as the source of the data for the Append query to add the new records to the Customers table.

What Query Would You Use If You Were Given an Excel