Need to first define the problem

A

atejani

New member
Local time
Today, 21:36
Joined
Nov 19, 2019
Messages
3
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.
 

Attachments

Hi and welcome to AWF.
You posted to sample databases which is a moderated area not intended for questions.
I've moved it to a more suitable forum.
Someone will be along soon to offer suggestions
 
atejani said:
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.
Click to expand...
Asief,

in access, form objects can be viewed in "datasheet" view and if you want a form to display like, for example, the tab called "Grade 1A Data" in your sample excel file, you would create a form in access, set the recordsource to a query which joins the fields of the "students" table and "classes" table and set the "default view" to datasheet. you've got a large amount of data, so I'm not sure you'll find anyone here who is willing to provide u with a sample database that you can learn from without being paid for doing it.
 
Hi

You say "Each class has a fixed number of students and fixed subjects."

When a Student moves to a higher Class do the Subjects stay the same??
 
Asief
I'm not trying to sell you anything but you could have a look at the free demo ACCDE versions of two of my commercial schools apps : School Data Analyser and Student ICT Database.
The first is a very wide ranging app and a big download. The full version is almost certainly well beyond your budget. However it may give you some ideas.

The second app is more specific but may help you get started. See if it helps
 
mike60smart said:
Hi

You say "Each class has a fixed number of students and fixed subjects."

When a Student moves to a higher Class do the Subjects stay the same??
Click to expand...

No they do not.. any idea how to go about it?
 
Hi
With the number of Class's & Students it would take some time to put together an example for you.
 
Just a simple example would do - 5 students and 2 classes... I could then replicate it on a larget scale
 
Hopefully the attached quick demo I just created will help.
Note the use of a junction table tblStudentClasses.
Also the use of referential integrity in the relationships window.

I do recommend you look at the links I provided and possibly download the demo versions.
 

Attachments

Largely agree with Pat's comments

The starter app I supplied earlier has 4 tables
tblStudents
tblSubjects
tblClasses - Class & subject
tblStudentClasses - Students in each class

attachment.php


In my opinion there is no reason to add a separate junction table tblSubjectClasses as each class will be for only one subject. If that's not the case for you then add it as well

I omitted the grades part as I wanted to leave something for you to do yourself.
However I suggest you need to add at least two tables for this:
tblGrades - grades available for each type of class
tblStudentGrades - student grades and comments for each class taken
 

Attachments

  • Capture.PNG
    Capture.PNG
    9.7 KB · Views: 275
Hi Asief

Do you have specific Terms within an Academic Year?
 
You must log in or register to reply here.

Similar threads

K
Flynn, The first AI college student
Replies
4
Views
740
Uncle Gizmo
Uncle Gizmo
D
Hello from Maryland
Replies
5
Views
523
Isaac
Isaac
H
Entering the attendance of the whole class with a default value automatically
Replies
5
Views
1,136
MarkK
MarkK
MsAccessNL
  • Locked
Webbrowser in Form without Control !!!! Years to late....
Replies
19
Views
1,563
Jon
Jon
A
Solved Call data to a list box depending on combo box list
Replies
10
Views
1,071
June7
June7

Users who are viewing this thread

Total: 1 (members: 0, guests: 1)
Back
Top Bottom