Practical lesson
In this practical lesson a complete piece of work is made from the “Students” table (StudentID, FullName, Class, Mark). First build the table with 8 invented records; do not enter real names or phone numbers. Then create a form with Form Wizard, enter three new records in it and use Find to locate a given name. Next create a report in Report Wizard: group by Class and sort Mark in descending order. Check the page in Print Preview and save the report as a PDF file with External Data – PDF or XPS: this saves paper and the file opens the same on any device. At the end check the sum and the mean of Mark in the table with the Totals row.
For an open day the pupil council wants to print a list of helpers sorted by class. Before printing they looked at the page preview, noticed that the last column spilled onto a second sheet, and made the layout narrower. The list fitted on one page.
Office staff, accountants and event organisers look over a report before printing it and save paper and time.
Write 5 invented names sorted by class on one sheet and leave margins on the left and right: this is a simple model of a print page.
“Checking the result”: a pair finds the sum with Totals in the table, compares it with the total in the report and looks for the reason if there is a difference.