Microsoft Office Tutorials and References
In Depth Information
Looking at the worksheet, in the Name column, she can see the different product models, but
where is the sales information for these products?
Michelle calls Bill again. He answers:
“Of course there is no sales data about product models. As I said, products are linked
to product models, and sales are about products. If you need to analyze sales by
product model, you definitely need to follow the chain of relationship from sales
to products, then from products to product model. You may then issue a GROUP
BY on the columns you need. By the way, sales are stored in the sales order, which
is a standard master/detail structure.”
Michelle follows Bill’s instruction to search for a relationship between product models and
products, and so she loads the Product table into another Excel worksheet and ends up with a
pretty complex spreadsheet that contains all the information about products. Because there
are too many columns for her purposes, she removes useless columns and ends up with a
worksheet like the one in Figure 4-2.
FIguRE 4-2 The Product table in an Excel worksheet.
There is no information about product models in this table; it contains only product
information. Scrolling down, Michelle notices that, in the ProductModelID column, there are several
products that contain a value. One of these is the first product in Figure 4-3, which contains
6 as ProductModelID.