Unit 9 exercise. Crosstab queries


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

 

Exercise 1: Cars

Create a query in the Cars database in My exercises folder to obtain a crosstab query to know for each make, how many cars were sold in each colour, and also the total sold of each make should appear. Name it Cross make-colour.


Exercise 2: Clinic

Create a query in the Clinic database in the My exercises folder to obtain a crosstab query to know how many admissions in every speciality we have in each city. Name it Cross Entries-Patients-Doctors.

 

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

 



   

Page. e.9

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.