What’s actually slowing this PC down?
Pick the symptom - the matching free tool is one click away.
To create a Microsoft Access report, choose a table or query as the report’s record source, then use Create > Report Wizard when you need deliberate field selection, grouping, sorting, totals or layout choices. Access builds the report, opens it in Print Preview, and lets you refine it in Layout or Design view before printing or exporting a fixed-layout PDF.
What an Access report is—and why the record source matters
An Access report is a formatted presentation of data from a table or query, plus design information such as labels, headings and graphics. The table or query that supplies the data is the report’s record source. Choosing it deliberately is the most important preparation step because every field, group, sort and calculation in the report depends on what that source returns.
As an Amazon Associate I earn from qualifying purchases.
Use a table as the source when all required fields belong to one table and its rows already represent the records you want to display. Use a query when the report needs fields from related tables, filtering, calculated fields or a specific join between tables. Build and test that query first; then select it when creating the report. A report cannot select fields that its record source does not expose.
Choose the fastest route: Report tool or Report Wizard
| Approach | Path | Best for | Trade-off |
|---|---|---|---|
| Report tool | Select a table or query in the Navigation Pane, then choose Create > Report. | A quick tabular draft when you already know which source to use. | Fastest start, but less control over field selection, grouping, sorting and summaries during creation. |
| Report Wizard | Select a table or query, then choose Create > Report Wizard. | A report that needs selected fields, related sources, grouped records, sort order or totals. | Takes longer because Access asks a series of design questions, but gives a controlled first draft. |
The Report tool is useful for seeing data immediately. The Wizard is usually the better starting point for a report that other people will read or that must be regenerated consistently. Microsoft describes the Wizard as a sequence of questions that creates a report from your answers.
#1 Best Overall
Create a report with the Access Report Wizard
1. Prepare and select the record source
- Open the database and locate the required table or query in the Navigation Pane.
- If the fields are distributed across related tables, create or select a query that includes those fields and the required relationships.
- With the source selected, choose Create > Report Wizard.
Starting from the correct source prevents a common failure: creating a visually attractive report and then discovering that a needed customer, date, amount or category field is unavailable. If the source needs a filter or calculation, make that change in the query rather than trying to reconstruct it in the report.
2. Move fields into the report
The Wizard displays Available Fields and Selected Fields. Choose the source, move the fields you need from Available Fields to Selected Fields, and repeat the selection for another related table or query when the Wizard offers that option.
Put fields in an order that makes sense for the reader. For a transaction list, that might be date, customer, description and amount. For a directory, it might be department, person and contact information. The Wizard’s field order becomes the starting arrangement, although you can change it later.
3. Add grouping levels
Grouping places related records together and can make a long report understandable. Microsoft notes that information is often easier to understand when divided into groups. In the Wizard, choose a field to group by and add additional levels when the report needs a hierarchy, such as department followed by employee or year followed by month.
Date fields support several intervals: the actual date value, year, quarter, month, week, day, hour or minute. Select the interval that matches the question the report answers. A yearly management report generally needs year or quarter; a daily operations report may need day or the full date. Text fields can be grouped by their complete value or by initial characters. Numeric fields can be grouped into ranges.
Rank #2
- The Microsoft Office 365 Bible: The Most Updated and Complete Guide to Excel, Word, PowerPoint, Outlook, OneNote, OneDrive, Teams, Access, and Publisher from Beginners to Advanced
- ABIS BOOK
Grouping is nested, so the order matters. The first grouping level is the outer section; the next level appears inside it. Avoid adding a level merely because it is available: each additional group creates headings and section breaks that can make a short report harder to scan.
4. Set sort order
After grouping, choose how records should be ordered inside each group. The Report Wizard supports up to four sort fields, each in ascending or descending order. For example, a grouped sales report could sort by transaction date ascending and then by amount descending.
Recommended Free Tools
Use a stable, reader-friendly order. A date field is usually more useful than an internal ID, while a name or category can make a directory easier to scan. If you choose several sort fields, place the most important distinction first because later fields only break ties created by earlier ones.
5. Add summaries when numbers need to be interpreted
When the report contains numeric detail fields, open Summary Options to add calculations. Access can calculate Sum, Avg, Min or Max. Choose whether to show each detail record together with the summary or produce a summary-only report.
Detail plus summary is appropriate when readers must audit individual records and see the total. Summary-only is better when the decision depends on totals by group rather than every underlying row. Check that the selected numeric field has the correct meaning before adding a calculation: a sum of quantities is meaningful, while a sum of an identifier usually is not.
6. Choose the report layout and orientation
The Wizard asks for a layout and page orientation. Choose the arrangement that fits the number and width of fields. A wide report may need landscape orientation; a narrow list may fit portrait. The goal is not to fit every available field onto one page, but to keep labels, values and group boundaries readable.
Finish the Wizard and Access creates the report. It opens the result in Print Preview so you can inspect the actual pages rather than relying only on the design surface.
Refine the report after the Wizard finishes
Use Layout view for data-guided changes
Layout view displays live data while you adjust the report. Resize columns, move fields, change their alignment and add grouping levels or totals while seeing how real values affect the page. You can also drag fields from the Field List into the report.
This view is particularly useful when values have uneven lengths. A heading that looked adequate with short sample text may wrap when a real customer name or description appears. Resize the control until the longest expected values remain legible without creating excessive empty space.
Use Design view for exact control
Design view provides deeper control over report sections and controls. Use it when you need precise changes to the Report Header, Page Header, group headers, detail section, group footers, Page Footer or Report Footer, or when controls must be positioned more exactly than Layout view allows.
Access control layouts help align labels and data in rows and columns. Keep related labels and controls aligned, and make sure a control belongs to the correct section. A field placed in a page header, for example, repeats by page rather than once per record; a field in a group footer is suited to a group total.
Match sections to the information hierarchy
- Report Header: title, date range or introductory material shown at the beginning of the report.
- Page Header: column labels or other information repeated on each page.
- Group Header: the current department, year, customer or other grouping value.
- Detail: one row of the report’s underlying records.
- Group Footer: totals or notes for the current group.
- Page Footer: page-level information such as a page number.
- Report Footer: final totals or closing information for the entire report.
These sections are structural choices, not cosmetic decoration. Putting a value in the section that matches its repetition level avoids duplicated titles, missing group labels and totals that appear in the wrong place.
Preview, check and correct the pages
Print Preview is the point at which a report becomes a deliverable. Check every page for clipped controls, unexpected blank pages, wrapped headings, orphaned group labels and totals separated from the records they describe.
- Confirm that all required columns are visible and that the page orientation suits the report width.
- Check that group headings are clear and that each total belongs to the intended group.
- Look for records split awkwardly across pages and adjust control widths or section spacing when necessary.
- Verify that sorting is still correct after adding or changing groups.
- Preview with realistic data, including long names, empty values and unusually large numbers.
If the report is too wide, first remove fields that do not answer the reader’s question or move supporting detail to a separate report. Then reduce unnecessary spacing and adjust control widths. Do not make the text so small that the report technically fits but becomes difficult to read.
Export an Access report to PDF
When the recipient needs to view or print the report without editing the Access object, export it to PDF from Print Preview or the report’s export commands. Microsoft recommends PDF when preserving the report’s original layout and formatting matters. The PDF captures the paginated appearance, so the page-fit checks you perform in Print Preview directly affect the shared file.
- Open the completed report in Print Preview.
- Check page breaks, orientation, margins, headings and totals.
- Choose the export option and select PDF as the output format.
- Choose a file name and location, then complete the export.
- Open the resulting PDF and inspect several pages, including a page with a group break and the final page.
Keep the editable Access report when the data or design will change. Share the PDF when recipients need a consistent, read-only representation for viewing or printing. If recipients need to filter records or update the design, send the Access database or an appropriate exported data format instead of relying on a fixed PDF.
Independent reader supportYour contribution helps us test, update, and keep practical guides available for everyone.Report tool versus Wizard, detail versus summary, and layout versus design
| Decision | Choose the first option when… | Choose the second option when… |
|---|---|---|
| Report tool or Report Wizard | You need a quick draft from one table or query. | You need controlled field selection, grouping, sorting, summaries or related sources. |
| Detail or summary | Readers must inspect each underlying record. | Readers need totals, averages, minimums or maximums by group or for the whole report. |
| Layout view or Design view | You want to adjust columns and fields while viewing live data. | You need exact section and control placement. |
| Access object or PDF | Recipients need an editable, interactive report design. | Recipients need a fixed layout for viewing or printing. |
Common problems and practical fixes
A required field is missing
Check the record source first. If the field belongs to another related table, revise or create a query that returns it, verify the relationship, save the query, and restart the report from that query.
Grouping produces too many sections
Review the grouping interval. Grouping by the complete date or a complete text value can create one section per record. For dates, choose year, quarter, month, week or day as appropriate. For text, consider grouping by initial characters when a full-value group is too granular.
Do these 3 things before closing this tab:
1Clear out junk files and repair common Windows errors2Fix the driver behind crashes, sound loss and screen glitches3Repair Windows errors before they cause bigger problemsA total is wrong or meaningless
Confirm that the calculation is applied to the intended numeric detail field and that the group level is correct. Use Sum for additive quantities, Avg for a meaningful average, and Min or Max when the extreme value is what readers need. If the underlying query duplicates rows because of a relationship, fix the query before trusting the report total.
The report is difficult to read in Print Preview
Use Layout view to resize controls and Design view to correct section placement. Reconsider orientation, remove nonessential columns and keep repeated labels in the Page Header. Preview again after each structural change.
The PDF does not look like the design
Export from the finished report’s Print Preview rather than from an unfinished design. Inspect the PDF itself for page breaks, clipping and blank pages. A PDF preserves the paginated layout; it does not repair a report that was already too wide or poorly sectioned.
Access report dimensions and a current product limit
Microsoft’s current introduction documentation states that, beginning with Access for Microsoft 365 Version 2609 (build 16.0.20430.20146), a report can be up to 2,000 inches (5,080 cm) wide and each report section can be up to 2,000 inches tall. Those are maximum design dimensions, not a recommendation for everyday layouts. Normal business reports should remain close to the page size and orientation chosen for their readers.
The Tool Desk
Outbyte Driver Updater FREEFix the driver behind crashes, sound loss and screen glitchesFind Drivers →Outbyte PC Repair FREEClear out junk files and repair common Windows errorsFree Scan →A repeatable creation checklist
- Define the reader’s question and decide whether detail, grouped totals or both are required.
- Choose a table or build a query as the record source.
- Start with Create > Report Wizard when the report needs controlled structure.
- Select only the fields needed for the decision the report supports.
- Add nested groups and the correct date, text or numeric interval.
- Set up to four sort fields in the order readers should scan them.
- Choose Sum, Avg, Min or Max only where the calculation has a clear meaning.
- Use Layout view for live-data adjustments and Design view for exact section changes.
- Inspect realistic records in Print Preview.
- Export to PDF when a fixed appearance for viewing or printing is the goal.
This sequence separates data preparation, report logic, visual design and distribution. That makes errors easier to locate: missing fields usually belong to the record source, incorrect totals to grouping or query logic, and page problems to layout or section design.
Quick Recap
Product prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on Amazon at the time of purchase will apply.
