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
    2017-01-06T17:00:35+00:00

    Frankly, I don't know what you are doing. If you RUN an Append query, nothing visible happens, you have to check the table being appended to. So here is the steps I followed and the results I got.

    1. Opened main form and selected Center Code and Month

    1. Copied the SQL statement from your previous post into a new query

    1. Clicked View to see how the query would work and got the following result 

    1. Deleted the contents of tmpProgress. Returned to Design View of Query 1 and hit Run. I then opened tmpProgress and this is what I got

    As you can see this is exactly what needed to be done. tmpProgress now has the data needed to feed the crosstab query 

    1. Ran crosstab from tmpprogress

    Again this is the expected result. I then used this query in another (as described previously) to feed the report. Again, I tested this with the last database copy you uploaded and it WORKS exactly as I said it would. 

    ***Personal information deleted by the moderator. Please see the Microsoft Community Frequently Asked Questions for more information on how you can protect your privacy.***

    Was this answer helpful?

    0 comments
  2. Anonymous
    2017-01-07T02:22:42+00:00

    This is absolutely incredible! When I did it, it gave me a lot of miseries. But now its WORKING! I'm happy in the end. It was a long way to get here and I learned a lot through this thanks to you. I appreciate the way you dealt with this and were with me throughout because you truly wanted me to accomplish the task at hand. People like me learn from masters like you. Thank you so much!

    Now, all I've got to do is get the percentages right and create a report. I'll be doing this today evening and get back to you should I have any issues.

    Anyway, I acknowledge your expertise. Thank you once again!

    Was this answer helpful?

    0 comments
  3. ScottGem 68,840 Reputation points Volunteer Moderator
    2017-01-07T03:21:44+00:00

    Glad to hear its working

    Was this answer helpful?

    0 comments
  4. Anonymous
    2017-01-08T14:41:18+00:00

    Hi,

    Scott, I don't know how to tie all this together. Though the tmpProgress table is appending records, from the intermediate append query, yet I can't figure out how to tie all this together? Do I need Query1? Where do I run this from ??? This should all work independently without me having to open Query1 all the time. If I work from the main form and select a centercode and enter a month and then click generate report button, it gives me the same error it was giving previously "To few parameters ..." Why is the generate report button not able to generate the required report?

    Was this answer helpful?

    0 comments
  5. ScottGem 68,840 Reputation points Volunteer Moderator
    2017-01-08T15:14:39+00:00

    Query 1 was just an example. Its the query that is generated in the code snippet I gave you. You really have to follow what I have told you, don't forget previous instructions.

    So, AGAIN, the Generate Report code does the following:

    1. Deletes all records from tmpProgress
    2. Appends records to tmpProgress that meet the selected criteria of CenterCode and GradeMonth.
    3. Opens the Report which is based on the second query I outlined. So you have a crosstab query based on tmpProgress as an interim query and a second query to bring in the Student name and calculate the percentage.

    This was all laid out in detail in my response on Jan 3.

    The reason for tmpProgress was because for some reason the second query that was based on the original crosstab was not working as it should. So I created the temp table as a workaround.

    Was this answer helpful?

    0 comments