Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Seven Databases In Seven Weeks A Guide To Modern Databases And The NoSQL Movement

Authors: Luc Perkins, Eric Redmond, Jim Wilson

2nd Edition

1680502530, 978-1680502534

More Books

Students also viewed these Databases questions