Technologies Humanware Inc. APBT320 Manuel D’Utilisation
BrailleNote Apex QT User Guide
18-421
18.4
Sort Orders.
After you have defined the fields you require for a database, the next priority is to define how you
want the records sorted. This determines the order in which the records are presented during the
lookup records process. For example, sort the records in chronological order by the "Appointment
Date", when looking for all records with "sore throat" in the “Reason for appointment” field.
want the records sorted. This determines the order in which the records are presented during the
lookup records process. For example, sort the records in chronological order by the "Appointment
Date", when looking for all records with "sore throat" in the “Reason for appointment” field.
In a membership list, where there are separate fields for a member‟s first name and last name, it is
most practical to initially sort the records by last name. Where there are several members with the
same last name, you would sort by first name. For example, those members with Jones as their last
name would be sorted in the following order: Alice Jones, Ben Jones, and Sally Jones.
most practical to initially sort the records by last name. Where there are several members with the
same last name, you would sort by first name. For example, those members with Jones as their last
name would be sorted in the following order: Alice Jones, Ben Jones, and Sally Jones.
Depending on the type of field you are sorting, records can be sorted into one of the three categories
below:
below:
1. Chronological order - listing by date field type, from earliest to latest.
2. Alphabetical order - listing by string field type.
3. Numerical order - listing by number field type in ascending order.