A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Teat and Answer random Generator



 
 
Thread Tools Display Modes
  #1  
Old June 20th, 2006, 07:16 PM posted to microsoft.public.access.tablesdbdesign
external usenet poster
 
Posts: n/a
Default Teat and Answer random Generator

What would be the best method to produce a random question test generator
using MS Access 2003? My problem is this...I ave a pool of different tests
with many questions and answerssd but have no easy method of generating a
test which is different from the previous to prevent cheating or memorizing
the test for others.

Any suggestions would be appreciated.
  #2  
Old June 22nd, 2006, 09:40 AM posted to microsoft.public.access.tablesdbdesign
external usenet poster
 
Posts: n/a
Default Teat and Answer random Generator

First a couple of pedantic observations:

The "best" will always be a matter of opinion or agreeing to criteria
and then measuring... I'll propose part of one method below.

Your word "previous" leaves the world hanging awaiting the revelation
of the benchmark. Previous what? When? Do you mean that you want to
keep a record of what you did last time and then make sure you do
something different this time? Are you running your tests off in
batches - generating the tests and then making sufficient copies for
everyone or, as my daughter said she would like - run a different
sequence of tests for each student, printing the student's name on the
test paper so that copying or sharing results in exam conditions would
be unlikely.

The magic solution is to use a STATIC function procedure in a standard
module and call it repeatedly from a query. All required arguments
are passed into the function procedure at each call. You can refer
back to values on the form you used to launch the Report or Query in
the function call. Upon entry, the query will test a "BeenHereBefore"
flag. If it is false, as it will be on the first time through, then
do the initialization such as setting up your selection mechanism and
the random number. On subsequent calls, "BeenHereBefore" will be true
and the procedure runs the iterative portion of the code as required.
Each time the function procedure returns it has set itself to the
value of the selected record. That's what that column of the query
will see..

The above is the core of a mechanism that will serve most cases. You
can surround the concept with other functionality to get the results
you want.

HTH
--
-Larry-
--

"76Jarhead" wrote in message
...
What would be the best method to produce a random question test

generator
using MS Access 2003? My problem is this...I ave a pool of

different tests
with many questions and answerssd but have no easy method of

generating a
test which is different from the previous to prevent cheating or

memorizing
the test for others.

Any suggestions would be appreciated.



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 05:56 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.