Student Progress Database Application

Anonymous
2016-11-08T11:25:10+00:00

Hello everyone!

I want to make an application for keeping track of students’ progress marks each month of the year using Access 2010. Suppose I have 10 literacy centers in 10 different locations each with 35-40 students enrolled. I want to generate a monthly Access  report showing the progress of each student in each of the subjects taught.

I have designed forms for entering details of each center, instructor and student saved in separate tables. All I need to do is find a way to generate month-wise students’ progress reports for each of the 10 literacy centers to be handed over to the center manager.

What would be the best way this could be done using Access 2010?

Thank you.

~~Maneesh

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

139 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2016-11-08T15:07:05+00:00

    Hi Scott,

    Here I am with the corrections. I've got a screenshot with the changes. Please see the structure below. I did not properly understand the tblTeachers very well. You stated above to add a FK for the TeacherID, but where is the FK that should be joined to this PK?

    Please see the following:

    Kindly have a look and suggest changes, if any.

    Thanks.

    ~Maneesh

    Was this answer helpful?

    0 comments
  2. Anonymous
    2016-11-08T13:46:49+00:00

    Hi,

    Thanks for the suggestions on improving the table. Let me make the changes to the tables according to the suggestions and get back to you.

    And no, this is not a homework assignment. This is actually a production application I am designing for managing our education centers.

    Thanks, I'll get back in an hour.

    ~Maneesh

    Was this answer helpful?

    0 comments
  3. ScottGem 68,840 Reputation points Volunteer Moderator
    2016-11-08T13:31:34+00:00

    Sorry,, but that is not a properly normalized structure. You need more tables and some changes:

    tblCenterdetails: Rename the ID field as CenterCode, remove TotalStudents since that should be calculated not stored. Add a Teachers table and remove all the teacher info and add a foreign key for Teacher ID. This is assuming that there is only one teacher to a center.

    tblStudents: People names should be broken out into their components, at least First and Last. Class should not be in this table as it can be derived from other tables. Don't store Age, store date of birth and calculate Age. Remove the father, mother, brother and sister fields. Add a table for family members:

    tblFamilyMembers

    FamilyMemberID (PK Autonumber), StudentID (FK), MemberTypeID (FK), MemberFirst, MemberLast

    also

    tluMemberType: MemberTypeID (PK Autonumber), MemberType (Mother, Father, brother, sister etc.

    tblStudentProgress, is almost all wrong. It should be:

    StudentProgessID (PK Autonumber), StudentID (FK) CourseID (FK), Grade, GradeDate

    tblCourse: CourseID (PK Autonumber), CourseName

    With a structure like that you should be able to create a report card report.

    By the way, this is a homework assignment, correct?

    Was this answer helpful?

    0 comments
  4. Anonymous
    2016-11-08T12:52:54+00:00

    Was this answer helpful?

    0 comments
  5. ScottGem 68,840 Reputation points Volunteer Moderator
    2016-11-08T12:28:53+00:00

    Before you start designing forms you need to get your table structure correct. For us to help we need to see the table structure. Please provide a look at your tables and fields.

    Was this answer helpful?

    0 comments