Microsoft Access Developer Interview Question:

Tell us when I Assigned A Primary Key To My Table In Microsoft Access, I Was Expecting My 11112 To Be Sorted. Am I Using The Correct Procedure?

Submitted by: Muhammad

Some developers occasionally rely on indexes to sort their data, but shouldn't. Thai's because an index is an internal Jet operation that relies on internal rules to speed sorting, which is not the same as actually performing the sort. Records are not stored differently or changed. The sort is not performed until an action is being taken against the data like a query. This is not the same as simply opening a table in its Datasheet View. Although an index often appears to sort data, those internal rules often conflict with normal sorting practices and can have unexpected results. Sorting can be accomplished through the use of a query where ascending or descending can he specified against any one of the fields chosen from the table.
Submitted by: Muhammad