Microsoft Office Tutorials and References
In Depth Information
Tutorial 7
Objectives
Creating Custom
Reports
Creating Reports with Information About
Contracts and Invoices
Session 7.1
• View, filter, and copy
report information in
Report view
• Modify a report in
Layout view
• Modify a report in
Design view
Session 7.2
• Design and create a
custom report
• Sort and group data in
a report
• Add, move, resize,
and align controls in
a report
• Add lines to a report
• Hide duplicate values
in a report
Case | Belmont Landscapes
At a recent staff meeting, Sarah Fisher indicated that she would like to make
some changes to an existing report in the database. She also requested a new
report that she can use to produce a printed list of all invoices for all contracts.
In this tutorial, you will modify an existing report and create the new report for
Sarah. In modifying and building these reports, you will use many Access report
customization features, including grouping data, calculating totals, and adding
lines to separate report sections. These features will enhance Sarah’s reports and
make them easier to read and use.
Session 7.3
• Add the date, page
numbers, and title to
a report
• Create and modify
mailing labels
Starting Data Files
Case1
Case2
Panorama.accdb
(cont.)
Products.accdb
(cont.)
Contract.accdb
(cont.)
Training.accdb
(cont.)
Case3
Case4
Case5
Agency.accdb
(cont.)
Vacation.accdb
(cont.)
ACE.accdb
(cont.)
Search JabSto ::




Custom Search