A class project: an Excel VBA tool that pulls student records from MS Access, computes grade statistics, and auto-generates a formatted Word report with a chart.
the problem
A class assignment: automate turning raw student records into a polished, readable grade report without manually copying numbers between programs.
the approach
Wrote VBA macros in Excel that connect to an MS Access database, pull student records, and compute grade statistics directly in the spreadsheet. A second macro drives Word's object model from within VBA to auto-generate a formatted report, complete with a chart.
how it happened
Connected Excel to an MS Access database via VBA to pull raw student records
Computed grade statistics with macros directly in the spreadsheet
Used VBA to drive Word's object model, generating a formatted report document from the computed data
Added an auto-generated chart to the Word report to visualize the grade distribution
built with
next up