I have a moderate knowledge on how to create databases in Access but I am having a problem. I want to be able to improve the exams we write by tracking the questions which were answered wrongly to be able to improve the exam. Here is what I am looking to do:
1. Have a record of all questions answers INCORRECTLY for several exams.
2. Be able to calculate the number of people who got a particular answer WRONG in an exam and show it as a percentage of the total number of people who took that exam.
3. Show (print a report of) the total exam info as opposed to the individual questions. I don't want to have 1 answer per page.
I don't need to know the names of the candidates, so the primary key is the ID. We have 20 exams ranging from 20 to 180 questions.
I have only 1 input form. In this form, the Primary Key is generated, there is then be a combo box for the name of the exam (taken from the EXAM table), and I want the respective number of answers (check boxes) to show up depending on which exam it is (and this is where I am getting stuck).
Once the info has been input, I want to be able to run a report for all versions of the "Performance" bunch of exams, or target a specific exam: PERFORMANCE1.
I have deleted and restarted this thing soooo many times that I am now completely lost.:confused:
Any suggestions guys?
Thanks in advance.