Unit 10 exercise. Action queries


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

 

Exercise 1: Distributer

Open the Cars database.

1 Create the Create Ford services query that will generate a new table named Ford services and will contain the records of the Services carried out on Ford cars.

2 Create an Increase price query that will permit the price of all Ford cars to increase by 5%.

3 Create a Delete Ford services query that will delete all records of Services carried out on Ford cars.

4 Create a Recover services query that will recover the records deleted in the previous query from the table that we created in part 1.


Exercise 2: Clinic

Open the Clinic database.

1 Create a Create non admitted patients that will generate a new table named Non admitted patients and will contain the records of the Patients that are not in the Entries table.

2 Create a Change room query to change the patients from room 504 to room 505.

3 Create a Create room 201 query that will generate a new table named Rooms 201 and will contain the records of the Entries in room number: 201.

4 Create a Delete entries that will delete the Entries in room number 201.

5 Create a Recover entries query to recover the records deleted in the previous query.

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

 



   

Page. e.10

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.