课程: Access 2016 Essential Training

今天就学习课程吧！

今天就开通帐号，24,700 门业界名师课程任您挑！

Sorting table data

Sorting table data

课程: Access 2016 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…

内容