Microsoft Office Tutorials and References
In Depth Information
Validation Rules AC 173
• Click the down arrow to display
the drop-down list of available
choices for the Client Type ﬁ eld
Could I type the value instead of
selecting it from the list?
Yes. Once you have either deleted
the previous value or selected the
entire previous value, you can
begin typing. You do not have to type
the full entry. When you begin with the
letter, D, for example, Access will automatically add the NT.
list of available
• Select the Client Type ﬁ eld on the ﬁ rst record. Try to change the client type by typing various values.
Try to type an invalid Client Type (like SPT). When ﬁ nished, change the value on the record to MED.
• Click DNT to change the value.
• In a similar fashion, change MED
on the ninth record to LAB
To Use a Multivalued Lookup Field
Using a multivalued Lookup ﬁ eld is similar to using a regular Lookup ﬁ eld. The difference is that when you
drop down the list, the entries all will be preceded by check boxes. You then can check all the entries that you want.
The appropriate entries are shown in Figure 3–47. As indicated in the ﬁ gure, the specialties needed for client AC34
are CNA, PA, Phy, and RN.