test results analysis

I am in charge of reviewing multiple tests from around the country and
evaluating each question, each testing site, etc.

I need to find an easy way with Access if possible to input the "answer key" in collum A then each of the tests that I receive from the testing locations in collums B, C, D,..etc.
Then i need to evaluate how many attempts for the test, number of people who chose A, number who chose B, etc. This will help identify the
"bad" questions or the questions that need to be looked at.
This is how I currently have it started but not sure how to proceed.

Question# Key Student1 student2 student3
1 A A C B
2 B C B B
3 D D D D
4 A A A C


Any ideas or suggestions?

Thanks,
Doc
<!-- / message -->