Microsoft Office Tutorials and References
In Depth Information
AC 158
Access Chapter 3 Maintaining a Database
To Create a Lookup Field
Because there are only three possible values for the Client Type fi eld, you should make it easy for users to
enter the appropriate value. A Lookup fi eld allows the user to select from a list of values.
The following steps make the Client Type fi eld a Lookup fi eld.
1
If necessary, click the Data Type
column for the Client Type fi eld,
and then click the arrow to display
the menu of available data types
(Figure 3–24).
data type
is Text
Data Type
arrow
Client Type fi eld
Lookup
Wizard
menu of available
data types
Figure 3–24
2
Click Lookup Wizard, and then
click the ‘I will type in the values
that I want.’ option button to
indicate that you will type in the
values (Figure 3–25).
description
of wizard
When would I use the other
option button?
You would use the other option
button if the data to be entered
in this fi eld is found in another
table or query.
Lookup Wizard
dialog box
Next button
I will type in the values that
I want. option button
Figure 3–25
Search JabSto ::




Custom Search