Multiple-choice questions in Access


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: Multiple-choice questions in Access

Hybrid View

  1. #1
    Paul Gardner Guest

    Multiple-choice questions in Access


    Hi all,

    I'm kind of an rusty old VB3.0 programmer now starting out on VB6.0 but
    a beginner in Access. I've created a series of questions with four
    possible answers, an indicator of the correct answer, and a comment as
    to why it is correct. I'd like to be able to pull random records from
    the Access table which the student would answer by clicking on a option
    button. At the end of, say, 10 questions they would be told how many
    they had got wrong and would be offered the chance to review those ten
    questions. The program would indicate their choice and the correct/incorrect
    choice (where applicable) and display the comment box. Any advice or
    example code greatly
    appreciated!

    Many thanks

    Paul

  2. #2
    Arthur Wood Guest

    Re: Multiple-choice questions in Access


    Paul,
    I would set up two tables:

    Question Answer
    QID PK QID PK
    QuestionText AnswerChoice PK
    CorrectAnswer AnswerText
    AnswerReason

    here PK indicates the Field or Fields which make up the Primary Key.

    The Question Table has a 1 to many relationship to the Answer Table.

    This should help get you started. If you need more spcific help, start your
    coding and then ask for help as you need. it. Most people here will be glad
    to assist, but are not likely to write the app for you.

    Arthur Wood

    "Paul Gardner" <plg@st-andrews.ac.uk> wrote:
    >
    >Hi all,
    >
    >I'm kind of an rusty old VB3.0 programmer now starting out on VB6.0 but
    > a beginner in Access. I've created a series of questions with four
    > possible answers, an indicator of the correct answer, and a comment as
    > to why it is correct. I'd like to be able to pull random records from
    > the Access table which the student would answer by clicking on a option
    > button. At the end of, say, 10 questions they would be told how many
    > they had got wrong and would be offered the chance to review those ten
    > questions. The program would indicate their choice and the correct/incorrect
    > choice (where applicable) and display the comment box. Any advice or
    > example code greatly
    > appreciated!
    >
    >Many thanks
    >
    >Paul



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center