The following assumes you will submit a floppy disk  If you instead email the files to me, they should all be in the same directory.  Feel free to email me if you run into problems with this project.  Hopefully you should be able to complete the project relatively easily.  If you would like to do a different project than the one described below, or the deadline represents a problem, please email me.

1. Create in Access a database named quiz.mdb in the root directory of your floppy. In this database, create a table with at least 3 multiple choice quiz questions pertaining to Cold Fusion.

2. Enter into this database correct answers and incorrect answers for each question.  Your database should accommodate the possibility of different numbers of answers to different questions without using fields such as answer1, answer2, etc.  One way to do this would be to create two tables: one for questions and one for answers.

3. Name your initial file (the one the user begins with) index.html, index.cfm, or some other suitable name that indicates which is the beginning file of your application.

4. Create one or more Cold Fusion pages which read(s) the database and displays the question, followed by the possible answers with each answer preceded by a radio button.  The user then makes a choice and clicks a button to submit the answer. 

5. If the user's answer is correct, an appropriate message should be displayed and there should be a way for the user to go to the next question.  If incorrect, an appropriate message should be displayed and there should be a way which takes the user back to the question so that the user may try again.

6. When the user is finished, the application should tell the user what percent of questions the user got right on the first try.

Enhancements:

Although there is no need in terms of a grade to do anything more, if you are so inclined, you may want to include enhancements such as the following:

1) Create a form such that addition of the questions and answers to the database is done in the browser rather than directly in Access.

2) Make the test a timed one.  Display the time left at periodic intervals and stop the test when the time is up.

Due: Wednesday, December 18 4PM.  Comments to William Pegram, wpegram@nvcc.edu