Database Reference
In-Depth Information
You cannot leave the record until you resolve this data error.
27
Click OK , change the value in fDate2 to 12/22/22 , and then click in the record
below it.
CLEAN UP Close the FieldTest table. Keep the GardenCompany06 database open for
use in later exercises.
Allowing only values in lists
It is interesting how many different ways people can come up with to enter the same items
of information in a database. Asked to enter the name of their home state, for example,
residents of the state of Washington will enter Washington , Wash , or WA , plus various typo-
graphical errors and misspellings.
6
Minor inconsistencies in the way data is entered might not be really important to someone
who later reads the information and makes decisions. For example, Arizona and AZ refer to
the same state. But a computer is very literal, and if you tell it to create a list so that you can
send catalogs to everyone living in AZ , the computer won't include anyone whose state is
listed in the database as Arizona .
You can limit the options for entering information in a database in several ways:
If one entry is more likely than any other, you can set the Default Value property of
the field to that entry. Users can then press Tab to skip over that field, leaving the
default entry intact. Even if users enter something else, the format of the default entry
might guide them when choosing their entry's format.
For only two options, you can use a Yes/No field represented by a check box. A
selected check box indicates one choice, and a cleared check box indicates the other
choice.
Search WWH ::




Custom Search