Microsoft Office Tutorials and References
In Depth Information
Access Chapter 3 Maintaining a Database
• Click the Next button to display
the next Lookup Wizard screen.
• Ensure Client Type is entered as the
label for the lookup column and
that the Allow Multiple Values check
box is NOT checked (Figure 3–28).
• Click the Finish button to
complete the deﬁ nition of the
Lookup Wizard ﬁ eld.
Allow Multiple Values
check box (should not
Why does the data type for the
Client Type ﬁ eld still show Text?
The data type is still Text because
the values entered in the wizard
were entered as text.
To Add a Multivalued Field
If you plan to move your
data to SQL Server at a
later date, do not use
multivalued ﬁ elds. When
you upsize a database
ﬁ elds to SQL Server,
the ﬁ eld is converted
to a memo ﬁ eld that
contains the delimited
set of values. This may
mean that you need to
do some redesign of your
Normally, ﬁ elds contain only a single value. In Access 2007 it is possible to have
multivalued ﬁ elds , that is, ﬁ elds that can contain more than one value. JSP Recruiters
wants to use such a ﬁ eld to store the abbreviations of all the specialties their clients need
(see Table 3–1 for the specialty abbreviations and descriptions). Unlike the Client Type,
where each client only had one type, clients can require multiple specialty descriptions.
Table 3–1 Specialty Abbreviations and Descriptions
Clinical Laboratory Specialist
Certiﬁ ed Nursing Assistant
Certiﬁ ed Registered Nurse Anesthetist
Emergency Medical Technician