FIGURE 1-4
A sales invoice report containing sales information
You can read more about the reports for the Access Auto Auctions system in Chapters 9
and 20.
Step 3: Data design: What fields are required.
The next step in the design phase is to take an inventory of all the information or data fields that
are needed by the reports. One of the best methods is to list the data items in each report. As you
do so, take careful note of items that are included in more than one report. Make sure that you
keep the same name for a data item that is in more than one report because the data item is really
the same item.
Another method is to see whether you can separate the data items into some logical arrangement.
Later, these data items are grouped into table structures and then mapped onto data-entry screens
(forms). You should enter customer data (buyers and sellers), for example, as part of a contact table
process, not as part of a sales entry.
Determining contact information
First, look at each report you have reviewed or attempted to make for the Access Auto Auctions
system. For this system, start with the customer data and list the data items, as shown in
Table 1-1.
CROSS-REF
CROSS-REF
14
Access Building Blocks
Part I
05_046732 ch01.qxp 11/21/06 8:44 AM Page 14
|
|