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 order and account status

  • Supplier contact, current order status, and discounts

While building the ...

Get Microsoft® Office System Step by Step -- 2003 Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.