Microsoft Office Tutorials and References
In Depth Information
Understanding the Internal Data Model
Figure 17-17: Remove the check next to Import Relationships Between Tables.
7. In the Import Data dialog box, choose PivotTable Report and click OK to create the base
8. Go to the Ribbon, click the Data tab, and choose Relationships.
The Manage Relationships dialog box opens, as shown in Figure 17-18.
9. Create the needed relationships and then click the Close button.
As mentioned earlier in this chapter (in the section called “Build Relationships for the
Tables in the Internal Data Model”), when creating the relationships for your Data
Model, you will need to remain aware of which table you designate in the Related
Column (Primary) drop-down field on the Manage Relationships dialog box. The table
you use in this field cannot have duplicates or null values in a field being used as the
primary key. So in this scenario, you will not be able to designate the TransactionMaster
table in this field, as it contains transactional line items that may contain duplicates.
Figure 17-18: Create the needed relationships for the tables you just imported.
If all went well, you should end with a pivot table similar to the one illustrated in
Figure 17-19. In just a few clicks, you created a powerful platform to build and maintain pivot
table analysis based on data in an Access database!