CCNC/CCNC Module 5/Retrieving data with queries/Basic Query Operations/Sorting Data
Basic Query Operations |
Retrieving Data | Using Query Filters | Sorting Data | Using the Query Wizard | Self Assessment | Summary & FAQs |
Contents
Sorting Data
Upon completion of this tutorial the learner will be able to:
|
Simple Sorting
Data can be sorted according to numeric or alphabetical order. To sort data open the table to be sorted.
On the table toolbar there are three buttons that can be used for sorting. These are;
- Sort Order - which opens the Sort Order dialog.
- Sort Ascending - which sorts the records A to Z or if numbers, lowest to highest.
- Sort Descending - which sorts the records Z to A or if numbers, highest to lowest.
Press this button to sort all the records for the selected column in an ascending order
Press this button to sort all the records for the selected column in an descending order
Opening the Sort Dialog
To create a more advanced sort that uses more than one column within the sort click the Sort button on the toolbar. This will present the "Sort Order" dialog.
The Sort Order dialog allows a sort to be created with up to three fields using either an ascending or descending order. After choosing the sort fields and the order click OK to run the sort, the table should then be sorted based upon the sort order entered. (Remember: to remove the sort order, use the "Remove Filter / Sort" button on the toolbar.)
Test your knowledge