(Based on the Classical CDs database) Create a query to find the following fields: Artist from Artists,...
Question:
(Based on the Classical CDs database) Create a query to find the following fields: Artist from Artists, Composer from Composers, Conductor from Conductors, Orchestra from Orchestras, and Title from Works. Return this to Excel as a pivot table. Then use the pivot table to find a list of all works by Chopin, Frederic. The collection has hundreds of works by Chopin. Why are you seeing only a few of these in the pivot table? What could you do differently to see all of them?
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Related Book For
Business Analytics Data Analysis and Decision Making
ISBN: 978-1305947542
6th edition
Authors: S. Christian Albright, Wayne L. Winston
Question Posted: