Introduction to Designing and Creating Report in Microsoft Access
Reports are a terrific feature in Access and give you a way to present your data attractively.
You can even group and summarize data easily by using the Report Wizard.
After completing this module, you will be able to:
Describe when to use a report
Create a report using the AutoReport feature and the Report Wizard
Navigate the report view
Create mailing labels
Edit and add controls in the Report Design view
Use report sections
Create a calculated control
Add page breaks to a report
Create Reports Manually
Reports often include sets of information that are related to the topic of the report, but not necessarily related to each other.
For example, a report might include information about the production, marketing, and sales activities of a company.
Or it might include information about compensation and the pension plan of a company.
Each topic is related to a particular aspect of running the business, but the topics do not all fit nicely into the structure of an individual Microsoft Access 2013 report.
One solution to this problem is to create separate reports, print them, and store them together in a binder.
Another is to save them in electronic format in a folder or on a network.
An easier and more sophisticated solution is to combine them by using subreports.
In this chapter, you will build a fairly complex report.
You will start by creating the report shell (the main report) manually in Design view.
Then you will modify the layout and content of the shell report.
Finally, you will provide detailed information by embedding a subreport within the main report.