Question: The P04_09.mdb file is an Access database file for a fictional bowling league. This league consists of teams that play matches-one team against another-in
The P04_09.mdb file is an Access database file for a fictional bowling league. This league consists of teams that play matches-one team against another-in various tournaments. Use Power Query to import all the tables into a Data Model. Then use the Power Pivot window to view the data and relationships. There are problems with the relationships, which you would find if you started creating pivot tables-the structure of this database is complex. However, using only the tables themselves in the Power Pivot window, not pivot tables, answer the following questions: a. There are 20 tournaments listed in the Tournaments table. How many of these have been played?
Step by Step Solution
3.46 Rating (162 Votes )
There are 3 Steps involved in it
There are 20 tournaments listed in the T ournaments table To find out how many of these have been pl... View full answer
Get step-by-step solutions from verified subject matter experts
