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
    2017-01-09T06:10:31+00:00

    Here's the SQL of the qryStudentProgress_FIRST_SIMPLE_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;

    I tested the query and it was working normally. Yet I don't understand the reason for the error. If everything is working individually, taking apart the queries, it should work for the generate report button.

    Was this answer helpful?

    0 comments
  2. ScottGem 68,840 Reputation points Volunteer Moderator
    2017-01-09T02:49:15+00:00

    I don't understand it because Ii see no error in the code nor do I see any reason for it.

    What is the SQL for qryStudentProgress_FIRST_SIMPLE_QUERY?

    Was this answer helpful?

    0 comments
  3. Anonymous
    2017-01-09T02:17:36+00:00

    Here's the code behind the generate report button:

    Private Sub Command41_Click()

    Dim strSQL As String

             strSQL = "DELETE * FROM tmpProgress;"

                      CurrentDb.Execute strSQL, dbFailOnError

             strSQL = "INSERT INTO tmpProgress (CenterCode, StudentID, GradeScore, CourseName) " & _

                             "SELECT CenterCode, StudentID, GradeScore, CourseName " & _

                             "FROM qryStudentProgress_FIRST_SIMPLE_QUERY; "

                    CurrentDb.Execute strSQL, dbFailOnError

             DoCmd.OpenReport "frmSimpleUsingCrosstabasSource", acViewPreview, , "CenterCode= " & Me.Combo15

    End Sub

    I'm having a lot of trouble with this code behind the generate report button. If I put the Debug.Print command right before the second execute statement, the immediate window points to the strSQL statement with :

                             "INSERT INTO tmpProgress (CenterCode, StudentID, GradeScore, CourseName) " & _

                             "SELECT CenterCode, StudentID, GradeScore, CourseName " & _

                             "FROM qryStudentProgress_FIRST_SIMPLE_QUERY; "

    If I put the cursor over the dbFailOnError it looks like this:

    I fail to understand the error.

    Was this answer helpful?

    0 comments
  4. ScottGem 68,840 Reputation points Volunteer Moderator
    2017-01-08T19:32:18+00:00

    Show me the code behind the Generate Report button. I can't understand why this doesn't work for you. It works fine for me.

    Was this answer helpful?

    0 comments
  5. Anonymous
    2017-01-08T17:04:37+00:00

    Okay, now I get it, the Query1 was just used as an example while the code snippet does the deleting and inserting into the tmpProgress table. Okay, so now I wish to run the report from the main form without opening all the queries.  Just by selecting the generate report button. But once I do, it gives me this error, which should not be. It should just open the report based on the center code. Here's the error:

    I get this error repeatedly whenever I press the generate button.

    ***Personal information deleted by the moderator. Please see the Microsoft Community Frequently Asked Questions for more information on how you can protect your privacy.***

    Was this answer helpful?

    0 comments