O'Reilly logo

2007 Microsoft® Office System Step by Step, Second Edition by Joan Lambert, John Pierce, Steve Lambert, M. Dow Lambert III, Curtis D. Frye, Joyce Cox

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required