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
    2017-01-02T03:25:01+00:00

    The form has to be open for the the form reference to be recognized.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2017-01-02T02:48:31+00:00

    I'm afraid, this isn't working. Apparently, it doesn't like using the [Forms]![Formname]![CenterCode] stuff in the crosstab. I created the first query and that worked exactly as you described, each student having 4 records for the 4 subjects. Then created another query, the crosstab using this first simple select query as the source. As soon as I ran the query, the following error message popped up:

    The error message says, " The MS Access database engine does not recognize 'Forms!Formname!Combo15 as a valid field name or expression." I tried removing the filter in the first query, but then that would mean using a query without any filters.

    Now, what should I do?

    Was this answer helpful?

    0 comments
  3. ScottGem 68,840 Reputation points Volunteer Moderator
    2017-01-02T02:45:04+00:00

    Yes, that's what I explained previously.

    Was this answer helpful?

    0 comments
  4. Anonymous
    2017-01-02T02:12:00+00:00

    Okay, I get it. So, now I will begin to create the first query that filters for the records that I need and then if everything works exactly as I want, use the first query as the source for the second, which would be the crosstab query. And then finally use the crosstab to make other adjustments by enhancing the query with the percentage of marks and whatever I need and create a third query that gives the final result. Then use the final query as source for the report. Right? Is this what you mean?

    Was this answer helpful?

    0 comments
  5. ScottGem 68,840 Reputation points Volunteer Moderator
    2017-01-01T17:03:20+00:00

    Yes I did, but I also told you to create a query that filters for the records you want and then use that as the source for the crosstab.

    This is a concept I call "interim" queries. Sometimes you need to build several queries to get to the final result set that you need. I also told you, that you need to work through this progression of queries to determine where the problems lie. If you determine that the Crosstab is producing duplicate rows, then you need to do something to filter the rows before you use a crosstab.

    So there is no reversal here. There is simply analyzing the queries and making adjustments to get the result set you want.

    Was this answer helpful?

    0 comments