Full App - Create Your Own Training Quizzes

[pkstormy]

This is a neat little Training Quiz program I designed. It lets you create your own questions/answers assigning them to a topic (where you can create new topics). You can also assign points to each answer, add more information to show after a question is answered, plus many other features.



You can also select your own character, select the character you want to ask you questions, and easily add new characters.

There's a game aspect to this where you try to reach the end of the map, competing with other characters to reach the end. There's a lot of extra features in this example which can also be used for other applications.

You can easily create any new Topics and add questions under those topics (ie. "For New Staff", "Database Related", "MSAccess Related", "Patient-Nurse Dialog Training", etc...etc...)

It includes an "MSAccess Related" topic which has a hundred or so MSAccess questions (such as: "A combobox has...", "This property of a form does...", "What is bound versus unbound", etc...etc...) Good for learning MSAccess.

Enjoy!

Note: You may need to refresh the linked tables if you're using another folder other than the 'C:\TrainingQuiz' folder (where it's looking for the backend StaffQuizTrainingXP_BE.mdb file.) It automatically knows though to look in \DBPics\ sub-folder for the pictures in whatever folder you've put TrainingQuiz.mdb in. Also, there's an 'import picture' routine which automatically adds whatever picture you select to the \DBPics\ sub-folder and renames that *.jpg file to SPictureX.jpg where X is the next sequential Picture in the folder (ex: you select a picture called: MyPortrait.jpg. It will copy MyPortrait.jpg to the \DBPics folder and automatically rename it SPictureX.jpg where X is the next sequential number - ie. SPicture23.jpg). That picture then becomes available for a user to select (ie. PictureNumber = 23).

Also note: Instead of saving a picture into the OLE Object field in the table (which would bloat the mdb), this uses a routine which saves the picture # (of the *.jpg filename itself). Thus, in the user table, the PictureNumber field might have a value of 4 for a user which tells the code to look for SPicture4.jpg in the \DBPics\ folder. This makes it very easy to change a Picture (ie. Picture Number) for a user and it will know the correct jpg picture to grab from the folder (this also applies to the PictureNumber field for the *.jpg picture of who will ask the questions.)

For example, as a user cycles through their selection of a Picture Numbers (ie. 1, 2, 3, 4...), as they cycle through each Picture Number, the code grabs SPicture1.jpg or SPicture2.jpg or SPicture3.jpg, etc... from the \DBPics folder to the MSAccess form (ie. it populates the .Picture property with the *.jpg name of the image field). The code knows what the last picture number of all the *.jpg pictures is in the \DBPics sub-folder so a user can't select Picture Number 30 if there isn't an SPicture30.jpg in the \DBPics sub-folder (ie. the Picture Numbers allowed for selection correspond to the X in SPictureX.jpg).

This same type of process can be used for other applications where storing the actual picture (or filename) isn't an option and instead, just a number is stored which corresponds to the number as part of the jpg filename itself.

.