Chapter 4- Create Reports
Reports are often based on queries.
You can add the fields that you need to the query, add criteria, and then use the Report tool to create a report to display the results of the query.
After selecting a theme for your database, you can apply fonts or colors from a different theme.
When you are working with an Access object, the status bar contains buttons for switching views.
When a report is based on a query, the query criteria are applied to the report. Here, only the five instructors without a W-4 form on file are listed.
When you select a theme, you are applying a set of fonts and a set of colors. Here, the Elemental font set includes Palatino Linotype for both labels
and text boxes.
In this manner, you can combine your current theme with a color or font set from a different theme. Here, the report's fonts have changed to
Bookman Old Style for the report header controls and Gill Sans MT for the values in the text boxes. The colors from the Elemental theme are still
Recall that forms and reports are layouts---cells arranged in rows and columns into which controls are placed. You can resize, delete, and merge these
rows and columns so the report can be viewed on a screen without scrolling.
When you resize one text box or label in a report's layout, all the label text boxes in that column are also resized.
The entire report now displays within the width of a typical computer screen. The report is wider than a single sheet of paper, as indicated by the
dashed vertical line.
When you need to print a report, you can adjust its margins and orientation to fit the size of a sheet of paper. You may also need to remove extra
space from the report to prevent printing blank pages.
The first column is very close to the edge of the paper and the Phone column is on another sheet of paper.
When you modify a report so that all the controls fit within a single sheet of paper, some report elements may still extend to a second sheet of paper.
When this happens, a warning displays that the second sheet will be empty.
The Error Message describes the problem and lists commands with possible solutions to the problem.
When extra space is removed, blank pages will not be printed. Here, the entire report displays on a single page.
The Blank Report Tool is used when you want to build a report by adding fields one at a time or to arrange the fields in a different layout.
As you add fields with the Blank Report tool, the other tables move to the lower sections of the Field List pane.
When you add a field from another table, that table moves to the upper pane of the Field List and any tables related to this table become available.
Report data can be grouped and sorted to add meaning to it.
Reports can b