473,322 Members | 1,504 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

multiple choice questions template in msaccess

mb60
37 32bit
hello
I am working as teacher. Pl any one can help me in creating a template for multiple choice questions, and matching questions and selecting the answers in ms access? The format of qns as follows
1). xxxxxxxxxxxxxxxxxx
1) aaaaaaaaaaaa 2) bbbbbbbb
3) cccccccccccc 4) dddddddd
2) Match the following
List - I List -II
A) aaaaa I) bbbbb
B) ccccc II) ddddd
C) bbbbb III) aaaaa
D) dddddd IV) ccccc
V) eeeeeee
Choose the correct
1) A-III,B-IV,C-I,D-II 2) A-III,B-IV,C-I,D-V
3) A-II,B-IV,C-I,D-III 4)A-III,B-V,C-I,D-II
Aug 13 '08 #1
3 8955
Stewart Ross
2,545 Expert Mod 2GB
Hi mb60, and Welcome to Bytes! I wish it was possible to give you a solution to what you ask, but the use of Access is really not going to help you much for the production of multiple-choice papers. Relational databases are really at their best in modelling multiple relationships between distinct named entities represented as individual tables, each comprised of columnar attributes given distinct names. The production of multiple choice question papers is more a matter of presentation than of data storage, as the number of distinct entities involved is fairly small (entities such as test paper, question, response - and that's about it). The presentation format for multiple choice questions is not a natural one for Access (or any other relational DB) and may require bespoke VBA coding to implement.

It is possible to devise rigid question formats which could be implemented more easily (e.g. by restricting questions to have the same number of responses in all cases, say four) but the rigidity of such approaches makes the resulting test paper very inflexible and leads to artificial choices of distractor responses simply to make up the numbers.

In my opinion, Access is not the right choice. There are purpose-designed application for the production of multiple choice question papers, but in their absence it is more time- and cost-effective to use Word or some other text presentation tool than it is to use a database to prepare multiple choice papers. When I used to prepare test papers myself I simply used Word to do so - no databases at all.

-Stewart
Aug 20 '08 #2
mb60
37 32bit
Thankyou sir.for your suggestion.

recently by using msaccess I created multiple choice format. but I unable to select the question to generate the paper. if you permit me I'll send to for your perusal.

mb60
Aug 27 '08 #3
Stewart Ross
2,545 Expert Mod 2GB
Hi. I have sent you a private message in which I have provided my e-mail address if you wish to send me a copy of your DB. I can't promise to resolve the problem for you but I'm happy to have a look at it if this might help

-Stewart
Aug 27 '08 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: Mohammed Mazid | last post by:
Can anyone please give me some clues on how to track the right answers in multiple-choice type questions (using checkbox) and single-choice questions (rdio buttons) and also how to store the right...
9
by: WL | last post by:
Hey, all. I'm creating an array of strings (char **argv style) on the fly, and using realloc to create string pointers, and malloc for the strings itself (if that makes any sense). I'm using the...
9
by: Graham | last post by:
I have been having some fun learning and using the new Controls and methods in .Net 2.0 which will make my life in the future easier and faster. Specifically the new databinding practises and...
5
by: rick m | last post by:
We have a fairly good sized Access database that contains some info on the children our agency sees. We also have 40+ templates that require some info from the database be inputted into them, such...
5
by: Kaur | last post by:
Hi, I have been successful copying a vba code from one of your posts on how to copy and paste a record by declaring the desired fields that needs to be copied in form's declaration and creating two...
1
by: raiya | last post by:
hi, I'm a teacher and new ms access user. I'm intending to design an ms access db to post multiple choice questions each with 4 choices. I created 2 tables one for the questions and the other for the...
1
by: Brian Byrne | last post by:
Hi , Does anybody know where there is a good bank of C++ multiple choice questions covering all the essentials. I need to brush up on the basics and multiple choice is the ideal way !? ...
3
by: shashkun | last post by:
hii i wanted to insert questions, options and correct answer in the database(Multiple choice questions). I have around 8000 questions to be inserted. I tried with copying entire content from word...
482
by: bonneylake | last post by:
Hey Everyone, Well i am not sure if this is more of a coldfusion problem or a javscript problem. So if i asked my question in the wrong section let me know an all move it to the correct place. ...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.