every section or component of report structure. Those report structure components, which are not required in a specific report being designed, are suppressed. To achieve this suppression, open the View Menu to hide or display the Report Header/Footer, Report Page Header/Footer. The size of every section or report structure component is increased or decreased by dragging section bars up or down using a mouse.
. . Methods of Creating a Report There are three ways in which a report can be created in Access. A brief description of each method is given below: (a) Auto Report : This is the easiest method of creating a report both with columnar and tabular formats.
To begin with formulate, create and save a query, which is capable of providing a record set as the information source of report. Alternatively, the information content must be available in a single table of the database. If the information is generated by relying upon more than one table, query is the option to be exercise. After the information source becomes available in the database, the following procedure is adopted to create Auto Reports.
(i) Select Reports from objects list given in LHS of Database window and click at New object button of tool bar. Access responds by displaying the following New Report Window . (ii) Choose AutoReport : Columnar or AutoReport : Tabular , followed by selecting the information source query or table. (iii) Click OK to generate the report.
Access responds by creating and displaying the report in printpreview mode. (iv) To print the report, click at the print icon on tool bar. (v) To save the report design as object, close the print preview window, and provide a suitable name. Auto Reports are easy and fast to create.
But these reports are less attractive. To prepare more professional report, report wizard is used. Fig. .
: New report window to choose methods of report design (b) Wizard : The Report wizard allows a designer to choose the fields from multiple tables along with specification for grouping, sorting and formatting of information content in report. This