How to Sort Data in MS Access

Quick summary

Sorting data in Microsoft Access lets you organize table records in ascending or descending order using the built-in Sort & Filter tools on the Home tab. This quick process requires no queries — just a column selection and a single click to apply the sort order.

Steps

1. In the Navigation Pane, double-click the table you want to sort to open it.
2. Click the column header of the field you want to sort.
3. On the Ribbon, go to the Home tab.
4. In the Sort & Filter group, click Ascending or Descending to set the sort order.
5. The sort order applies automatically to the table data.
6. Click the Save button to save the sorted data.