Sorting+Music+Students+(Access)

Open the // Music Students // database found in the // Music Lessons // folder, and change the layout to // Music Lessons //. Use the database to answer the questions below:

> (a) Which field should he search, and what search criteria should he use? > (b) Which field should he sort > (c) Which pupil comes first in the sorted list? > (Note that the year group is identified by the first number in the tutor group) > (a) Which field should he search on, and what search criteria should he use? > (b) Which field should he sort? > (c) Which pupil comes first in the sorted list? > (a) Which field should he search on, and what search criteria should he use? > (b) Which field should he sort? > (c) Which pupil comes first in the sorted list?
 * 1) Mr Greene, the Head of Music, wants to see all the pupils he teaches sorted by the alphabetical name of the instrument which they play:
 * 1) Mr Greene would like to see all those pupils who play a stringed instrument sorted into year group order
 * 1) Mr Greene would like to see a list of all those pupils who taught by Mr Undsworth, shown in alphabetical order on their first name.