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.
![](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)
This should not be difficult. Use the form wizard to create a main form, Use the Combobox wizard to create a "search" combo to select a Center. Use the form wizard again to create your subform as a tabular form. Finally use the Subform wizard to embed the subform on the main form.
Hi,
So I need a form to display a form by Center Code and not by StudentID. I would like to have a combo box on the mainform and then select a center by center code, so the subform displays only students belonging to that particular center and then just type in the marks into the courses.
I'm finding it extremely difficult to do this. Can you please help me?
Or if you know of a better way how to enter marks of each student for a particular month, please help me design the form.
Thank you.
Part of this is your choice. I can things being done two ways. Either by Course/Center or by Student.
So you create a main form. that mainform will either be bound to the Student or the Course/Center. You then have a subform bound to the Progress table. Depending on what the main form is bound to this will be linked on the appropriate key field.
The subform will be in continuous form mode so you would add a record in the subform for each grade.
Hi Scott,
I've got all the tables set up and I now need your help to design a form for entering students marks in their courses. Please guide me through the steps.
Thank you.
Access is a relational database. Data needs to be stored so it follows the relational model. Don't confuse data storage with presentation.
What manual labor are you referring to? You have to enter the data, and you need to enter the data in properly designed tables. Once the data is entered. Then you can easily produce a report with the click of a button. Using the methods I described.