Does Printing a Report in Access Run the Query Again

Set print options in Access

Admission for Microsoft 365 Admission 2021 Access 2019 Admission 2016 Access 2013 Access 2010 Access 2007 More than...Less

While you lot can print data from a tabular array, query, grade or written report in your Microsoft Access database, you lot tin set impress options for reports that will produce an eye-catching and more readable printed re-create of your data.

Printing data straight from tables or queries works when you want to print just a simple list. Forms are amend suited for viewing or printing data for a single record or a related gear up of records, and not for printing larger sets of data or information summaries. By press data from a report, you can compare, summarize, and total large sets of data, so present that data in an attractive layout.

For more than information virtually creating a report see Introduction to reports in Admission.

In this article

• Select page setup options

• Select printer settings

• Preview before printing

Select page setup options

After y'all create your written report y'all tin can set options for the impress layout in the Page Setup dialog box. These options help you fine tune the format with options for margin settings, utilize of gridlines and columns, or print merely the data from the study without the formatting. To set up the print page options, complete the following steps:

1. In the Navigation Pane, right-click the report and and then click Impress Preview.

2. On the Impress Preview tab, in the Page Layout group, click Page Setup and set the margins, orientation and column settings that you want.

   

   Print Options tab settings

Setting	Clarification
Margins (inches)	Increase or decrease the default margins as required, and meet the changes displayed in the Sample page.
Print Data But	Select this pick when you do non want to print the layout features in the study such as grids.
Carve up Form	This option is not available for a report.

To customize the margins on your report, on the Print Preview tab, in the Page Size group, click Margins and select a suitable option and a preview of the report with the changed margin settings is displayed.

Folio tab settings

Setting	Description
Orientation	Select either the Portrait or Landscape orientation. If yous want to see how the study appears, instead of setting the orientation here gear up it from the Page Preview tab. On the Print Preview tab, in the Page Layout grouping, click Portrait or Mural.
Paper	Select the newspaper size and source.
Printer for Client Addr...	If you lot select Use Specific Printer you can set several other printer and certificate format options.

Columns tab settings

Note:These options are too available on the Print Preview tab, in the Folio Layout grouping, nether Columns.

Setting	Description
Grid Settings	Select the number of columns and row spacing. If the setting is for a single column, the Column Spacing and Column Layout options won't exist available.
Same every bit Particular	Select to impress the cavalcade in the same size as you prepare in the study. To adjust the column width and peak, clear the selection and type new values.
Column Size	Select the width and height of the columns.
Column Layout	Select the management in which y'all want the columns printed. This option is available only when you accept more than than one column.

Top of Page

Select printer settings

After you lot consummate the page setup settings for your report, yous can select specific printer options to control the print layout or the pages you want printed and the number of copies.

1. In the Navigation Pane, correct-click the written report that yous want to print, and click Print Preview.

2. On the Impress Preview tab, in the Impress group, click Print.

   Keyboard shortcut  Press Ctrl+P.

3. Select your impress options, and so click OK to print your report.

The following table describes the results you lot can look from specific printer settings:

Setting	Clarification
Printer	Select the printer where you want to accept the report printed. If you haven't set the orientation and paper size, click the Properties button.
Print Range	To impress but selected pages of the study, select Pages and set the range. For example, to print just page 5 of a written report, type v in both the From and the To boxes. To print just one page of your study, set both the From and To fields to the same page number.
Copies	Select the number of copies and select Collate if you want the copies printed in sets for a multi-page report.

To relieve paper, or to transport a print chore to a commercial printer, or transport the written report via e-mail, you lot tin create a .pdf or xps format of your report: On the Impress Preview tab, in the Data group, click PDF or XPS.

Superlative of Folio

Preview before press

Utilise the Print Preview option to brand check how the printed version of your written report will announced.

You tin open a report in Print Preview by using one of the post-obit methods:

• To preview a report that is not already open up, in the Navigation Pane, right-click the report that you want to preview, then click Print Preview.

  or

• Click File > Print, and and then click Print Preview.

  or

• If the report is open, correct-click the document tab for the report, and so click Print Preview.

Yous tin can make farther formatting changes from Print Preview by using the options in the Preview Print tab.

If you want to come across several pages of the study, motility to other pages, or view multiple pages at the same time when previewing you written report, endeavor any the following options:

• Click the Shutter Bar Open/Close push button (<<) in the upper-correct corner of the Navigation Pane, and so expand the written report view expanse.

• Position the report by using the horizontal or vertical roll bars.

• To magnify an area on the study, on the Impress Preview tab, in the Zoom grouping, click the arrow below Zoom and select a magnification percentage. You tin also employ the Zoom control in the lower right-hand corner of your window.

• To preview multiple pages at a time, in the Zoom group, click Two Pages or click More Pages and so select an pick.

Select your print options:    In the Impress group, click Impress and then select your print options.

Close Print Preview:    In the Close Preview group, click Close Print Preview.

Top of Page

Need more than help?

marshallworgird.blogspot.com

Source: https://support.microsoft.com/en-us/office/set-print-options-in-access-bc8a0421-c6b7-4a5a-a813-90273f692517

Share this post