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