TABLE 1-1
Customer-Related Data Items Found in the Reports
Contacts Report
Invoice Report
Customer Name
Customer Name
Street
Street
City
City
State
State
ZIP Code
ZIP Code
Phone Numbers
Phone Number
Type of Customer
E-Mail Address
Web Site Information
Contact Log Information (four fields)
Discount Rate
Customer Since
Last Sales Date
Sales Tax Rate
Credit Information (four fields)
As you can see by comparing the type of contact (customer) information needed for each report,
there are many common fields. Most of the data fields pertaining to the customer are found in both
reports. Table 1-1 shows only some of the fields that are used in each report — those related to
customer information. Fields appearing on both reports appear on the same rows in the table,
which allows you to see more easily which items are in which reports. You can look across a row
instead of looking for the same names in both reports. Because the related row and the field names
are the same, you can easily make sure that you have all the data items. Although locating items
easily is not critical for this small database, it becomes very important when you have to deal with
large tables containing many fields.
Determining sales information
After extracting the customer data, you can move on to the sales data. In this case, you need to
analyze only the Invoice report for data items that are specific to the sales. Table 1-2 lists the fields
in the report that contain information about the sales.
15
An Introduction to Database Development
1
05_046732 ch01.qxp 11/21/06 8:44 AM Page 15
|
|