Read Case Study 5 on pages 147–151. A copy of Dean’s database is stored in the Access file Ch05Ex02_E7e.

Download a copy of this file and create queries to provide the following data:

a. Sort the pianos from high quality to low.

b. Sort the pianos from high quality to low and, within each quality, sort by Building and then by Location within that building.

c. List the pianos in the shed and sort the results by manufacturer.

d. List all of the pianos with a Type of ‘Spinet.’

e. Count the pianos for each value of quality (ranging from 1 to 5).

f. Write a query to produce the report in Figure 5-24 on page 150.