Exercise Unit 3. CREATE A DATA TABLE.


If Access is not open, open it in order to be able to carry out the following exercises.

Exercise 1: Distributer.

1 Open the Cars database in My exercises folder in the hard drive.

 

2 Create a table named Clients with the following fields:

 

Field Name Data Type
Client Code Number
Client Name Text
Client Surname Text
Client Address Text
Client City Text
Client Postal Code Text
Client State Text
Client Phone Text
Client Birth Date/Time

The primary key will be Client code.

3 Create another table named Sold Cars with the following fields.

 

Name of field Type of data
Licence Text
Make Text
Model Text
Colour Text
Price Text
Extras Memo

The primary key will be License.

4 Create another table named Services with the following fields:

Name of field Type of data
Service Number Autonumber
Oil Change Yes/No
Filters Change Yesí/No
Revise Brakes Yes/No
Other Memo

The primary key will be Service Number

5 Close the database.

 

Exercise 2: Clinic.

1 Open the Clinic database in My exercises folder in the hard drive.

2.Create another table named Patients with the following fields.

 

Name of field Type of data
Patient Code Number
Patient Name Text
Patient Surname Text
Patient Address Text
Patient City Text
Patient Zip Code Text
Patient State Text
Patient Phone Text
Patient Birth Date/Time

For the moment we will not define a primary key.

3 Create another table named Doctors with the following fields.

 

Name of field Type of data
Doctor Code Text
Doctor Name Text
Doctor Surname Text
Doctor Phone Text
Doctor Speciality Text

For the moment we will not define a primary key.

4 Create another table named Entries with the following fields:

Name of field Type of data
Entry Number Autonumber
Entry Room Number
Entry Bed Text
Entry Date Date/Time

Do not define a primary key.

5 Close the database.

 



 

Page. e.3

Legal warning: Authorised on-line use only. It is not allowed the use of these courses in companies or private teaching centres.
© aulaClic. All rights reserved. Reproduction in any form whatsoever is prohibited. April-2006.