To specify a sort order for the Data View window display
Ascending order sorts the column starting with the smallest value and ending with the largest value. Descending order sorts the column starting with the largest value and ending with the smallest value.
The sort operation sorts all database table records according to the value specified in the Sort By list, and then continues to sort based on the value specified in the Then By list.
You can sort by a combination of up to five table columns at a time.