Student scores need averaging.

[d_k_harris]

Hi I am new to Access but have muddled my way through to create a
student tracking database. This database stores core information
about pupils in the main table and individual subject data in subject
tables. One of my subject tables stores scores for seperate modules
(example of field names: PupilID, Module 1 Level, Module 2 Level,
Module 3 Level, Module 4 Level, Module 5 Level, Module 6 Level,
Overall Level) I am trying to calculate an Average score to
automtically be entered into the Overall Level field from when data is
entered into the Module fields when a module is marked. I have
searched through various threads and forums and from what I can make
out Access only Averages values in a column and not across fields in a
record. My second problem is that not all module levels will be
entered at the same time. I have also read in forums that this can
cause a problem. Ideally I would like a solution so that when a
member of staff enters a score in Module 1 Level it then puts the
Average score in the Overall Level field then when Module 2 Level is
entered it adjusts the Overall Level again.

Sorry if this is a bit difficult to understand.

Any help would be greatly appreciated. Many Thanks.

 

[Guest]

Change the structure of your third table from PupilID, Module 1 Level, Module
2 Level, Module 3 Level, Module 4 Level, Module 5 Level, Module 6 Level,
Overall Level) to this --
PupilID
Subject - text
Module Level - text
TestDate - DateTime field
Score - number - single

Do not store 'Overall Level' as it is computed and changes. You can join
the main and subject tables in the same query.

You can use a totals query to produce the average.