Database Tables

Learn how to read, manipulate, and create Access 2003 database tables in this free lesson.

Challenge!

Let's imagine that you're going to start your own home business. You will need to prepare a database for your business, and the first step is to design a table that will contain a list of contacts who may one day be your clients or suppliers.

Let's assume that a database table called Business Contacts contains all of the fields listed in the first column of the following chart. The chart also contains four other columns:

  • Text, Numbers, or Both: Should the field accept data entry input in the form of text, numbers, or both?
  • Field Size: Tis is the number of spaces you think the field should have.
  • Required Entry: Should the field be required entry (the record cannot be added to the database without the information) or optional entry (a record can be added without entry in the field)?
  • Allow Duplicates: Should the database allow duplicate entries for the field (for example, can several people in the database share the same zip code)?

Practice designing fields by filling out the following table.

Text, Numbers, or Both?Field SizeRequired Entry?Allow Duplicates?
First Name
Last Name
Company
Company Type
Address
City
State
Zip Code
Contact Id
Title
Work phone
Fax Number