• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Sorting Table Data

By default, Access displays records in the order of the primary key. If your table doesn't have a primary key, the records display in the order in which you enter them. Access uses sorting methods to display records in the desired order. If an index exists on the field in which you sort the records, the sorting process for large tables is quicker. Access automatically uses indexes, if indexes exist, to speed the sort in a process called query optimization.

The following sections show how to use Access's sorting methods to display records in the sequence you want. The Customers table of Northwind.mdb is used for most examples in this chapter because it's typical of a table whose data you might want to sort.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint