Database Reference
In-Depth Information
9
Click
Next
. On the wizard's last page, enter
Employee
as the name of the field, and
select the
Enable Data Integrity
check box. Then click
Finish
.
Let's test the list.
10
Click in the
Employee
field of the first record, and then click the arrow at the right
end of the field to display a list of possible entries.
The list is in alphabetical order by last name.
6
11
Click
Nancy Anderson
to enter the name
Nancy
as the salesperson for this order.
Next let's change the CustomerID field of the Customers table so that it accepts
manually entered, intuitive IDs.
12
Open the
Customers
table in
Design
view. Then on the
Design
tool tab, in the
Tools
group, click the
Primary Key
button to turn it off.
13
Change the
Data Type
setting for the
CustomerID
field to
Short Text
.
14
Change the
Field Size
property to
5
, and enter an
Input Mask
property of
>LLLLL;;
to force Access to display the
CustomerID
value in capital (uppercase) letters, no
matter how it is entered.
15
Click the
CustomerID
field in the
Field Name
column, and in the
Tools
group, click
the
Primary Key
button. Then save the table.
Let's test the new field.
16
Switch to
Datasheet
view. For each customer, assign a
CustomerID
that consists
of the first three letters of the last name and the first two letters of the first name.
Try entering an ID in all lowercase letters and notice that Access displays them in
uppercase.