data (or information) from existing data tables (or queries). (iii) Using the Record set of Final SQL : The record set of final SQL that relies upon preceding SQL statement, is collection of report-oriented information. This record set need be embedded in the report being produced. .
. Basics of Designing a Report in Access A report, in Access, is a static presentation of stored or transformed data in an organised manner. Access saves the design of the report, which consists of information structure along with various controls to display information content and its record source. When a saved report is opened, the information content is retrieved from the tables and displayed according to the design.
As a result, a saved report design, when opened, displays the information content according to the current state of data. There are two types of formats of presenting information through a report: Columnar and Tabular. Columnar Report Format : A columnar format displays the caption of each field on a separate line in a single column down the page. The corresponding information contents of the fields are shown in another column next to their respective fields.
If the caption property of a field is kept blank, the name of the field is used as its caption. This implies that there are two columns in this format: one for displaying the fields and another for showing the corresponding information content. A record set that consists of nine fields, when presented in such a format, requires nine lines of report. In columnar format, the total number of lines to be printed equals the number of fields multiplied by the number of record sets to be displayed.
Tabular Report Format : A tabular format displays the caption of fields on the same line so that their respective information contents appear in the next line. The number of columns in tabular report is exactly equal to the number of fields to be displayed. It implies that the above mentioned record set, when presented in tabular format, requires one line for captions of fields and another line for information