Create reports in Access 2016 and use advanced reporting options

The report helps you organize and present data in a user-friendly, printable format that helps share information without having to grant database access. In this article, we'll learn how to create, edit, and print reports in Access 2016 and how to use advanced reporting options.

Create report in Access 2016

Access allows you to create reports from tables and query results.

Open the table or query the data you want to use to create the report:

Create reports in Access 2016 and use advanced reporting options Picture 1

Select Create > Reports group> Report :

Create reports in Access 2016 and use advanced reporting options Picture 2

Access will create a new report based on the object you choose. Part of the data may be on the other side of the page, change the width of the columns in the report so they are on one page.

Create reports in Access 2016 and use advanced reporting options Picture 3

Click Save to save the report.

Delete field in report:

Click any box in the field you want to delete, press Delete from the keyboard.

Create reports in Access 2016 and use advanced reporting options Picture 4

Then the field will be deleted. Make sure that the title of the field is also deleted, by selecting the title> press Delete on the keyboard.

Create reports in Access 2016 and use advanced reporting options Picture 5

Print and save the report in Print Preview

To print your report to Home > View > select Print Preview from the drop-down menu, the report will appear on the printed page.

Create reports in Access 2016 and use advanced reporting options Picture 6

If necessary, edit the page size, width, rotate the page with the commands in Print Preview.

Create reports in Access 2016 and use advanced reporting options Picture 7

When finished, click Print, the print dialog box appears, adjust the printing options and click OK to print the report.

Create reports in Access 2016 and use advanced reporting options Picture 8

Save report

You can save the report in various formats such as Excel, text, PDF, HTML, etc. This is called exporting the report file. Thanks to this feature, you can view and edit the report to better suit your needs.

To export a report in Access 2016 you do the following:

In the Home > View > Print Preview tab> find the External Data group> select the file type, click More to see more options.

Create reports in Access 2016 and use advanced reporting options Picture 9

Select the folder you want to save the report> enter the name> Publish :

Create reports in Access 2016 and use advanced reporting options Picture 10

Advanced reporting options

Report Wizard:

This tool makes it easier to create reports from multiple tables and multiple queries.

In the Create tab> Reports group> Report Wizard :

Create reports in Access 2016 and use advanced reporting options Picture 11

The Report Wizard will appear.

Create reports in Access 2016 and use advanced reporting options Picture 12

Select the field you want to appear in the report> click the right arrow> click Next :

Create reports in Access 2016 and use advanced reporting options Picture 13 Create reports in Access 2016 and use advanced reporting options Picture 14 Create reports in Access 2016 and use advanced reporting options Picture 15

Presentation of the report:

If you only create a report from a table or a query, you can skip this step.

Select the option in the list to preview the report:

Create reports in Access 2016 and use advanced reporting options Picture 16

Click Next if satisfied with the presentation of the selected report. If not, you can customize group levels. Select a field from the list, then press the right arrow to add it to the new level.

Create reports in Access 2016 and use advanced reporting options Picture 17

If necessary, you can modify the order of the grouped fields, by selecting the field and clicking the nose on Priority to move it up a step or down a step. Click Next when done.

Create reports in Access 2016 and use advanced reporting options Picture 18

Sort data in reports:

Click the arrow as shown, select the name of the first field you want to sort, then select the Ascending or Descending sort on the right.

Create reports in Access 2016 and use advanced reporting options Picture 19

You can arrange up to 4 fields, the sort will be applied one by one from top to bottom, the first sort will be main. When satisfied with the layout you created, click Next .

Choose layout and report title

Click on the layout option to see what they look like, choose the one that's suitable for use.

Create reports in Access 2016 and use advanced reporting options Picture 20

Select vertical or horizontal rotation for the report.

Create reports in Access 2016 and use advanced reporting options Picture 21

When satisfied with the layout of your report, click Next , enter a title for the report, select whether you want to preview or modify its design, and then click Finish.

Create reports in Access 2016 and use advanced reporting options Picture 22

Report format

Like other applications in Office 2016, Access allows you to edit text colors, fonts, add images and more.

Edit the header and footer of the report:

To view and edit the header, footer of the report, select View > Design View . Headers and footers are placed in the blank section below the Page Header and Page Footer:

Create reports in Access 2016 and use advanced reporting options Picture 23

Depending on the design of the report, you will sometimes see no whitespace in the header and footer as shown. If this is the case, you must change the header size and footer before adding anything to it. Just click on the border and drag is okay.

Create reports in Access 2016 and use advanced reporting options Picture 24

Add text to the header, footer:

Select the Design tab> Controls group> Label > drag the mouse in the white area to create a label, release the mouse when the desired size is reached.

Create reports in Access 2016 and use advanced reporting options Picture 25

Click on the newly created label to enter the text you need:

Create reports in Access 2016 and use advanced reporting options Picture 26

Adding dates to the header, footer:

In the Design > tab Header / Footer > Date and Time group :

Create reports in Access 2016 and use advanced reporting options Picture 27

The dialog box appears, select the preferred date format, click OK .

Create reports in Access 2016 and use advanced reporting options Picture 28

Add page numbers to the header or footer:

In the Design > Header / Footer tab > Page Numbers :

Create reports in Access 2016 and use advanced reporting options Picture 29

The Page Numbers dialog box appears. Under Format > Page N to display only the number of the current page or Page N of M to display the current page number and the total number of pages.

Under Position , select Top of Page or Bottom of Page so that the number of pages appears at the top or bottom of the page.

Click on the drop-down arrow and select the alignment for the page number. When satisfied, click OK.

Create reports in Access 2016 and use advanced reporting options Picture 30

Customize the look of the report:

Add a logo:

Go to Design > View > Layout View tab from the drop down list:

Create reports in Access 2016 and use advanced reporting options Picture 31

In the Header / Footer group> Logo

Create reports in Access 2016 and use advanced reporting options Picture 32

Select the logo you want to add> OK .

Create reports in Access 2016 and use advanced reporting options Picture 33

A small image of the logo will appear, drag to when the desired size is reached.

Create reports in Access 2016 and use advanced reporting options Picture 34

If necessary, move the logo to the desired location by dragging and dropping.

Create reports in Access 2016 and use advanced reporting options Picture 35

Change theme report:

Go to the Design tab> Themes > Themes group:

Create reports in Access 2016 and use advanced reporting options Picture 36

Select the theme you want:

Create reports in Access 2016 and use advanced reporting options Picture 37

The theme will be applied to the entire database:

Create reports in Access 2016 and use advanced reporting options Picture 38

Change theme font:

In the Design tab> Themes group > Fonts :

Create reports in Access 2016 and use advanced reporting options Picture 39

Select the font you want:

Create reports in Access 2016 and use advanced reporting options Picture 40

The font will be applied to the entire database:

Create reports in Access 2016 and use advanced reporting options Picture 41

In the next lesson, we will learn how to edit the table in Access, select the data type for the field, limit the data, the number of characters for the data entered in the field, and how to set the error message for the user. when they enter the wrong data. Please read it.

Next article: Edit tables in Access 2016

Previous article: Options to create data queries in Access 2016