Report card from excel list to access

[jcastroalfar]

Hello Guys.

Maybe somebody can help me here. I work for a school, I have an excel sheet that contains columns with a list of students and their grades for several courses, I need to create a report card with that information...every student has their own ID which is repeated cell by cell depending the numbers of subjects that the student is taking.

Does someone have an idea of what can I do and if is possible to do this is MS Access?

Thanks in advance.

[ADezii]

Exactly what information are you looking for on this Report Card, something similar to?

Name            Course    Course Name    Score    Grade
SMITH, John      543      Biology          97        A+
 

P.S. - Other Courses & related info depicted accordingly.

[jcastroalfar]

Thanks for your help ADezii. I need something similar to the attached report card.

[ADezii]

The idea is to:

1. Link the Excel Spreadsheet.
2. Create a Report using the Report Wizard, selecting the Spreadsheet as the Data Source for the Report.
3. Select the Fields that you want displayed on the Report.
4. When prompted, Group by Student Name ascending.
5. Set the Format of the Report to Tabular.
6. This will give you a Report Template for which you must modify.
7. Place the basic information into the Form Header and Filter for a single Student if necessary.