Working with databases/Create a database/Records and tables

Sort a table
We can sort a table - that is, we sort the records into numeric or alphabetical order.



In the heading row that contains the field names, locate the small black triangle. Click on this.

A menu will pop up. From the menu choose how you would like to sort your table: Sort A &rArr; Z or Z &rArr; A. This also works in fields that contain numerical data.

''Although you will not be assessed on this, you can also use this menu to filter out and display only certain information. In our example we could choose to display only students from Glenfield.''

The same principle applies to sorting a query (You will learn how to create a simple query later on) which is displayed on the screen like a table.

To clear and reset sorting, go to Home Tab &rArr;Sort and Filter Group &rArr;Clear All Sorts