D
d_k_harris
Hi,
I have a database that staff enter details into that tracks student
progress at interim
periods throughout the year. This then produces reports that get sent
home and parents
use to see how their child is doing. The database is setup with a
main table tblPupilData
that stores core information about the pupil and the subjects that
they are in. This table
is related to individual subject tables with referential integrity
enforced which stores the
details staff enter on the students progress.
Table structures are as follows:
tblPupilData
PupilID - Autonumber (Primary Key), Name - Text, M/F - Text, DOB -
Date/Time, SEN - Text,
BESD - Yes/No, MLD - Yes/No, ADHD - Yes/No, EAL - Yes/No, LAC - Yes/
No, LAC - Yes/No, G&T - Text,
Band - Text, TutorGroup - Text, CATSVerSAS - Number, QuantSAS -
Number, NonVerSAS - Number,
Mean - Number, VAK - Text, EnglishSAT - Number, MathsSAT - Number,
ScienceSAT - Number, EnglishKS2 - Text,
MathsKS2 - Text, ScienceKS2 - Text, EnglishKS3TL - Text, MathsKS3TL -
Text, ScienceKS3TL - Text,
ReadingAge - Number, WritingAge - Number, EnglishSet - Text, MathsSet
- Text, ScienceSet - Text,
RESet - Text, RETL - Text, ICTSet - Text, ICTTL - Text this carries on
with each SubjectSet followed SubjectTL.
tblSubjectData (One table for each subject).
PupilID - Number, Session1Effort - Number, Session1Attainment -
Number, Session1Behaviour - Number,
Session1Homework - Number, Session1Coursework - Number, Session2Effort
- Number, Session2Attainment - Number,
Session2Behaviour - Number, Session2Homework - Number,
Session2Coursework - Number, Session3Effort - Number,
Session3Attainment - Number, Session3Behaviour - Number,
Session3Homework - Number, Session3Coursework - Number.
This works fine however I am now trying to improve the system by
allowing each subject to store module scores at various times
during the year when a module is completed I am also trying to get a
section on the data entry form that works out an average mark for
modules that have been completed so far. I created fields in the
tblSubjectData to store this information which it does do
but whenever I try to work out an Average it works out the Avaerage
for the whole column and not the row for the students. I also tried
to set the
Module fields up in the tblPupilData but when I do this it does not
allow me to enter any information
in the form. It only allows me to enter data into the table
directly. (I do not want other staff to have access to the table
directly).
Does anyone know how I can solve this, I am a complete beginner with
Access and have limited knowledge so explanations in simple terms
would be ideal.
In the future I would also like to add some kind of ability to conduct
lesson registration
so comments on how I could do this wouldn't go amiss.
All help will be greatly appreciated.
Many Thanks.
I have a database that staff enter details into that tracks student
progress at interim
periods throughout the year. This then produces reports that get sent
home and parents
use to see how their child is doing. The database is setup with a
main table tblPupilData
that stores core information about the pupil and the subjects that
they are in. This table
is related to individual subject tables with referential integrity
enforced which stores the
details staff enter on the students progress.
Table structures are as follows:
tblPupilData
PupilID - Autonumber (Primary Key), Name - Text, M/F - Text, DOB -
Date/Time, SEN - Text,
BESD - Yes/No, MLD - Yes/No, ADHD - Yes/No, EAL - Yes/No, LAC - Yes/
No, LAC - Yes/No, G&T - Text,
Band - Text, TutorGroup - Text, CATSVerSAS - Number, QuantSAS -
Number, NonVerSAS - Number,
Mean - Number, VAK - Text, EnglishSAT - Number, MathsSAT - Number,
ScienceSAT - Number, EnglishKS2 - Text,
MathsKS2 - Text, ScienceKS2 - Text, EnglishKS3TL - Text, MathsKS3TL -
Text, ScienceKS3TL - Text,
ReadingAge - Number, WritingAge - Number, EnglishSet - Text, MathsSet
- Text, ScienceSet - Text,
RESet - Text, RETL - Text, ICTSet - Text, ICTTL - Text this carries on
with each SubjectSet followed SubjectTL.
tblSubjectData (One table for each subject).
PupilID - Number, Session1Effort - Number, Session1Attainment -
Number, Session1Behaviour - Number,
Session1Homework - Number, Session1Coursework - Number, Session2Effort
- Number, Session2Attainment - Number,
Session2Behaviour - Number, Session2Homework - Number,
Session2Coursework - Number, Session3Effort - Number,
Session3Attainment - Number, Session3Behaviour - Number,
Session3Homework - Number, Session3Coursework - Number.
This works fine however I am now trying to improve the system by
allowing each subject to store module scores at various times
during the year when a module is completed I am also trying to get a
section on the data entry form that works out an average mark for
modules that have been completed so far. I created fields in the
tblSubjectData to store this information which it does do
but whenever I try to work out an Average it works out the Avaerage
for the whole column and not the row for the students. I also tried
to set the
Module fields up in the tblPupilData but when I do this it does not
allow me to enter any information
in the form. It only allows me to enter data into the table
directly. (I do not want other staff to have access to the table
directly).
Does anyone know how I can solve this, I am a complete beginner with
Access and have limited knowledge so explanations in simple terms
would be ideal.
In the future I would also like to add some kind of ability to conduct
lesson registration
so comments on how I could do this wouldn't go amiss.
All help will be greatly appreciated.
Many Thanks.