Not sure if this is a 'query' query or a VBA query to be honest.
I am making a quiz/assessment system. I am at the stage whereby my database can take people through a number of assessments and record their answers.
I now need to work out how to check their answers against the correct answers and calculate their scores.
The correct answer ID sits in the Questions table and there is separate tables for possible answers and the users submissions (structures can be posted if needed).
My specific needs will be:
- summary of each assessment by each user (list of questions, their answer, whether right/wrong and total score (percentage or total is fine))
- summary of all of users assessments (topic title and score only)
I'd like to use reports for the end product, but how to get there has been a bit perplexed.
Is this something which can be done purely with queries, or will I need some VBA?
Help is very much appreciated!
I am making a quiz/assessment system. I am at the stage whereby my database can take people through a number of assessments and record their answers.
I now need to work out how to check their answers against the correct answers and calculate their scores.
The correct answer ID sits in the Questions table and there is separate tables for possible answers and the users submissions (structures can be posted if needed).
My specific needs will be:
- summary of each assessment by each user (list of questions, their answer, whether right/wrong and total score (percentage or total is fine))
- summary of all of users assessments (topic title and score only)
I'd like to use reports for the end product, but how to get there has been a bit perplexed.
Is this something which can be done purely with queries, or will I need some VBA?
Help is very much appreciated!
