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: Newest
Most helpful Newest Oldest
  1. ScottGem 68,840 Reputation points Volunteer Moderator
    2016-11-27T14:09:10+00:00

    First, I don't mind helping you, but you need to do some of this on your own. I checked, the copy I have and The Progress subform is being sorted on StudentID., All you needed to do is add CourseID to the OrderBy property.

    You need to start exploring the properties of the objects. This is how things are done in Access. Everything is an object and you get things done by manipulating the properties of the objects, either manually or programmatically. So an understanding of what properties you can change is essential.

    Was this answer helpful?

    0 comments
  2. ScottGem 68,840 Reputation points Volunteer Moderator
    2016-11-25T15:29:56+00:00

    Were you able to create the combobox for the dates? You should have been able to.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2016-11-25T15:25:46+00:00

    Hi Scott,

    Waiting for you to come back from vacationing. Hope you have a nice time.  I'm still stuck at the same place where I was the last time. Enjoy the holidays!

    Was this answer helpful?

    0 comments
  4. ScottGem 68,840 Reputation points Volunteer Moderator
    2016-11-21T02:35:39+00:00

    Hmm that's strange since the sort order was working when I last looked. It may have to wait until I return from vacation before I can look at it.

    As far as using a Combo to select the month, you should be able to do that. I would create a table for each period. Like I said, the period should include the year as well. Will there be a core for every calendar month? if not, all the more reason to use a table.

    Was this answer helpful?

    0 comments
  5. Anonymous
    2016-11-21T02:01:40+00:00

    Hi Scott,

    This works now. Thank you. But I'm having a problem with the Student names in the second sub form not being aligned with the student names in the first sub form. I tried ascending both student names in the SELECT queries on the record sources but did'nt help either. I can't understand this behavior why both the Student names are not getting aligned by their names but by their StudentID's ? That's strange. I also cannot get the Course names in the order Hindi, English, Math and Science. Here too the table shows them in ascending order of the CourseID's 1, 2, 3 and 4 but they should be in the order like I listed above.

    And can we not have a combo box for month names instead of the text box since someone can make typos for the names of the months and then it would be hard to pickup all the students belonging to that particular month in the report which follows after all this mess is sorted out?

    Was this answer helpful?

    0 comments