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
TABULAR LAYOUT ACCESS 2013 HOW TO
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 kommentar(er)
