1.                   

Open the Lesson 2.1 database file from the Section 2 folder of your Exercise Files folder.

2.                   

Open the Vehicles table in Design view.

3.                   

Right-click the grey box beside the Vehicle ID field and select Primary Key.

4.                   

Click the grey box beside the Year field to select the row. Then click and hold the grey box again, and drag the Year field between Vehicle ID and Make.

5.                   

In the Field Properties of the Year field, select Yes (Duplicates OK) from the Indexed combo box.

6.                   

Insert a row between the Model and Engine fields. Enter Country of Origin as the Field Name and Text as the Data Type.

The Vehicles table should look like this:

Close the Vehicles table and save the changes.

7.                   

Make sure the Tables object is selected in the Database window. Click File à Get External Data à Import.

Click the My Sample Database Access file from the Section 2 folder of your Exercise Files folder and click Import.

8.                   

In the Import Objects dialogue box, click once on the name to select the lone Countries table from the Tables tab. Click OK.

9.                   

You will now see two tables in your database, Countries and Vehicles.

10.               

Close Microsoft Access 2003.