john Wesley

Short question that should hopefully bring many answers:

I have four weeks or less to develop a database application that allows the users to simulate a series of tests, or one test with many sections whichever way put. Any general advice or tips in this area?

Note: All the questions and answers are in the palm of my hand and are taken from an official revision book, the test is for people in construction who want a CSCS Card which here in England is what allows you to gain access to to a site. The card and certificate reprisent you know, understand and can carry out health & safety procedures while at work.

Thanks for any advice given.
JWH

__________________
Mona Lisa must of had the highway blues you can tell by the way she smiles..

big_k105

So what you need is more or less a system on the computer where people can take some tests to prove they can get the CSCS Card and be allowed on the construction site? Wouldn't you probably just need 1 database that will hold the questions and another one that lists the different tests and then in the questions table have a foriegn key that would be a link to the primary key of the tests id, I guess you would probably also possibly want another table with the for the people who have taken the test but I don't know if you need that or not.

__________________
BIG K aka Kyle
Programming Forums
Kyle K Online

Please do not PM or email me programming questions. Post them in the forums instead.

john Wesley

Our place is a training facility and the actual test's get taken externally, the training beforehand also is not extreme, maybe up to a week. Due to this we initially agreed rememberence of users was not needed as long as the program could print out a copy of the test just taken with relative information. Today I proposed a different approach, one that allows users to be entered along with there 'Due to end' date, thus allowing the entries to be deleted by referring to this date.

This way I figured the application would be more effective for training by allowing data to be linked for the time they are there, for example we could then derive how many tests they have taken, how many passed etc. Adding a deletion process to the application would keep it clean and tidy I guess, rather than just hold mountains of data only relevant to people whom they we will never see again.

EDIT: Apologies for not mentioning earlier, I am restriced to MS Access.

__________________
Mona Lisa must of had the highway blues you can tell by the way she smiles..

Ooble

You might also want to bear the Data Protection Act in mind, which states you can't hold data on people for longer than you need to.

Good luck.

__________________
Me :: You :: Them