Exercise 1:

A.

B.

Step #1: Create the table manually by left clicking the Design view button or double clicking the Create a Table Using Design View button.

Step #2: Click in the first field box and enter the field name you desire. In this case, type Province. Next, left click in the corresponding data type field and choose Text. If you choose another data type, an error will most likely occur when entering information later on.

Step #3: Repeat Step #2 for the other fields, until you have completed them all (up to Region).

Step #4: Save the table as Province Information Table and click yes to set the primary key as Province.

Step #5: Exit Design View of the table and and double click Province Information Table to go into datasheet view.

Step #6: Once in datasheet view, click in the appropriate cells and enter data. Save table when completed by clicking the Disk picture in the toolbar at the top. Go to File, Print, and click OK.

Back to Solutions Page