Hi all..
Just had this one dumped on me by the Principal who asked if I could set up a database that would hold the names of all the pupils in the school and their respectives grades, marks and effort for each individual subject that they do.
Has anyone a sample of this type of database. I'm not hot on MSAccess but would like to learn and this looks like a challenge.
Setting the tables up seems to be the biggest headache and based on my limited knowledge, I stabbed at a guess that the tables I'm going to need are tblstudents, tblsubjects and tblgrades.
My understanding is the students can take one or more subjects and a subject can have one or more grades attached to it but am I right in the way I interpret it all?
Based on a form, I would like the Teacher to select the relevant subject they teach from a dropdown menu which would say, bring up the subject 'Art' which would show in a subform, all the students who do Art and beside their name, would show the fields for Grade, Mark & Effort in which the staff would enter the relevant information.
IS this possible?
Regards
Declan Barry (confused)
Just had this one dumped on me by the Principal who asked if I could set up a database that would hold the names of all the pupils in the school and their respectives grades, marks and effort for each individual subject that they do.
Has anyone a sample of this type of database. I'm not hot on MSAccess but would like to learn and this looks like a challenge.
Setting the tables up seems to be the biggest headache and based on my limited knowledge, I stabbed at a guess that the tables I'm going to need are tblstudents, tblsubjects and tblgrades.
My understanding is the students can take one or more subjects and a subject can have one or more grades attached to it but am I right in the way I interpret it all?
Based on a form, I would like the Teacher to select the relevant subject they teach from a dropdown menu which would say, bring up the subject 'Art' which would show in a subform, all the students who do Art and beside their name, would show the fields for Grade, Mark & Effort in which the staff would enter the relevant information.
IS this possible?
Regards
Declan Barry (confused)