Hello all,
I am creating a Test database simular to that of the MCSE or CCNA (however not online, but in the form of an exe of Access Tables connceted to a Visual Basic 6.0 GUI) whereby there will over 50 users. The tables are:
USER (User_ID, LastName, FirstName, Dept)
SECURITY (User_ID, Password)
QUESTION (Answer_ID, AnswerText, QuestionText, AnswerWeighting)
RESULT (Test_ID, User_ID, Answer_ID, 0101, 0102, 0103 etc...0650)
There are 6 modules, with 50 questions a module,e.g 0101 is the ID to module 1, answer 1.
Do the tables seems okay?
Also, I wanted to create one form in VB whereby 10 random questions are generated from one module, but can it all be done on one form, where I can just make a cmd button to display the next question but on the same form, or do I need to create a form for every question. If I can do it on one form...how?
Any help or Coding would be extremely appreciated.
K992081
I am creating a Test database simular to that of the MCSE or CCNA (however not online, but in the form of an exe of Access Tables connceted to a Visual Basic 6.0 GUI) whereby there will over 50 users. The tables are:
USER (User_ID, LastName, FirstName, Dept)
SECURITY (User_ID, Password)
QUESTION (Answer_ID, AnswerText, QuestionText, AnswerWeighting)
RESULT (Test_ID, User_ID, Answer_ID, 0101, 0102, 0103 etc...0650)
There are 6 modules, with 50 questions a module,e.g 0101 is the ID to module 1, answer 1.
Do the tables seems okay?
Also, I wanted to create one form in VB whereby 10 random questions are generated from one module, but can it all be done on one form, where I can just make a cmd button to display the next question but on the same form, or do I need to create a form for every question. If I can do it on one form...how?
Any help or Coding would be extremely appreciated.
K992081
