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. ScottGem 68,840 Reputation points Volunteer Moderator
    2016-12-30T16:45:43+00:00

    Lets start at the beginning. What is the source of qryStudentProgress_Crosstab? When you run just that query are the names repeated?

    Was this answer helpful?

    0 comments
  2. Anonymous
    2016-12-30T16:32:33+00:00

    Hi Scott, I tried my best to understand why the names are repeating (most repeat hundreds of times) but could not figure out the cause. I give below the SQL :

    SELECT qryStudentProgress_Crosstab.CenterCode, qryStudentProgress_Crosstab.StudentID, qryStudentProgress_Crosstab.StudentName, qryStudentProgress_Crosstab.English, qryStudentProgress_Crosstab.Hindi, qryStudentProgress_Crosstab.Math, qryStudentProgress_Crosstab.Science, (([English]+[Hindi]+[Math]+[Science])/400)*100 AS Percentage, IIf([Percentage]<33,"Fail",IIf([Percentage]=33,"Just Pass",IIf([Percentage]<60,"Fair",IIf([Percentage]=60,"First",IIf([Percentage]<75,"First",IIf([Percentage]>74,"Distinction")))))) AS Grade, tblCenterDetails.Address, tblStudentProgress.GradeMonth

    FROM (qryStudentProgress_Crosstab INNER JOIN tblCenterDetails ON qryStudentProgress_Crosstab.CenterCode = tblCenterDetails.CenterCode) INNER JOIN tblStudentProgress ON tblCenterDetails.CenterCode = tblStudentProgress.CenterCode;

    This is the SQL of the main query that supplies the report. I just cannot comprehend what's wrong here.

    Was this answer helpful?

    0 comments
  3. ScottGem 68,840 Reputation points Volunteer Moderator
    2016-12-30T12:39:08+00:00

    So you figured out that you can use the WHERE clause of the OpenReport Method to filter the records returned by a report? All you needed was "CenterCode = " & Me.CenterCode in the WHERE clause. Like I said, I could have easily told you that, but you should have been able to figure it out by looking at the various parameters you can supply in the method.

    Now for the repeating names. We discussed this previously as well. The first thing you need to do is go back to the query that is the Recordsource of the report. Run that query and see if the records are repeating there. If so, the problem is the SQL statement, not the report. So you need to examine the SQL statement and see why it may be returning multiple rows.. You can post the SQL if you need to. If its not the query (though I would doubt it), then there is something in your report design. A screen shot of the report in Design mode may help us help you.

    Was this answer helpful?

    0 comments
  4. Anonymous
    2016-12-30T06:03:18+00:00

    Okay Scott I finally got the OpenReport working with the help of an MSDN article. Now the report filters exactly based on the combo box selection. Great!

    However, I've also noticed that when the report does open, the name of each student instead of appearing once with 4 grade scores, appears multiple times in the report. Now this is something I can't seem to understand and need your help on.

    Was this answer helpful?

    0 comments
  5. ScottGem 68,840 Reputation points Volunteer Moderator
    2016-12-26T11:54:56+00:00

    Maneesh,

    I'm not going to do all your work for you. This site and sites like it are more for giving you direction than providing specific answers. Of I give you all the answers, you won't learn on your own. You need to understand how Access works and how things are done so you can do things yourself.

    I told you the answer is in the OpenReport method. Look it up and study the syntax. The answer is there.

    Was this answer helpful?

    0 comments