Database Reference
In-Depth Information
All fields, no matter what their data type, can be assigned a Caption property that appears
in place of the field name in tables or in other database objects. For example, you might
want to use captions to display spaces in the names of fields, such as First Name for the
FirstName field.
SEE ALSO
For information about using properties to control the accuracy of data entry, see
Chapter 6, “Maintain data integrity.” For a comprehensive list of data types and properties,
search for
data types
on the Office website.
In this exercise, you'll open a table in Design view, add and delete fields, change a data
type, set field sizes, and add a caption.
SET UP
You need the MyTables database you worked with in the preceding exercise to
complete this exercise. If necessary, open the database. Then follow the steps.
1
In the
Navigation
pane, right-click the
Employees
table, and then click
Design View
.
This table was created by copying the Customers table. Let's make a few changes to
the fields.
2
In the
Field Name
column, select
CustomerID
, enter
EmployeeID
, and then press
the
Tab
key twice.
3
In the
Description
column, enter
Unique identifying number
.
4
Click the
Country
field's selector, and then on the
Design
tool tab, in the
Tools
group, click the
Delete Rows
button.
5
In the empty row below the
Phone
field, click the
Field Name
cell, and enter
Birthdate
. Then click the
Data Type
cell, which indicates that the default
Short Text
data type is assigned to the new field.
6
Click the arrow at the right end of the
Data Type
cell, and in the list, click
Date/Time
.
7
Repeat steps 5 and 6 to add another
Date/Time
field named
DateHired
.
8
Select the
ZIP
field name, change it to
PostalCode
, and then change its data type to
Short Text
.