Create a Separate Microsoft Access Report Page for Each Student
Question details
Create a report that includes all students and prints each student's details on a separate page.
- Product
- Microsoft Access
- Device & OS
- not provided
- Scenario
- Generate individual student report pages from a database containing student information and related details.
- Observed behavior
- A report may show only one student if its record source or filters limit the data. The desired result is a report grouped by Student ID with separate pages for each student.
Identify the unique Student ID field and the tables containing the details you want to print. Check that the source query returns all intended students rather than filtering to a single student.
Build a student query and create a grouped report with page breaks
Use one report to print all students, with each student's records grouped together and starting on a separate page.
Grouping by Student ID keeps records for the same student together. The Keep Together setting helps prevent a group from splitting, but it does not create a separate page for every student; configure a page break as well.
In Access, select Create > Query Design. Add the tables containing student information and related records, confirm their joins, and add Student ID plus every field needed in the report.
Select Run on the Query Design tab and check that the results include all intended students. Remove any Criteria that restrict Student ID to one student, then save the query with a descriptive name such as StudentReportData.
Select Create > Report Wizard. Choose the saved query under Tables/Queries, move the required fields into Selected Fields, and add Student ID as a grouping level. Complete the wizard and save the report.
Open the report in Design View and select Design > Group & Sort. Confirm that Student ID is the group field. Expand More for that group and enable a group header if one is not already present. Place student-level details in the group header and repeated items, such as course results, in the Detail section.
In Group, Sort, and Total, expand More for the Student ID group and select Keep whole group together on one page. This keeps a student's details on one page when the group is small enough to fit.
In Design View, select the Student ID group header section and press F4 to open the Property Sheet. On the Format tab, set Force New Page to Before Section so each student's group starts on a new page.
Open the report in Print Preview and check the student names, page breaks, and detail records. When the layout is correct, select File > Print > Print and choose All in the print range to print the full report.
Review Exported Student Report Data in WPS Spreadsheet
WPS Office is a free, lightweight, easy-to-use alternative for working with student data exported from Access to Excel. Its familiar spreadsheet interface and Excel format compatibility make migration straightforward. WPS does not replace Access database reporting or open Access database files directly; create the grouped report in Access and use WPS for exported data review.

Frequently Asked Questions
Why does my Access report show only one student?
Open the report in Design View, select the report itself, and press F4. On the Data tab, check Record Source, Filter, and Filter On Load. Open the source query to confirm that it returns multiple students, and remove any query criteria or report filters that unintentionally restrict the results.
Does Keep Together automatically put every student on a separate page?
No. Keep Together helps prevent a student's group from splitting across pages when it fits on one page. To start each student on a separate page, select the Student ID group header in Design View and set Property Sheet > Format > Force New Page to Before Section.
Should I group the report by student name or Student ID?
Use Student ID if it uniquely identifies each student. Names can be duplicated or changed. In Design > Group & Sort, add a group on Student ID and display the student's name in the group header.
Can I print all student reports in one operation?
Yes. A report grouped by Student ID can include all students in one print job. Open it in Print Preview, check the page breaks, and select File > Print > Print with the print range set to All. Separate PDF files for each student require an additional filtered export process.
Can WPS Office create these reports directly from an Access database?
WPS Office does not provide an Access-equivalent database report designer or directly open .accdb databases. In Access, select the student table or query and use External Data > Excel to export it. Open the resulting Excel file in WPS Spreadsheet to review, sort, or format the student data.




