Module 2.1
Task 7 - Complex Sorts


A.M.D.G.

Complex sorts, when you sort two or more fields, can only be carried out when you are designing a Query or a Report.
  • Open the Task 4 file.
  • Create a new query using the method described in Task 5
  • Include all fields, choose a detail report and then choose to modify query design
  • Sort on two fields as shown below

  • Save and close this design, then open the query to view the sorted data.

Answer the following questions in your jotter.

1. Why is a simple sort not always sufficient to organise data?

2. A teacher may produce an alphabetical set list by searching for a specific set then sorting the results. Describe another situation where the school database could be used to perform a similar operation.