TechTrain "Just-In-Time"
  Select Program Program Access Steps 1 - 5 of 5
  Topic Filtering and Sorting
  Select Objective Objective Sorting
   
 

Simple Sort
   Step  1
Specifying order of records is called sorting.

Use the Sort Buttons that are located on the Database toolbar.




Simple Sort
   Step  2
Open Table or Query.

We have opened the CustomerTable in our sample database.




Simple Sort
   Step  3
Click on the field or fields you wish to sort.


To select multiple fields use [Shift] + Click.
We will sort on LastName and FirstName.





Simple Sort
   Step  4
Click the Sort Ascending or Sort Descending button.

For NUMBERS, 0 - 9 is Ascending.
For NUMBERS, 9 - 0 is Descending.
For ALPHABETIC, a - z is Ascending.
For ALPHABETIC, z - a is Descending.
There is no distinction between UPPERCASE and lowercase.





Simple Sort
   Step  5
We selected Sort Descending.

 




 
   
Copyright © 1999-2010
Additional help available at techtrain@techtrainteam.com.

TechTrain Home