Microsoft® Office Access 2003 Step by Step

Creating Tables the Simple Way

When you use the Database Wizard to create a contact management database, the database has all the components needed to store basic information about people. But suppose The Garden Company needs to store different types of information for different types of contacts. For example, it might want to maintain different types of information about employees, customers, and suppliers. In addition to the standard information—such as names, addresses, and phone numbers—the company might want to track these other kinds of information:

• Employee Social Security number, date of hire, marital status, deductions, and pay rate

• Customer ...