Hanna created a backup table listing renters in Springfield County, and now wants to add records to that backup table from the Rentals table for renters in Lincoln County. What type of query should she create to accomplish this?
A) Make-Table
B) Append
C) Top Values
D) Update

Question

Quizplus · Accepted Answer

To add records from one table to another, an Append query should be created. The Make-Table query creates a new table based on the results of a query, rather than adding records to an existing table. The Top Values query returns only the top few records based on a specified criteria. The Update query changes the values of existing records in a table, rather than adding new records to the table.

Hanna Created a Backup Table Listing Renters in Springfield County