GCFLearnFree.org

As a website designer, I can say you have one of the best learning websites.”

Online Learner

GCFGlobal.org
Creating Opportunities For A Better Life.®
  • All Topics
  • Access 2003
  • Database Tables

Access 2003

Single page view print copy

Database Tables

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 Size Required Entry? Allow Duplicates?
First Name        
Last Name        
Company        
Company Type        
Address        
City        
State        
Zip Code        
Contact Id        
Title        
Work phone        
Fax Number        
previous next
previous 1 2 3 4 5 6 next
Terms Of Use

©1998-2014 Goodwill Community Foundation, Inc. All rights reserved.