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.

Save your time - order a paper!

Get your paper written from scratch within the tight deadline. Our service is a reliable solution to all your troubles. Place an order on any task and we will take care of it. You won’t have to worry about the quality and deadlines

Order Paper Now


"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"