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: Oldest
Most helpful Newest Oldest
  1. ScottGem 68,840 Reputation points Volunteer Moderator
    2017-01-02T14:48:31+00:00

    Either upload your current version or show me the SQL.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2017-01-02T15:18:42+00:00

    Here's the SQL of the first select query:

    SELECT tblStudentProgress.CenterCode, tblStudentProgress.StudentID, tblStudentProgress.GradeScore, tblCourse.CourseName

    FROM tblCourse INNER JOIN tblStudentProgress ON tblCourse.CourseID = tblStudentProgress.CourseID

    WHERE (((tblStudentProgress.CenterCode)=[Forms]![Production_CenterDetails_Main_Form]![Combo15]) AND ((tblStudentProgress.GradeMonth)=[Forms]![Production_CenterDetails_Main_Form]![Text37]))

    ORDER BY tblStudentProgress.StudentID;

    And here's the SQL of the second crosstab query:

    TRANSFORM Count(qryStudentProgress_FIRST_SIMPLE_QUERY.GradeScore) AS CountOfGradeScore

    SELECT qryStudentProgress_FIRST_SIMPLE_QUERY.CenterCode, qryStudentProgress_FIRST_SIMPLE_QUERY.StudentID, Count(qryStudentProgress_FIRST_SIMPLE_QUERY.GradeScore) AS [Total Of GradeScore]

    FROM qryStudentProgress_FIRST_SIMPLE_QUERY

    GROUP BY qryStudentProgress_FIRST_SIMPLE_QUERY.CenterCode, qryStudentProgress_FIRST_SIMPLE_QUERY.StudentID

    PIVOT qryStudentProgress_FIRST_SIMPLE_QUERY.CourseName;

    The database is too huge to send, hence I've shown the SQL above for both the queries.

    Was this answer helpful?

    0 comments
  3. ScottGem 68,840 Reputation points Volunteer Moderator
    2017-01-02T16:25:17+00:00

    Ok how are you trying to run the queries?

    Was this answer helpful?

    0 comments
  4. Anonymous
    2017-01-03T02:41:36+00:00

    Okay, I open the main form and select the Centercode from the combo box then enter a month in the month text box and press the button next to the month for it to fill the text boxes below with the name of the month. Then enter the marks of the students and press the generate report button. Pressing the generate report button gives me this error:

    Both the queries are open as seen. Even if I don't open the queries, and press generate report button, it gives the same error.

    Was this answer helpful?

    0 comments
  5. ScottGem 68,840 Reputation points Volunteer Moderator
    2017-01-03T03:23:46+00:00

    OK, what is the Recordsource for the report? What is the code behind the generate report button?

    There should be no need to open the queries.

    Was this answer helpful?

    0 comments