Download the database and open it in MS Access. Look at the Piano table, become familiar with the fields, and think of questions you might be able to...

Download the database and open it in MS Access. Look at the Piano table, become familiar with the fields, and think of questions you might be able to answer with database queries. Now create queries to provide the following information. For each one, clip the first few rows of the result, and include the clip in a Word document called BA370 Queries (Your_Name).docx Submit your Word document in Canvas before the assignment deadline.

1. Sort the pianos from high quality to low.

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

3. List all of the pianos with a Type of 'Spinet.'

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

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

6. I need a query to produce the report on the Last Slide in the class notes.