Database Question

[DavidWilson]

Hi,

I am a teacher and I've set up and Access Database.
In the database teachers across subjects can enter tests scores for pupils
at any times they want.
So for example say my fields are "Pupil", "Subject", "Date of Test" "Score",
"Score %" etc...
Through the year teachers would enter data about their pupils after each
test they have done.
Is it possible at the end of the year to produce a summary report for each
pupil so that at the end of the year it will given them AVERAGE score for
each test, instead of just listing all the scores separately

Many Thanks

David

 

[Arvin Meyer]

Did you mean each test or each subject? Each test, you already have and need
to only calculate the value in a new column. The percentage will be the same
as the score if the score is relative to a hundred, or the score divided by
the number of possible points. Just add a column to do the math:

Expr1: [Score]/200

For the Average of each student, or each student by subject, you'll need a
Totals query (use the Sigma button or chose it from the menu). Something
like:

SELECT StudentID, Subject, Avg([Score]) AS AvgOfScore
FROM tblTest
GROUP BY StudentID, Score;
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access