dolution

Create an appropriate query and return the results to Excel as a pivot table. The pivot table should allow you to choose a department name (from the Filters area or a slicer) and see the number of courses given by that department in each category. (Note that some categories aren’t given by some departments.) Problems 36–38 (and 43–44 in the Level B section) are based on the file Northwind.mdb. Open this file in Access, click Database Tools, and select Relationships to see the relationships diagram. Orders at North wind are taken by employees from customers for products supplied by suppliers, and the orders are shipped by shippers. The Order Details table is required because one order can be for several products.