Microsoft Office Tutorials and References
In Depth Information
Access Chapter 3 Maintaining a Database
• Return to Design view and ensure
the Client Number, Client Name,
Client Type, and Specialties
Needed ﬁ elds are selected.
• Click the Specialties Needed ﬁ eld
to produce an insertion point,
and then type a period and the
word Value after the word,
Needed, to use the Value property
I don’t see the word, Specialties.
Did I do something wrong?
No. There is not enough room to
display the entire name. If you
wanted to see it, you could point
to the right boundary of the
column selector and then either drag
position to click for
only ﬁ nal portion of
ﬁ eld name appears
Do I need to type the word Value?
No. You also can double-click the second Specialties Needed entry in the ﬁ eld list.
• View the results (Figure 3–66).
Can I now include criteria for the
multivalued ﬁ eld?
Yes. This is now just like any other
query. There are no multiple
values on any row.
each row contains
only one specialty
• Close the query by clicking the
Close ‘Query1’ button.
• When asked if you want to save
the query, click the No button.
The four specialties needed by
client AC34 now appear on four
rows. (In the previous query, they
appeared on a single row.)