Hi all,
Firstly, I know that there are other options that may be slightly easier, however the quiz is only part of my access project and so I wish to keep it IN ACCESS, so don't worry about suggesting alternatives.
Secondly, I put this in forms as I want the end quiz to be in a form for the user. Would I use 'Option Button' for each quiz option, if so how do I link them to the quiz, etc etc.
Thirdly, I do not currently have any tables or stuff relating to the quiz set up in the slightest, but the following details are what I currently wish to have.
I assumed I would have to do the following after trying to research it a tad (However it didn't really help much):
tbl_Quiz1 (Same layout for each separate quiz)
QuestionID (Auto-number, PK)
Question
Answer
UserAnswer
I'm under the idea that the database would go through the questions (in order, no need for a randomizer) and the user would click one of the four options. It would be a multiple choice quiz, only one answer being correct. The system would somehow check the UserAnswer against the Answer and do something, I don't know how the rest works.
What I want is after however many questions, the user would click complete or something, and then the database would calculate the percentage correct. If over 80% correct then they will be transported to another form where they enter their first name and surname into a box, which well then place that name onto a certificate I designed. (I was told to use a report and query for this? However I also have no clue at all about this aspect). If under 80%, they would move to a different form (the forms act as 'pages' which will allow them to quit or retry.
At the minute I'm using buttons, which when clicked runs a macro to close one form and open another. This method is fine for me, I just don't know how to sum the percentage, and then make the database direct the user towards a certain page depending on the score. I need help with coding for that too, if possible. For reference, the form names and such might be:
Forms:
Frm_QuizQuestion1 (2, 3, etc, although If I wanted to show one question at a time, would I have to create a separate form with a question on each, or is there an alternative method?)
Frm_UnsuccessfulCompletion
Frm_SuccessfulCompletetion (/Detail Entry for certificate)
Reports:
Rpt_Quiz1Certificate
Many thanks,
Daniel
Firstly, I know that there are other options that may be slightly easier, however the quiz is only part of my access project and so I wish to keep it IN ACCESS, so don't worry about suggesting alternatives.
Secondly, I put this in forms as I want the end quiz to be in a form for the user. Would I use 'Option Button' for each quiz option, if so how do I link them to the quiz, etc etc.
Thirdly, I do not currently have any tables or stuff relating to the quiz set up in the slightest, but the following details are what I currently wish to have.
I assumed I would have to do the following after trying to research it a tad (However it didn't really help much):
tbl_Quiz1 (Same layout for each separate quiz)
QuestionID (Auto-number, PK)
Question
Answer
UserAnswer
I'm under the idea that the database would go through the questions (in order, no need for a randomizer) and the user would click one of the four options. It would be a multiple choice quiz, only one answer being correct. The system would somehow check the UserAnswer against the Answer and do something, I don't know how the rest works.
What I want is after however many questions, the user would click complete or something, and then the database would calculate the percentage correct. If over 80% correct then they will be transported to another form where they enter their first name and surname into a box, which well then place that name onto a certificate I designed. (I was told to use a report and query for this? However I also have no clue at all about this aspect). If under 80%, they would move to a different form (the forms act as 'pages' which will allow them to quit or retry.
At the minute I'm using buttons, which when clicked runs a macro to close one form and open another. This method is fine for me, I just don't know how to sum the percentage, and then make the database direct the user towards a certain page depending on the score. I need help with coding for that too, if possible. For reference, the form names and such might be:
Forms:
Frm_QuizQuestion1 (2, 3, etc, although If I wanted to show one question at a time, would I have to create a separate form with a question on each, or is there an alternative method?)
Frm_UnsuccessfulCompletion
Frm_SuccessfulCompletetion (/Detail Entry for certificate)
Reports:
Rpt_Quiz1Certificate
Many thanks,
Daniel