Microsoft® Office Access 2003 Inside Out

Data Analysis

Now you’re ready to begin a more thorough analysis of your data and to organize the individual elements into data subjects. These subjects become candidates for tables in your database design.

Choosing the Database Subjects

If you’ve been careful in identifying the subject for each data item you need, the next step is very easy. You create another worksheet, similar to the worksheet shown in Table 3-4, to help you collect all the data items that belong to each subject. In the top part of the worksheet, you list the related subjects that appear in any given task and indicate the kind of relationship.

Table 3-4. An application design worksheet for identifying related subjects.

APPLICATION DESIGN WORKSHEET #2 = SUBJECTS

Subject Name:

Brief ...