Conducting a test within organisation

[randenius]

Here is a little background of the task. We are trying to move away from our conventional way of conducting test using hardcopy test papers. About 400 candidates are suppose to sit for the test which has 50 MCQs. I am limited with the software that I can use as we're not supposed to install any third party software. I was told that Access may be one option to consider.

What I have in mind is to be able to automate the process of marking and consolidating the test results received from all the candidates. Currently as I am very new to Access, I would appreciate if someone could let me know if this is possible and point me to the right direction in order to achieve this task. Do let me know if more details are needed. Thanks!



EDIT: I was browsing through the help file in Access and came across a way to import/link external data. An idea that I have now is to create a form which will serve as the test paper and send this to all the candidates, get them to complete the test and send back to me. Afterwards, I'll import all these files and consolidate the results. I suppose it is possible to use VB to automate this process? Is this method feasible?

[June7]

I don't think it will be easy in Access 2000. Review http://msdn.microsoft.com/en-us/libr...ew_webfeatures

Access 2007 has feature called Collect Data that allows data collection via emails in Outlook.

[randenius]

Sorry for not mentioning earlier, our organisation is actually running on microsoft office 97. There was no option for Access 97 when creating this forum account.

[June7]

In what form will this 'form' be sent to candidates - Access, Excel, Word, form-fill PDF? Yes, VBA can automate importing data from the first 3. It is a common topic in forums and tutorials.