Although you probably entered your records into the table in some kind of logical order, perhaps by employee number or employee start date, being able to change the order of the records in the table based on a particular field parameter can be extremely useful. This is where the Sort feature comes in.
Using Sort, you can rearrange the records in the table based on any field in the table (more complex sorts can also be created that allow you to sort by more than one field, such as Last Name and then First Name ). You can sort in either ascending (A to Z, 1 to 10) or descending (Z to A, 10 to 1) order.
The fastest way to sort is to use either the Sort Ascending or Sort Descending button on the Table toolbar. However, this easy road to sorting limits you to sorting by one field or adjacent fields.
Follow these steps to sort records:
As already mentioned, you can sort a table by adjacent fields using the sort buttons . All you have to do is select the field headings for those particular field columns, and then click the correct sort button. For example, if you wanted to sort a customer table by last name and then first name, the last name would have to be in the column that is directly to the left of the First Name field.