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
    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
  2. 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
  3. 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
  4. 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
  5. Anonymous
    2016-12-15T06:11:20+00:00

    Hi Scott,

    Hope you had a great vacation. I definitely need some help on this application. I was away myself for a couple of weeks but now I'm back. Since the time I came back I worked on the application and tried to understand why its not working as it should. I downloaded a fresh copy of it from your OneDrive. If you look at the second Sub form, the StudentProgress, immediately after you choose a Center from the drop down, you find names of students repeated 8 times instead of just 4. I dont know where to begin to correct this. Plus, there is really no point in having Combo boxes on the sub form when that feature is not usable and the user is not allowed to select anything other than enter marks of the student.

    Please give me a start on how I should go about solving this problem?

    Thanks.

    Was this answer helpful?

    0 comments