The tabular layout is a good one to use if your report has a relatively small number of fields that you want to display in a simple list format. This is the type of report that Access creates when you click Report in the Reports group of the Create tab. Tabular refers to the table-like appearance of the data. Labels are across the top, and the data is aligned in columns below the labels. Tabular layout A tabular layout is similar to a spreadsheet. Most reports are arranged in either a tabular or a stacked layout, but Access gives you the flexibility to use just about any arrangement of records and fields that you want. You can add group header and footer sections by using the Group, Sort, and Total pane in Layout view or Design view. Group totals (sums, counts, averages, and so on)įor information about adding or removing report header and footer sections or page header and footer sections, see the section Add or remove report or page header and footer sections in this article. Report totals (sums, counts, averages, and so on)Īppears at the top of each page of the report.Īppears at the bottom of each page of the report.Īppears just preceding of a group of records. The following table describes where each section is located and how the section is typically used.Īppears only once, at the top of the first page of the report.Īppears after the last line of data, above the Page Footer section on the last page of the report. Other sections are optional and repeat less often and are usually used to display information that is common to a group of records, a page of the report, or the entire report. This section repeats once for each record in the table or query that the report is based on. The one section that is present in every report is the Detail section. Decide which data to put in each report sectionĮach report has one or more report sections. The query can be embedded in the RecordSource property of the report, or you can create a separate, saved query and base the report on that. More often, the data that you want is stored in several tables that you must pull together in a query, before you can display it on the report. If all the data is contained in a single table, you can base your report directly on that table. In this case, the other person can draw the sketch before you begin work.Īfter you create your sketch, determine which table or tables contain the data that you want to display on the report. Note: This technique is also very useful if you are designing a report for someone else. Or, perhaps your report is a simple listing of the data in the table, in which case your sketch can contain just a series of rows and columns. Then, the sequence repeats for the next product and so on until the end of the report. Whichever method that you use, be sure to include enough rows to indicate how the data repeats.įor example, you can use a row for product information, then several repeating rows for that product's sales, and finally a row of sales totals for the product. Alternatively, you can use programs such as Word or Visio to create a mockup of the report. However, if you decide to design your report without using these tools, you might find it helpful to make a rough sketch of your report on a piece of paper by drawing a box where each field goes and writing the field name in each box. This step is not required - you might find that the Access Report Wizard or the Report tool (both of which are available on the Create tab, in the Reports group) provide a sufficient starting design for your report. This can be an indication that the tables are not normalized - this means that the data is not stored in the most efficient manner. During the design process, you might even discover that the arrangement of data in the tables will not allow you to create the report that you want. When you design a report, you must first consider how you want the data arranged on the page and how the data is stored in the database. In this articleĪdd or remove report or page header and footer sections This article discusses the general process of designing a report and then shows you how to add specific design elements to your report. Whichever method that you choose, you will probably make at least a few changes to the design of the report to make it display the data the way that you want. You can use the Report Wizard to create a more complicated report, or you can create a report by adding all the data and formatting elements yourself. You can use the commands on the Create tab to create a simple report with a single click. Access provides you with a number of tools that help you to quickly build attractive, easy-to-read reports that present the data in a way that best suits the needs of its users.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |