Page 377 - Using MIS
P. 377
Q2 What Are the Three Primary Activities in the BI Process? 345
Figure 9-4a
Sample Extracted Data:
Order Extract Table
criteria for those vendor names, as shown in Figure 9-5. In this Access query, the line between
PartNumber in Order Extract and PartNumber in Part Data means that rows of the two tables are
to be combined if they have matching values of PartNumber.
The result of this query is shown in Figure 9-6. Notice there are some missing and question-
able values. Numerous rows have missing values of Contact and Title, and some of the rows
Figure 9-4b
Sample Extracted Data:
Part Data Table
