This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
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
A family of Microsoft relational database management systems designed for ease of use.
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.
I would go with a form that requires minimum amount of coding, though I am not allergic to coding if that is really required to make this happen.
Thank you.
I did design the forms the way you instructed in the first place, but was having trouble filtering the students according to the CenterCode so I took it apart and just to show you I designed the one in the screenshot. If this is hard enough, then, do I have to revert back to the one you have instructed? Will I be able to enter the marks of each student per center for each month of the year? I'm ready to do that too if I can link the combo box to filter the form according to the CenterCode.
Okay Scott, I'll have to work closely along with you on this. First of all you tell me how best you would have this designed if you were in my place? I just need to make this form simple and intuitive enough for the data entry person, so she never runs into any problems.
The basic question is then, how would someone feed the marks of the student into their courses each month?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(89.60000000000001, 51%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
First, I'm not following what you did, its not what I instructed. Second, The subform you show in the screenshot is not in keeping with the structure we have discussed. Having columns for each course is not proper normalized design.
If you want to use an interface like that, you will have to use unbound forms hihc will require a significant amount of coding.
Hi Scott,
I made the main form using the form wizard and then put a combo box on the main form to filter records. Then I made use of the form wizard a second time for the sub form but could not filter the records from the sub form. Then I deleted the sub form and dragged tblStudents onto the main form and added fields from other 2 tables wiz. tblCourse and tblStudentsProgress onto the subform. I've attached a screenshot of the way I wanted the design of the form to be. When I select the CenterCode from the combo box, I want the sub form to display student names along with their courses in the sub form. This is the way I would like the application to work. But I just can't get the combo box to filter the records programmatically.
Here's the screenshot:
Please help me to design it this way.
Thank you.