Microsoft Office Tutorials and References
In Depth Information
Knowing Forms Means That You Already Know Reports
Knowing Forms Means That
You Already Know Reports
Reports and forms are used very differently, but you create them in similar
ways. You can create both forms and reports by running wizards. You can
create or modify both forms and reports in Layout view, where you can
create and rearrange controls, and in Design view, where you can customize
the controls and sections of a report, along with their properties.
To see a list of the reports in your database — and, eventually, to open
or modify a report — scroll down in the Navigation Pane until you get to
the Reports section. If you don’t see the Reports section in the Navigation
Pane, click the down arrow on the title bar of the Navigation Pane and
choose Object Type from the drop-down menu. The items displayed in the
Navigation Pane change. Now click the down arrow again. Reports is one of
the options on the drop-down menu.
You can look at a report in four views:
✦ Layout view: Allows you to rearrange the controls on your report and
create new ones. It works like Layout view for forms, as described in
Book IV, Chapter 1.
✦ Design view: Gives you a behind-the-scenes look at what fields the
report displays where. It works like Design view for forms, as described
in Book IV, Chapter 2.
✦ Report view: Displays the report formatted with real data, as described
in “Viewing Your Reports Onscreen,” at the end of this chapter.
✦ Print Preview: Shows how the report will look when you print it,
including page breaks, headers, and footers. Chapter 2 of this minibook
describes how to check how your report will look before you waste
paper printing it.
To open a report, right-click its name in the Navigation Pane and choose a
view from the contextual menu. You can switch between views by clicking
the View button in the Views group on the Home tab of the Ribbon. You
can switch to any view by clicking the down arrow on the View button and
choosing the view you want from the drop-down menu.
This chapter describes how to make reports by running wizards, as well as
how to customize reports in ways that don’t work for forms. For information
about how to create and customize reports in Layout view and Design view,
including adding controls and setting properties, applying themes and other
formatting (such as conditional formatting), and creating calculated fields,
see Book IV, Chapters 1, 2, and 4.