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-10T21:00:58+00:00

    OK, I was able to reporduce the error so I changed the code behind the Generate Report button to:

    Private Sub Command41_Click()

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

    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; "

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

                    "SELECT tblStudentProgress.CenterCode, tblStudentProgress.StudentID, tblStudentProgress.GradeScore, tblCourse.CourseName " & _

                    "FROM tblCourse INNER JOIN tblStudentProgress ON tblCourse.CourseID = tblStudentProgress.CourseID " & _

                    "WHERE tblStudentProgress.CenterCode = " & Me.CenterCode & " And tblStudentProgress.GradeMonth = '" & _

                    Me.Text37 & "' " & _

                    "ORDER BY tblStudentProgress.StudentID;"

    '        Debug.Print strSQL

            CurrentDb.Execute strSQL, dbFailOnError

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

    End Sub

    Copy and paste that into the code module. 

    This worked for me.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2017-01-12T16:08:24+00:00

    Now its working for me. As soon as I got rid of the old code, and put this one instead, it worked. All I have to do now is add the percentage. I'll work on the percentage part, meanwhile please let me know what was wrong with the previous code and why was it behaving the way it was?

    Was this answer helpful?

    0 comments
  3. ScottGem 68,840 Reputation points Volunteer Moderator
    2017-01-12T16:29:05+00:00

    That's just it, I don't know why the original code didn't work. It worked for me the first time I tried it. And I can see no reason why it shouldn't work.

    But there is more than one way to skin a cat. So the code I gave you just approaches the same result but by a different path.

    Was this answer helpful?

    0 comments
  4. Anonymous
    2017-01-12T16:44:50+00:00

    Scott,

    I will work on the percentage tomorrow and the coming days and if I get stuck somewhere I'll need your help. So thanks once again for all the help.

    Was this answer helpful?

    0 comments