Results 1 to 3 of 3
  1. #1
    morena85 is offline Novice
    Windows 10 Access 2010 32bit
    Join Date
    Aug 2016
    Posts
    2

    Smile Creation of a database to keep track of on line quiz practise results

    Hello.
    I am in the process of creating a database to keep track of my online quiz practice results and of the questions that I got wrong while practicing. There are 5 Quiz and each quiz has got 10 questions. The result that I would like to get, is being able when i open a table to see for all the attempts of a quiz all the questions I got wrong and that I need to review. I tried to create the database with a table for each quiz and for each attempt and set a quiz id as the primary key to link the table regarding the same quiz. When I am going to try to link the two tables regarding the same quiz with different attempts, is saying that is impossible to create the relationship because some there is no integrity in datas.

    Could anyone to help.



    Thanks so much!!!!

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    I would think you need a tQuiz table.
    Qid,name,date.

    then child table, tQuestions.
    qID,QNum,Q,A,result

    Qnum is the question#, numeric
    Q= the questuion
    A= the correct answer
    Result= the answer given by test taker.

    make a copy of the database before you start,with all Results empty. This is the virgin copy.
    when you want to make another attempt, make a copy from the virgin and use this copy to fill in data.

  3. #3
    morena85 is offline Novice
    Windows 10 Access 2010 32bit
    Join Date
    Aug 2016
    Posts
    2

    Thank you for your response

    Hello.
    Thank you very much for your answer. I will try that out. Thanks again







    Quote Originally Posted by ranman256 View Post
    I would think you need a tQuiz table.
    Qid,name,date.

    then child table, tQuestions.
    qID,QNum,Q,A,result

    Qnum is the question#, numeric
    Q= the questuion
    A= the correct answer
    Result= the answer given by test taker.

    make a copy of the database before you start,with all Results empty. This is the virgin copy.
    when you want to make another attempt, make a copy from the virgin and use this copy to fill in data.

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

Similar Threads

  1. Query Results of same ID/PK to one line
    By wetsnow13 in forum Queries
    Replies: 7
    Last Post: 02-07-2014, 10:38 AM
  2. Replies: 1
    Last Post: 10-12-2013, 04:06 PM
  3. Replies: 3
    Last Post: 05-21-2013, 01:58 PM
  4. Match-Up Quiz
    By nikgupta in forum Access
    Replies: 3
    Last Post: 11-21-2011, 03:02 PM
  5. Replies: 2
    Last Post: 08-05-2011, 01:24 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