Sort, index, and filter databases.
Sorting is accomplished by applying an ordering system to data and should require determining the sorting option that is most helpful to the user. Sorting options include
- ascending order (i.e., A–Z; 1, 2, 3, ...)
- descending order (i.e., Z–A; 9, 8, 7, ...).
Indexing is accomplished by applying an order to the sorting of multiple fields and should require determining the order of sorting that is most helpful to the user. For example, in an alphabetized table of a personnel directory database, it may be more helpful to sort the Last Name field first, the First Name field second, and the Department field third.
Filtering is accomplished by restricting data-sheet or form records to only those that satisfy some necessary criterion. For example, a City database field may contain many different cities, but filtering will permit specific cities' records to be quickly and collectively viewed.