Others

Create a Separate Microsoft Access Report Page for Each Student

Steve KSteve K Nov 13, 2026 868 views

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.
Before you start

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.

Solution 1Recommended

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.

1
Create the source query

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.

2
Verify the query results

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.

3
Create the report

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.

4
Check the grouping sections

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.

5
Keep each student's group together

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.

6
Start each student on a new page

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.

7
Preview and print all students

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.

Long student reports can span multiple pages: Keep Together cannot fit a group onto one page if its content exceeds the printable page area. Force New Page still ensures that the next student starts on a fresh page. This method creates separate student pages within one report, not separate report objects or files.
Free Microsoft Office alternative

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.

Review, sort, and filter student data exported from Microsoft Access.Supports Microsoft Excel formats, including .xlsx and .xls.Familiar spreadsheet controls make working with exported student lists easy.A lightweight Office suite for everyday spreadsheet and document tasks.
microsoft office alternative - wps office

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.