Is your test score set up like this?
And this relationship?
Students::StudentID = TestScores::StudentID
It's important that there be one and only one test score in a given TestScores record. (But there can be multiple TestScores records for a given student.)
If that's your setup, I'd suggest a summary report based on the Test Scores layout, with fields from Students added as need to supply information about a given student in the report. You can use summary fields and Sub Summary layout parts with sorting to group your scores first by student and then by type of test score.
Thank you, PhilModJunk!
I think that's just the thing that I need to be in the test score table to make those sub summaries and grand summary. I was trying to create a field in the student table that would lookup the test scores and then I couldn't figure out how to create fields that would do the needed calculations (find averages/high/low/median of all our students in our program on the different tests, etc). (Also, those relationships look like the ones I have set up.)
I think this means, however, that I have my test scores table formatted with incorrect fields. Within the test scores table (that lists the hundreds of different tests our students have taken individually) there is a field called "test code" and then there is a field called "test score." To manipulate this data better, would you recommend that I merge the two pieces of information so instead of "test code = Praxis I Mathematics"; "test score = 180" that I just have several fields that describe the test and then the data inside is the score? So field name = "Praxis I Mathematics" ; data = 180, 182, 140. Field name "Praxis II: Social Studies Content"' data 172, 155, 190.
In that case, for each test record I would have several field that have no data because each record only describes one test score.
I'm running myself in circles. I'm not a DBA (obviously) just a teacher trying to organize!
I think I just partly answered my own question by writing it out. Having all those test fields would be silly. I just need to write a script that would generate a report that would first sort by test score code and then do the calculations that I would need as part of the script.
The "sort" would take care of the fact that they aren't all the same test code.