Results 1 to 3 of 3
  1. #1
    Madmax is offline Advanced Beginner
    Windows Vista Access 2007
    Join Date
    Jun 2011

    complex design problem

    Good Afternoon all,

    I am working on a database that will pull questions at random and put them into a product for a person to answer the questions. then when they submit it will check the answers the person put into the form and input a new record into the Testrecords table.

    Currently I have the testbank table setup with
    ID Field
    Question field
    AnswerA Field
    AnswerB Field
    AnswerC Field
    AnswerD Field
    Correct Answer

    The math at the end I can take care of but I am unsure how I should proceed in pulling the random questions into a form.

    The way I can think of to do it is do a split form and have 25 random questions pulled the problem is then when you submit the answer for the question I want it to store that they got the answer right till I can have it go through all 25 records. Each test will use the getuser function from my functions so I can pull it at any time. I just need the answer stored as being right or wrong.

    couple of issues and I am afraid it is a design flaw in the end. if this dont work I will try something different but I am looking for three answers

    1. how to random pull 25 records(the Questions/Answers)
    2. How best to display the Questions/Answers with a way to check the picked answer with correct answer
    3. how to store that they got the answer right so I can at the end make a new record using there user ID, date, Number right and percentile.


  2. #2
    dblife's Avatar
    dblife is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Nov 2011
    South Shields, UK
    Your approach to table design does not look right.
    There should be a table for candidates.
    A table for questions.
    A table for standard answers - if applicable.
    And a table to combine all three, a junction table to record, candidate against question number and subsequent answer.

  3. #3
    Madmax is offline Advanced Beginner
    Windows Vista Access 2007
    Join Date
    Jun 2011
    sorry I wasnt clear

    I have the questions in Testbank but I have the correct answer in that same table

    I do have a personnel table

    then I have a table that combines when the test was taken, who took the test, and how many they got right.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Complex Lookup Problem
    By alagrad94 in forum Programming
    Replies: 5
    Last Post: 07-27-2011, 10:24 AM
  2. Replies: 1
    Last Post: 03-06-2011, 06:21 PM
  3. Problem with Design Switchboard
    By Nokia N93 in forum Access
    Replies: 3
    Last Post: 12-13-2010, 06:21 AM
  4. Complex Survey: Table Structure Design and Normalization
    By kevin007 in forum Database Design
    Replies: 2
    Last Post: 07-06-2010, 09:21 AM
  5. design problem
    By marianne in forum Database Design
    Replies: 7
    Last Post: 05-26-2009, 07:25 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
Other Forums: Microsoft Office Forums - Senior Forums