skip navigation
Access 2016 Tutorials

Access 2016 Tutorials

Access 2016 Tutorials - Generating Reports

 
 
 Designing Forms Access 2016 Main Menu Print a Report   

Reports are a means to view and analyze large amounts of data.    You can use the Report Wizard or create a custom report that meets your specific needs.

Report Views

Reports can be displayed in four views:

Design View

This view provides you with the structure of your report.  You can add, modify or delete components of the report but you cannot manipulate the data in the tables associated with the report.

Report View

This view allows you to view the data from the table but not to change any layout of the report.

Layout View

This view allows you to see data from the table and add, modify, and delete components of the report.

Print Preview

This view allows you to see what your report will look like when it is printed

 

To change report views:

  • Click the View button on the Home tab

 

Create a Report

To create a blank report:

  • Click the Blank Report button on the Create tab

 

  • Click the Add Existing Fields button
  • Click the Design tab
  • Click the Add Existing Fields button
  • From the field list, Click and drag the fields to the report

 

Report Wizard

To create a report using the report wizard:

  • On the Create tab, click the Report Wizard button

 

  • Choose the Tables/Queries that you wish to have on the form
  • Choose the fields you wish to have on the forms
  • Click Next

 

  • Choose the sort order for your report

 

  • Choose the layout for the form
  • Click Next

 

  • Create a title for the form
  • Choose whether you want to open the form to view it or modify the form’s design
  • Click Finish

 

Custom Calculated Fields

You can create reports that include calculated fields.  These reports will display information that you wish to report with an arithmetic calculation. To add a custom calculated field to a report:

  • Open the Report that you wish to add to
  • Click the View button
  • Click Design View

 

  • Click the Design tab
  • Click the Text Box button

 

  • Click the section on the report where you would like to locate the textbox
  • Click the Property Sheet Pane

 

  • Click the Data tab
  • Click the three dots next to Control Source

 

 

 

 

  • Insert the fields you wish to include in the calculation and the mathematical operations.
  • Click OK
 Designing Forms Access 2016 Main Menu Print a Report