This is the scenario: I give a test to students and give them a "Y" for each question that they got correct and "N" for each incorrect answer. Then I teach them, give them study material and later let them retake the same test.
I want to be able to compare the 2 with a graph of some sort to see if the group did better on the second test and also to see what each individual did, better or worse. I've got 2 tables setup, each with the students name down the left side and Q1,Q2,Q3 etc across the top as column headers. I just can't figure out how to compile these into a graph or chart...
Can anyone give me a starting point?
It might be that it's better to do it in Access and that's fine too...

I haven't actually built anything in Access yet. I was trying to do it in Excel and just said that I might have to do it in Access. Sorry for the confusion.