How to create a Quiz for Network Users

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

xenothan - 29 Jan 2007 08:19 GMT

Hi,

My Access knowledge is reasonable, but I am struggling to create the
following solution.
I want to create a database to do the following:
1. Allow users to access the system and complete an exam
2. Allow an admin to access the system and setup these exams
3. store the results for the exams by user
4. the Exam will be made up of multiple choice and True or False Questions

Any ideas as to where to start

Appreciated

Reply to this Message

Jesper - 29 Jan 2007 18:03 GMT

> My Access knowledge is reasonable, but I am struggling to create the
> following solution.
[quoted text clipped - 3 lines]
> 3. store the results for the exams by user
> 4. the Exam will be made up of multiple choice and True or False Questions

A exam/questionaire db is not completely trivial if it needs to care for
different answer types, different amounts of questions etc.
I've done something like this and got some good inspiration from Duane
Hookoms "AtYourSurvey" database.
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane
The key point for me was to normalize the whole thing correctly thus having
the answers and questions in records, not columns.

/ Jesper Fjølner

Reply to this Message