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 - Microsoft Access Tutorial
From the course: Office 365: Access Essential Training
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…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.