|
1.
|
Open
Lesson 2.2 from the Section 2
folder of your Exercise Files.
 |
|
|
|
|
2.
|
Open the
Vehicles table in Design view
and modify the following field properties:
Change the
Vehicle ID format to
General Number, and add
Vehicle ID # to the field
Caption.
 |
|
|
|
|
3.
|
Change the
Year
Field Size to
Integer, and change the
Required option to
Yes.
 |
|
|
|
|
4.
|
Rename the
Engine field to
Number
of Cylinders. Change its
Data
Type to
Number, and then change its
Field Size
to
Integer.
Type
Cylinders
for the Caption. |
|
|
|
|
5.
|
Add a meaningful
description to each field in the Vehicles table:
|
Vehicle ID |
Identification number for each
vehicle in this table. |
|
Year |
First year of production. |
|
Make |
Manufacturer of vehicle. |
|
Model |
Model name of vehicle. |
|
Country of
Origin |
Manufacturer’s base of operations. |
|
Number of
Cylinders |
Number of cylinders in engine block,
0 for rotary engines. |
 |
|
|
|
|
6.
|
Close the
Vehicles table and
save
the changes. |
|
|
|
|
7.
|
Open the
Countries table in Design view.
Add the following descriptions to the table:
|
Country ID |
Identification number for each
country in the list. |
|
Country Name |
Name of the country or region. |
 |
|
|
|
|
8.
|
Close the
Countries table and
save
the changes. |
|
|
|
|
9.
|
Close
Microsoft Access 2003. |
