Calculating from checkboxes

ppoindexter

Registered User.
Local time
Today, 06:56
Joined
Dec 28, 2000
Messages
134
i have a database with several tables and
I made a form to gather test results from students....each question is represented on the form by a check box to show if the student anwered the question right or wrong

I am trying to make a form(s) and/or reports (not sure which to use) that will allow me to determine the test results (as entered in the form) in a variety of ways:

by students
by gender
by grade level
by classroom
by campus
by district
by specific test question (such as to know how many students can add whole numbers..)

i am new to access and am stuck
i have the tables set up and the data gathering form and am able to enter information..just dont know what to do next
do i make querries..forms..both and how do i make totals for each category ...should i use page tabs for each category with a form where the user can put in the criteria..ie..females/obj1/oxford elementary
......
 
Reports - make reports for yourself to look at. Similar to the forms you have made,but make the forms continuous instead of single. You can also print out these forms with a command button to print when you click on it.
 

Users who are viewing this thread

Back
Top Bottom