When an Append query is run on a table that has no primary key,where do the new records appear?
A)Top of the table
B)Bottom of the table
C)Alphabetically in ascending order mixed in with the current list
D)You cannot run an Append query on a table with no primary key

Question

Quizplus · Accepted Answer

When an Append query is run on a table with no primary key, the new records will be added to the bottom of the table. This is because without a primary key, there is no established order for the records to be sorted in, so they simply get added to the end of the current list.

When an Append Query Is Run on a Table That