Access XP
Database Tables
Challenge!
Let us assume that a database table called Contacts contains all 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—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 (e.g., 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 | ||||
| Address | ||||
| City | ||||
| State | ||||
| Zip Code | ||||
| Country | ||||
| Contact Id | ||||
| Title | ||||
| Work phone | ||||
| Work extension | ||||
| Mobile Phone | ||||
| Fax Number |
