2007 Microsoft® Office System Step by Step

Creating a Table Manually

In the previous exercise, you created a contact management database application based on an Access 2007 template. The database had all the tables, forms, reports, and code needed to import, store, and use basic information about people. But suppose you need to store different types of information for different types of contacts. For example, you 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—you might want to track these other kinds of information:

• Employee Social Security numbers, dates of hire, marital status, deductions, and pay rates

• Customer orders and account status

• Supplier contacts, ...