Unit 8 exercises . Summary queries


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

Exercise 1: Cars

Create in the Cars database:

1 A query to know how many cars have been sold, how much money they cost, and the average sale amount.

Audi Cars should not be counted, name the query Summary without Audi.

2 A query to know how many services we have with oil changes, how many with filter changes, and how many changes of brakes, name it Summary Services.

 

Exercise 2: Clinic

Create in the Clinic database:

1 A query to know the doctors that have more than three admissions, indicating for each one of these the name and surname of the each doctor, and how many admissions they have. Name the query Saturated doctors.

2 A query to know the oldest admission date within each speciality. Name the query Oldest admissions.

 

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

 

 



   

Page. e.8

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.