By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,490 Members | 892 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,490 IT Pros & Developers. It's quick & easy.

multiple choice questions template in msaccess

mb60
P: 36
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
Share this Question
Share on Google+
3 Replies


Expert Mod 2.5K+
P: 2,545
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
P: 36
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

Expert Mod 2.5K+
P: 2,545
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

Post your reply

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