Designing Your Database Structure
The Benefits of Planning
The Entity-Relationship Diagram
Setting Relationships Between Tables
Manually
Numbers in Access
Whole Numbers
Fractional
Numbers
Autonumber columns as Primary Keys
Multiple Relationships between one
Table and Another
The Lookup Wizard
Checking Inherited Data for Consistency