Microsoft Office Tutorials and References
In Depth Information
AC 160
Access Chapter 3 Maintaining a Database
5
Click the Next button to display
the next Lookup Wizard screen.
label for
lookup column
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).
6
Click the Finish button to
complete the defi nition of the
Lookup Wizard fi eld.
Allow Multiple Values
check box (should not
be checked)
Finish button
Why does the data type for the
Client Type fi eld still show Text?
The data type is still Text because
the values entered in the wizard
were entered as text.
Figure 3–28
To Add a Multivalued Field
Multivalued Fields
If you plan to move your
data to SQL Server at a
later date, do not use
multivalued fi elds. When
you upsize a database
containing multivalued
fi elds to SQL Server,
the fi eld is converted
to a memo fi eld that
contains the delimited
set of values. This may
mean that you need to
do some redesign of your
database.
Normally, fi elds contain only a single value. In Access 2007 it is possible to have
multivalued fi elds , that is, fi elds that can contain more than one value. JSP Recruiters
wants to use such a fi 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
Specialty
Abbreviation
Description
CLS
Clinical Laboratory Specialist
CNA
Certifi ed Nursing Assistant
CRNA
Certifi ed Registered Nurse Anesthetist
DH
Dental Hygienist
Dnt
Dentist
EMT
Emergency Medical Technician
NP
Nurse Practitioner
OT
Occupational Therapist
PA
Physician Assistant
Phy
Physician
PT
Physical Therapist
RN
Registered Nurse
RT
Respiratory Therapist
 
Search JabSto ::




Custom Search