Tyler created a table with an AutoNumber primary key field, and then entered 10 records in alphabetic order by the values in the LastName field. When he closes and then reopens the table, how are the records ordered?
A) by LastName field
B) by the primary key field
C) by any date field
D) by the first field in the table

Question

Quizplus · Accepted Answer

The records will be ordered by the primary key field, which is an AutoNumber field that assigns a unique number to each record in the order that they are created. It is not affected by changes to other fields in the table, such as the LastName field.

Tyler Created a Table with an AutoNumber Primary Key Field