In Access XP sorting records may seem confusing at first. This free lesson offers step-by-step instructions.
When you open a table in Access, the records are displayed in order based on values that appear in the primary key field. In other words, Access defaults to a sort on the primary key when a table is opened. However, a sort can be performed against any field listed in a table. Sorting table records actually changes the table design. When you attempt to close a table after a sort, Access will prompt you to save the changes to the table design.