CrossTab

A Crosstab query is a select query that can summarise/aggregate data into rows and columns.
It can be used to group data into two categories, one used for the rows and one for the columns.

You must use the GROUP BY in a cross tab query
Access has the keyword "CROSSTAB"

TRANSFORM keyword

PIVOT keyword