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, ...