New Training: Create Reports in Access 2019
In this 9-video skill, CBT Nuggets trainer Jacob Moran teaches you how to create reports in an Access database. Learn how to define controls and use the various elements of a report to save different dimensions of data in a clear and concise manner. Watch this new Microsoft Office training.
Watch the full course: Microsoft Access 2019 Training
This training includes:
- 9 videos
- 47 minutes of training
You’ll learn these topics in this skill:
- Introduction to Access Reports
- Identifying How Reports are Used In Access
- Navigating Access Reports
- Creating a Report using the Report Tool and Report Wizard
- Creating a Report from Scratch
- Using Groups in Access Reports
- Adding Calculations to Access Reports
- Adding Subtotals to Access Reports
- Summary of Creating Reports in Access
How are Access Reports Organized?
At the beginning of an Access report, is the Report Header. You can look at this as a cover page. It can include items such as your organization's logo as well as a title and a date.
On every page of a report, the Page Header lists the report's title on top.
With every new group of records, a Group Header will display. This will list the group name, such as the region if your report is grouped by region. You can also include calculations for the group.
The Detail section lists detailed information about records in the group.
In the Group Footer, summary information about the group will display.
The Page Footer is like the Page Header. It prints page numbers or other information at the bottom of the page.
Finally, the Report Footer prints at the end of the report and lists totals and other types of summary data.