advice urgently appreciated 
Author Message
 advice urgently appreciated

I am currently studying for an MSc in Computing (Conversion course) and
having finished the taught element of the course, I have now moved onto
the project stage. My project involves researching and implementing an
item of software for a local company.

Essentially, I have to produce a testing program that can be used to
help employers to test interviewees in a variety of technical areas
(i.e. in the manner of MCSE testing software etc.). Questions are to be
stored in a relational database in respective question categories which
can be user-defined by the employer and updated and maintained as and
when required.

An actual test will consist of x number of questions from x number of
categories. The system must also have the facility to store details of
various tests so that they can be recalled by the employer.

The front end of the software will display questions in multiple choice
format to be answered by the interviewee. If they cannot answer a
particular question there must be a facility to move onto the next
question and return to the unanswered question later. The test will be
time limited and a score will be presented upon completion.

The front end will not enable the user to access the bank of questions
etc. i.e. it must be locked.

I am no programming expert and have been wondering what the best way is
to implement a workable solution. My initial idea is to store the
questions / test details in an Access 97 database and use a VB5 front-
end to carry out the actual test. Another possible solution is to use a
web browser as the front-end that interfaces with the database.

I am posting to ask whether anybody can offer any suggestions on the
feasibility of my solution or any alternative solutions. I am
particularly concerned at the level of code complexity that would be
required to interface the front-end and the database and subsequently do
not want to start down one path only to find that it is not feasible.

Thanking you in advance for any advice offered.

best regards
--
J. Edgar



Tue, 06 Nov 2001 03:00:00 GMT
 advice urgently appreciated

I have written a test program exactly as you described.  My program was
built with VB and Access but has been subsequently upgraded to SQL 7.0.
This program is a typically 3-tiered C/S application.  It has an object
model (built with VB classes) that acts as the middle tier - this allows me
to use a VB front end or IIS/ASP and a web browser.  I would suggest that
you take time to build a similar model so that you would not be limited in
your choices for clients.
-blitz
Quote:

>I am currently studying for an MSc in Computing (Conversion course) and
>having finished the taught element of the course, I have now moved onto
>the project stage. My project involves researching and implementing an
>item of software for a local company.

>Essentially, I have to produce a testing program that can be used to
>help employers to test interviewees in a variety of technical areas
>(i.e. in the manner of MCSE testing software etc.). Questions are to be
>stored in a relational database in respective question categories which
>can be user-defined by the employer and updated and maintained as and
>when required.

>An actual test will consist of x number of questions from x number of
>categories. The system must also have the facility to store details of
>various tests so that they can be recalled by the employer.

>The front end of the software will display questions in multiple choice
>format to be answered by the interviewee. If they cannot answer a
>particular question there must be a facility to move onto the next
>question and return to the unanswered question later. The test will be
>time limited and a score will be presented upon completion.

>The front end will not enable the user to access the bank of questions
>etc. i.e. it must be locked.

>I am no programming expert and have been wondering what the best way is
>to implement a workable solution. My initial idea is to store the
>questions / test details in an Access 97 database and use a VB5 front-
>end to carry out the actual test. Another possible solution is to use a
>web browser as the front-end that interfaces with the database.

>I am posting to ask whether anybody can offer any suggestions on the
>feasibility of my solution or any alternative solutions. I am
>particularly concerned at the level of code complexity that would be
>required to interface the front-end and the database and subsequently do
>not want to start down one path only to find that it is not feasible.

>Thanking you in advance for any advice offered.

>best regards
>--
>J. Edgar



Tue, 06 Nov 2001 03:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Considering New Purchase Appreciate advice

2. Advice appreciated

3. Advice appreciated on date programming issue

4. Any help or advice appreciated

5. NEED ADVICE URGENTLY - msvbvm50.dll caused error...

6. SQL Server Guru urgently needed for setup advice

7. SQL Server Expert Urgently Needed For Win XP Pro advice

8. Your Advice: SQL datetime?? :Your Advice

9. Sybase Newbie upgrading NT3.51 to 4.0 and S10.x to 11.x - Advice appreciated.

10. IMMEDIATE help appreciated

11. Transaction not working -- help appreciated

12. Counting occurances of a datatypes in a database - HELP on SQL for this appreciated


 
Powered by phpBB® Forum Software