How to Enter Exam Marks (1 Viewer)

The_Doc_Man

Happy Retired Curmudgeon
Local time
Today, 04:53
Joined
Feb 28, 2001
Messages
16,827
This looks suspiciously like a class assignment. If you had devised this structure yourself, you should know the answer because you would have built the tables yourself. Anyone who can build that complex a layout would be experienced enough to build the right kind of form.

Just to not blow you off completely, though, it is obvious you need a form that would let you select a particular exam, a subject, and a specific student. If you have those items selected, then one more text box would be needed for the grade itself.
 

SajidAmbar

New member
Local time
Today, 14:53
Joined
Feb 18, 2020
Messages
5
No sir
 

The_Doc_Man

Happy Retired Curmudgeon
Local time
Today, 04:53
Joined
Feb 28, 2001
Messages
16,827
I can't reasonably send you a solution, I can only suggest that you use the form builder with control wizards enabled. This is a "Help" forum, not a "Do my work for me" forum.

In your application, you asked for data entry so what I might do is build a bound form based on your Marks_Entry table. On it put a combo box to select the student. Put another combo box to select the subject. Put yet another combo box to select a specific exam. Finally, one more combo for the Class ID. Then put a text box on the form to allow free-form grade entry. You can use the "standard" Access control bar at the left side of the form that allows you to choose when to save a new record. That would be my idea of the simplest approach.
 

plog

Banishment Pending
Local time
Today, 04:53
Joined
May 11, 2011
Messages
9,814
You need to fix your table relationships before anything. There should only be one way to trace a path between 2 tables. Between tbl_students and tbl_Classes I can trace 2 paths--one thru Class_Enroll and one through tbl_Marks_Entry. That is wrong. I think a lot of tables are related incorrectly.

tbl_students should be related to Class_Enroll
tbl_Classes should be related to Class_Enroll
tbl_Subjects should be related to tbl_Subjects

You should have a new table called tbl_Exams which is related to Class_Enroll

tbl_Exam_Type should be related to tbl_Exams
tbl_Marks_Entry should be related to tbl_Exams

This wil require adding/removing appropriate foreign keys from the new relationships in each table.

Work on that before moving on.
 

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

Top Bottom