Question
BA 370 MS Access Queries Assignment As detailed in the Database Lab video, Dean Petrich (Deano the Clown) created a database with one table to
BA 370 MS Access Queries Assignment As detailed in the Database Lab video, Dean Petrich (Deano the Clown) created a database with one table to keep track of his inventory of pianos. That database is called BA370 MS Access Queries.accdb. It is available on Canvas. You will be working with Deans data for this assignment. 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. Write a query to produce the report on the Last Slide in the class notes.
This site won't let me include the data... Someone else has posted this question to Chegg but does not have an answer yet.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started