Exercise Unit 4: Modifying data tables.


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

 

Ejercicio 1: Cars.

1 Introduce the following data into the Clients table in the Cars database in My exercises folder.

 

Client code Client name Client surname Address City Postal code Province Telephone Date of birth
100 Antony Wood 58 Cedar Ave Denver 46011 CO 963689521 08/15/60
101 Charles Standwood 5 W Franklin Blvd. Chicago 45300 IL 962485147 04/26/58
105 Louis Wolf 11 Main st. Dallas 75201 TX 962965478 0330/61
112 James Smith 121 Cedar Ave Denver 46014 CO 963684596 01/31/68
225 Andrew Fields 23 Seneca rd Miami 33500 FL 963547852 04/28/69
260 Joseph Taylor 14 Cedar Ave Denver 46002 CO 963874569 05/15/64
289 Elisabeth Baker 4 Lake St. Miami 33500 FL 963547812 07/10/62
352 Eva Santos 34 Manor Rd. Austin 75300 TX 962401589 08/12/65
365 Gerard Swan 8 Steel St. Denver 46002 CO 963589621 02/01/65
390 Charles Prats 8 Alameda Ave Denver 46005 CO 963589654 03/05/67
810 Louisa Oliver 1562 Steel St. Denver 46007 CO 963587412 06/25/64
822 Samuel Larred 65 Steel St. Denver 46005 CO 963589621 12/25/67
860 James Tree 8 Main st. Austin 75300 TX 963758963 04/05/69
861 James Tree 8 Main st. Austin 75300 TX 963758963 04/05/69

 

2 Change the name of James Smith to Antony.

3 Delete the last record.

4 Close the table and the database.

 

Exercise 2: Clinic.

1 Modify the structure of the Patients table in the Clinic database in My exercises folder following these indications:

 

Field name Data type
Patient code Primary key
Patient State Erase this field

 

2 Edit the structure of the Doctors table with the following data:

 

Field name Data type
Doctor code Primary key
Doctor Phone Erase this field

 

3 Edit the structure of the Admissions table with the following data:

 

Field name Data type
Entry Number Primary key

 

4 Close the database.

 

If you are unsure about any of the operations to perform in the previous exercises, Here we will explain them to you.

 



 

Page. e.4

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.