When you add a control to the detail section of a report how often will you see it in the report
|
Access breaks your reports into separate parts called sections. Each section has its own specific purpose and always prints in the same order on a report. Let's take a closer look at the sections in a report. Show
AReport Header: The Report Header contains text that appears at the top of the first page of a report, such as the name of the report.BDetail: The Detail section contains text and the actual fields that are displayed for each record. This would be like the main body in a word-processing document.CPage Footer: The Page Footer contains text that appears at the bottom of each page of a report, such as page numbers.DReport Footer: The Report Footer contains text that appears at the end of the last page of a report. It often contains numeric summaries for the report, such as a grand total. You can add controls to your reports the same way you add them to forms. The control appears on your report. Reports consist of controls that provide the labels, field values, lines, page numbers, and more that make up the report. Where and how often those controls appear on the printed report is determined by the section in which the control appears. Only the Detail section is currently in view. This section is the main body of the report and is usually used to display actual values. Theoretically, you don't need a Detail section to have a report. But as a practical matter, nearly all reports have one.
A few things need fixing in the report (well, more than a few, but let's concentrate on essentials). The fields are a little close together. Some of the Country and Government Type values are truncated. Also, numbers are currently aligned right; they'd probably look better aligned left. And it would be nice if the Country field values were bold. Reports offer a way to view, format, and summarize the information in your Microsoft Access database. For example, you can create a simple report of phone numbers for all your contacts, or a summary report on the total sales across different regions and time periods. From this article, you’ll get an overview of reports in Access. You’ll also learn the basics of creating a report, and using options like sorting, grouping, and summarizing the data, and how to preview and print the report. Note: The information in this article is intended for use only with Access desktop databases. Access web apps don't support reports. In this articleOverview of reports in AccessWhat can you do with a report?A report is a database object that comes in handy when you want to present the information in your database for any of the following uses:
Parts of a reportWhile it is possible to create “unbound” reports that do not display data, but for the purposes of this article, we’ll assume that a report is bound to a data source such as a table or query. The design of a report is divided into sections that you can view in the Design view. Understanding how each section works can helps you create better reports. For example, the section in which you choose to place a calculated control determines how Access calculates the results. The following list is a summary of the section types and their uses: Section How the section is displayed when printed Where the section can be used Report Header At the beginning of the report. Use the report header for information that might normally appear on a cover page, such as a logo, a title, or a date. When you place a calculated control that uses the Sum aggregate function in the report header, the sum calculated is for the entire report. The report header is printed before the page header. Page Header At the top of every page. Use a page header to repeat the report title on every page. Group Header At the beginning of each new group of records. Use the group header to print the group name. For example, in a report that is grouped by product, use the group header to print the product name. When you place a calculated control that uses the Sum aggregate function in the group header, the sum is for the current group. You can have multiple group header sections on a report, depending on how many grouping levels you have added. For more information about creating group headers and footers, see the section Add grouping, sorting, or totals. Detail Appears once for every row in the record source. This is where you place the controls that make up the main body of the report. Group Footer At the end of each group of records. Use a group footer to print summary information for a group. You can have multiple group footer sections on a report, depending on how many grouping levels you have added. Page Footer At the end of every page. Use a page footer to print page numbers or per-page information. Report Footer At the end of the report. Note: In Design view, the report footer appears below the page footer. However, in all other views (Layout view, for example, or when the report is printed or previewed), the report footer appears above the page footer, just after the last group footer or detail line on the final page. Use the report footer to print report totals or other summary information for the entire report. You’ll find that it’s much easier to create meaningful reports when your database has a well-designed table structure and relationships. For an introduction to planning and designing a database, see the article Database design basics. Create a report in AccessYou can create reports for you Access desktop database by following the steps below: Step 1: Choose a record sourceThe record source of a report can be a table, a named query, or an embedded query. The record source must contain all of the rows and columns of data you want display on the report.
Step 2: Choose a report toolThe report tools are located on the Create tab of the ribbon, in the Reports group. The following table describes the options: Tool Description Report Creates a simple, tabular report containing all of the fields in the record source you selected in the Navigation Pane. Report Design Opens a blank report in Design view, to which you can add the required fields and controls. Blank Report Opens a blank report in Layout view, and displays the Field List from where you can add fields to the report Report Wizard Displays a multiple-step wizard that lets you specify fields, grouping/sorting levels, and layout options. Labels Displays a wizard that lets you select standard or custom label sizes, as well as which fields you want to display, and how you want them sorted. Step 3: Create the report
Add grouping, sorting, or totalsThe fastest way to add grouping, sorting, or totals to a desktop database report is to right-click the field to which you want to apply the group, sort, or total, and then click the desired command on the shortcut menu. You can also add grouping, sorting, or totals by using the Group, Sort, and Total pane while the report is open in Layout view or Design view:
For more detailed information about grouping, sorting, and totals, see the article Create a grouped or summary report. Highlight data with conditional formattingAccess includes tools for highlighting data on a report. You can add conditional formatting rules for each control or group of controls, and in client reports, you can also add data bars to compare data. To add conditional formatting to controls:
Customizing color and fontsTry an App Theme options to customize the color and fonts.
Add a logo or background imageYou can add a logo or background image to a report and If you update the image, the update is automatically made wherever the image is used in the database. To add or remove an image:
To add a background image:
Preview and print a reportPreview a report
Print a reportTo print a report without previewing it:
|
