Sorting+Bands+(Access)

Open the database Bands found in the Artists and Groups folder. Now answer the following questions:

> (a) Which field(s) would he sort the database on? > (b) Is this a simple or complex sort? > (c) Should the database be sorted in ascending or descending order? > (d) Which band has released the most studio albums? > (a) What is the primary sort field? > (b) What is the secondary sort field? > (c) Which band will appear first in the Rock section? > (d) Which band will appear first in the Rap section? > (a) What is the primary sort field? > (b) What is the secondary sort field? > (c) Which band has been together for the longest period of time? > (d) Which band has been together for the shortest period of time?
 * 1) A music magazine is writing an article on bands who have released the most studio albums.
 * 1) The manager of Rappin' Records wants to organise his shop into different sections according to the style of music, with bands in each section listed in alphabetical order.
 * 1) Music journalist Lee Francis wants to use the database to sort all bands in order of the year in which they were formed. Bands formed in the same year should be sorted into alphabetical order