check boxes/radio buttons

[Guest]

I have to set up a database for students and there test scores. The test
scores for each student are broken into about 50 areas where attention is
needed to improve. A student could need improvement in one area or 20 or
more areas. I was trying to set up a form that these areas could easily be
checked off. Refresh my memory please...How does this data get into the
database as "saved" material that can be used in reports? In other words if
I check one of the boxes ie. Needs spatial skills, how does this data get
entered into the student database and saved to the individual student's
record.
Thanks
Del Dobbs
(e-mail address removed)
It has been awhile since I set up a database thanks again

 

[Bob]

As a minimum you'll need two tables. One to contain the
general student information the other to contain the fifty
improvement areas and also a linking field such as
StudentID. If you're going to be doing this for multiple
tests then you'll also need a table for test information
that could store general information about each
occurance...Test 1, Test 2...etc.

There are a couple of ways to do what you want. The
simplest way would be to create a form that contains the
check boxes for the 50 improvement areas and add a combo
box at the top that queries the student table and will
store the StudentID. So what you end up with is a form
where the user selects the student first and then runs
through the selection process for the fifty improvement
areas.

It gets more complicated if you're going to be using the
database for multiple tests. If you do you'll have to
include TestID and StudentID in your evaluation table
making sure that StudentID and TestID are part of the
primary key for the table.

The check box selections are stored in the evaluation
table as -1 for a checked box and 0 for an unchecked box.
You could list all of the check box fields on your report
and when the report runs the areas that were selected on
your form will be checked on your report.