Home Tutorials Videos Q&A MCQ Shortcuts Exercises Appointment Login
Lesson 41 of 50 – Printing Reports in MS Access
82%

Printing Reports in MS Access

Printing reports in Microsoft Access allows you to produce paper copies of database information. Before printing, you can check the page layout, adjust margins, select page orientation, choose a printer, and review the report in Print Preview.

1. What Is Report Printing?

Report printing is the process of sending a database report to a printer or another supported output device. Reports are commonly used for official records, summaries, and business documents.

Examples of Printed Reports
  • Student admission lists
  • Monthly fee collection reports
  • Employee attendance reports
  • Sales and purchase reports
  • Stock and inventory reports
  • Examination result reports
Remember: A report can be viewed on screen before printing. Always review its layout to reduce printing errors and wasted paper.

2. Opening a Report

Before printing, open the report you want to print.

Steps
  1. Open Microsoft Access.
  2. Open your database file.
  3. Find the required report in the Navigation Pane.
  4. Double-click the report to open it.
  5. Review the report data.

You can also right-click a report in the Navigation Pane and select an appropriate view.

Example Report Names
  • rptStudentDetails
  • rptFeeCollection
  • rptEmployeeAttendance
  • rptSalesSummary

3. Using Print Preview

Print Preview shows how a report is likely to appear on printed pages. It helps you identify layout problems before sending the report to the printer.

Steps to Open Print Preview
  1. Open the report.
  2. Right-click the report in the Navigation Pane if necessary.
  3. Select Print Preview.
  4. Review the pages and report content.
  5. Check that all required columns are visible.
What Should You Check?
  • Report title and headings
  • Page breaks
  • Column widths
  • Text size and readability
  • Margins and page orientation
  • Unnecessary blank pages
Tip: If the report is too wide, consider reducing column widths or using Landscape orientation.

4. Printing a Report Using Ctrl + P

The keyboard shortcut Ctrl + P opens the print interface in many Microsoft Access versions.

Steps
  1. Open the required report.
  2. Press Ctrl + P.
  3. Review the available print options.
  4. Select the printer.
  5. Choose the required print settings.
  6. Click Print.

Depending on your Access version and current view, the print interface and available commands may vary.

Shortcut: Ctrl + P is a quick way to access printing options.

5. Selecting a Printer

Before printing, select the printer or output device you want to use.

Steps
  1. Open Print Preview or the print interface.
  2. Open the printer selection list.
  3. Select the required printer.
  4. Check the printer status and settings.
  5. Confirm the number of copies.
  6. Start printing when ready.
Common Output Options
  • Physical Printer: Produces a paper copy.
  • Microsoft Print to PDF: Creates a PDF file on supported Windows systems.
  • Other PDF Printer: Creates a PDF using an installed PDF printer.

Available printers depend on your operating system and installed devices.

6. Setting Page Orientation

Page orientation determines whether a printed page is taller or wider.

Orientation Description Suitable For
Portrait Page is taller than it is wide. Student lists and reports with fewer columns.
Landscape Page is wider than it is tall. Reports containing many columns.
Steps
  1. Open the report in Print Preview.
  2. Locate the Page Setup or page orientation option.
  3. Select Portrait or Landscape.
  4. Review the updated page layout.
  5. Print when the layout is correct.

7. Setting Page Margins

Margins are the blank spaces around the edges of a printed page. Proper margins help prevent content from being cut off.

Common Margin Options
  • Normal: Uses standard margins.
  • Narrow: Provides more printable space where supported.
  • Custom: Lets you specify margins where available.
Steps
  1. Open Print Preview.
  2. Open the Page Setup options.
  3. Choose the available margin setting.
  4. Review the report's printable area.
  5. Adjust the layout if content is clipped.
Tip: Very narrow margins may not be supported by every printer. Check the printer's printable area before printing.

8. Printing Specific Pages

Sometimes you need to print only selected pages rather than the complete report.

Common Print Range Options
  • All Pages: Prints the entire report.
  • Current Page: Prints the page currently displayed, when supported.
  • Selected Page Range: Prints a specified range of pages.
Example

Suppose a report contains 20 pages, but you only need pages 3 through 5.

  1. Open the print interface.
  2. Choose the page range option if available.
  3. Enter page 3 as the starting page.
  4. Enter page 5 as the ending page.
  5. Check the print preview or settings.
  6. Print the selected pages.
The exact page-range controls depend on the print interface and Access version.

9. Choosing Copies and Collation

Print settings allow you to choose how many copies to produce and how pages are arranged.

Number of Copies

The Copies setting determines how many copies of the report you want to print.

Collated Printing

When printing multiple copies of a multi-page report, collation determines whether each copy is printed as a complete set before the next copy begins.

Example

If a report contains three pages and you need two copies, collated printing generally produces: 

Copy 1: Page 1, Page 2, Page 3
Copy 2: Page 1, Page 2, Page 3

The exact options available depend on the selected printer and driver.

10. Saving a Report as PDF

Saving a report as a PDF allows you to share or archive a fixed-layout document without immediately printing it on paper.

Method 1: Export to PDF
  1. Select the report in the Navigation Pane.
  2. Open the External Data tab.
  3. Find the export options and choose PDF or XPS, where available.
  4. Choose the destination folder.
  5. Enter a file name.
  6. Choose any available export options.
  7. Complete the export.
Method 2: Print to PDF
  1. Open the report's print interface.
  2. Select Microsoft Print to PDF or another installed PDF printer.
  3. Choose the required print settings.
  4. Click Print.
  5. Select a folder and file name when prompted.
  6. Save the PDF.
Benefit: A PDF can be shared by email or stored digitally without requiring a paper copy.

11. Common Printing Problems

Problem 1: Columns Are Cut Off

Solution: Reduce column widths, adjust margins, or use Landscape orientation.

Problem 2: Text Is Too Small

Solution: Increase font size where appropriate and adjust the report layout.

Problem 3: Blank Pages Appear

Solution: Check report width, page breaks, margins, and section sizes.

Problem 4: The Printer Is Not Available

Solution: Check the printer connection, driver, power, and operating system printer settings.

Problem 5: The Report Does Not Fit on One Page

Solution: Review the number of columns, paper size, orientation, and page setup options.

Problem 6: The PDF Is Saved in the Wrong Location

Solution: Check the destination folder and file name before completing the export or save operation.

12. Practical Assignment

Create, preview, and print a student fee report.

Required Fields
  • StudentID
  • StudentName
  • Course
  • FeePaid
Tasks
  1. Create a report named rptStudentFeeReport.
  2. Display the student and fee information.
  3. Add a suitable report title.
  4. Preview the report before printing.
  5. Choose an appropriate page orientation.
  6. Check margins and column widths.
  7. Print a test copy if a printer is available.
  8. Export the report to PDF.
  9. Open the PDF and verify its contents.
Goal: Produce a readable printed report and a PDF copy suitable for digital sharing.

13. Revision Questions

  1. What is report printing in MS Access?
  2. What is the purpose of Print Preview?
  3. Which shortcut opens printing options in many Access versions?
  4. What is the difference between Portrait and Landscape orientation?
  5. What are page margins?
  6. How can you print selected pages?
  7. What does the Copies setting control?
  8. What is collated printing?
  9. How can you save an Access report as a PDF?
  10. What should you check if report columns are cut off?

🧠 Quick Quiz

1. Which view helps you check a report before printing?



2. Which orientation is useful for a report with many columns?



3. Which output format is useful for sharing a fixed-layout report digitally?



← Previous Next →