• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 16. Database Techniques > Sorting and Filtering

Sorting and Filtering

Sorting and filtering work the same way with a database as with a list.

To sort a database:

1.
Click any cell in the database (Figure 16.8).

Figure 16.8. Click any cell in the database.


2.
Choose Data > Sort (Figure 16.9).

Figure 16.9. Choose Data > Sort.


3.
In the Sort dialog box, choose a field name from the Sort by pull-down menu (Figure 16.10).

Figure 16.10. Choose the sort criteria from the Sort by pull-down menu.


4.
To perform secondary and tertiary sorts on the data, choose additional fields from the two Then by pull-down menus also in the Sort dialog box.

5.
To sort from smallest to largest or earliest to latest, choose Ascending. To sort from largest to smallest or latest to earliest, choose Descending.

6.
Click OK. The data in the database is sorted (Figure 16.11).

Figure 16.11. The database is sorted.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint