Task 10r | Chapter 10 Database | Cambridge AS IT 9626
Hi👋🏻,
اهلاً وسهلاً
🔻To download the resources from:
https://www.hachettelearning.com/answ...
------------------------
This video explains how to use crosstab queries in Microsoft Access.
Using the data file from task 10Q, the lesson introduces what a crosstab query is, essentially a type of select query that summarizes data in a format similar to a pivot table in spreadsheets. The video breaks down how crosstab queries help you organize information by setting one field as the row heading, another as the column heading, and a third as the value to be summarized using functions such as Count.
In this task (10R), you are required to count the number of customers for each discount value across different areas identified in the Address 3 field. The video shows how to identify clues in the question, such as the instruction to “count”, to determine that a crosstab query is needed.
The tutorial demonstrates two methods:
1) Using the Crosstab Query Wizard
Selecting the correct table (Customer).
Setting Address 3 as the row heading.
Setting Discount as the column heading.
Using CustomerID as the value field and applying the Count function.
Viewing the result and the automatically generated totals.
2) Using Query Design View
Switching to crosstab mode.
Manually adding Discount, Address 3, and CustomerID.
Assigning the correct headings and function (column heading, row heading, value = Count).
Adding optional row or column totals if required by the question.
By the end of the video, you will understand both methods and know how to create accurate and well-structured crosstab queries for your IGCSE/Access tasks.