Sorting and searching

For this activity, we will use a file already created for you. This file contains information about holidays and is called Travel.

Sorting

There are likely to be times when you would like to view the information in your table in a different order than you created it. Once the data is stored, it can be organised using the data in one of the fields in either ascending or descending order.

For example, if you had a table holding details of all the invoices your customers are due to pay, you could view the data in order of date due (soonest first), or by value of the invoice, or alphabetically by customer name.