Question

Access allows you to sort on multiple fields only if each field is sorted in ascending order.
True / False.

Answer 1

Answer:

Microsoft Access allows us to sort on multiple fields only if each field is sorted in ascending order.

This is False.

Explanation:It’s straightforward to sort data by one column in Access, when it comes to sorting by two columns, you need to take a couple of additional steps. There is no restriction or requirement of sorted columns before multi-level sorting.

1. Steps are:
2. Select the entire data set that you want to sort.
3. Click the Data tab.
4. Click on the Sort Icon (the one shown below). This will open the Sort dialog box.
5. in the Sort Dialogue box, make the following selections
6. Sort by (Column): Region (this is the first level of sorting)
7. Sort On: Values
8. Order: A to Z
9. If your data has headers, ensure that ‘My data has headers’ option is checked.
10. Click on Add Level (this will add another level of sorting options)
11. In the second level of sorting, make the following selections:
12. Then by (Column): Sales
13. Sort On: Values
14. Order: Largest to Smallest
15. Click OK