The recordsource queries for the subforms would look something like this:

For question 1:

SELECT SUM(ABS([Question1] = 1)) AS [Number of Poor], SUM(ABS([Question1] = 2)) AS [Number of OK], SUM(ABS([Question1] = 3)) AS [Number of Better], SUM(ABS([Question1] = 4)) AS [Number of Good], SUM(ABS([Question1] = 5)) AS [Number of Excellent]

FROM YourTable

For question 2:

SELECT SUM(ABS([Question2] = 1)) AS [Number of Poor], SUM(ABS([Question2] = 2)) AS [Number of OK], SUM(ABS([Question2] = 3)) AS [Number of Better], SUM(ABS([Question2] = 4)) AS [Number of Good], SUM(ABS([Question2] = 5)) AS [Number of Excellent]

FROM YourTable

Etcetera...