From the course: Office 365: Access Essential Training

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Sorting table data

Sorting table data - Microsoft Access Tutorial

From the course: Office 365: Access Essential Training

Start my 1-month free trial

Sorting table data

- A common task with any table of data is to sort the contents to bring relevant records to the top. On the home tab of the ribbon, we have a group here called Sort & Filter, and it has all the tools we need to do just that. Let's go ahead and open up our Guests table by double-clicking on it here in the navigation pane, and we can take a look at how the sorting will work. Right now, our records are in the order that they were put into the database, with the first record, GuestID #1 at the top, and then GuestID #201 at the bottom. I can sort these records based off of any field that I choose, however. To put them alphabetically by last name, all I need to do is click any field in the last name column here, and choose Ascending or Descending from the ribbon. I'll go ahead and choose Ascending, and you'll see the names sort this way. I can also right-click on this column header up here and choose Sort A to Z or Z to A from this pop-up menu. Or, on the very right-hand side of the menu…

Contents