Hello,
We are a charitable organization called WIPAHS here in Tanzania (Africa) looking after the needs of marginalized communities. Currently we use excel VLOOKUP to generate our report cards for the students but we would like to track the students progress as they move from year to year.
Each class has a fixed number of students and fixed subjects. Basically when I change the class I need the sub-form/datasheet to change the subjects and students depending on another table. It needs to look like an excel sheet (datasheet with students downwards and subjects sideways) and not a normal form which I see on many templates.
Our budgets are very limited so I have been tasked to learn how to do it in Access. I need to first phrase the problem in google so I can find an answer. Any tips from your side would be much appreciated. Am willing to learn VBA/SQL as I enjoy self-studying.
Thanks and regards,
Asief.
We are a charitable organization called WIPAHS here in Tanzania (Africa) looking after the needs of marginalized communities. Currently we use excel VLOOKUP to generate our report cards for the students but we would like to track the students progress as they move from year to year.
Each class has a fixed number of students and fixed subjects. Basically when I change the class I need the sub-form/datasheet to change the subjects and students depending on another table. It needs to look like an excel sheet (datasheet with students downwards and subjects sideways) and not a normal form which I see on many templates.
Our budgets are very limited so I have been tasked to learn how to do it in Access. I need to first phrase the problem in google so I can find an answer. Any tips from your side would be much appreciated. Am willing to learn VBA/SQL as I enjoy self-studying.
Thanks and regards,
Asief.