obviates the limitation of Auto Reports. In order to create reports by wizard, following steps are required. (i) After selecting Reports object, double click at Create Report by Using Wizard . Access responds by displaying Report Wizard window similar to the one displayed for query wizard (See Fig .
). (ii) Choose the table or query that includes information content of report, from Tables/Queries drop-down list on LHS. (iii) Use arrow buttons to select fields to provide the information source to report. Single right arrow button is used to select one field and double arrow button to select all fields.
Alternatively, double click at the fields to be selected in the same order in which they are required to be displayed in the report. (iv) Another table or query can be chosen to select more fields for a report to provide a definite relationship between the tables is defined. Click Next when selection process of data source is complete. (v) Access responds by prompting the designer to add any grouping level(s) for displaying the information content of the report.
The report is prepared by choosing any repeated data item to constitute a group. Click Next when the grouping level is added and defined. (vi) Access responds by requiring the designer to specify the sort order based on any of the fields contained in the report. The records may be sorted up to four fields by specifying either ascending or descending order for each field.
After specifying the sort order, click Next or specify the summary values to calculate. The summary values are sum, average, minimum and maximum. Once summary values are specified, click OK , followed by click Next . (vii) Report wizard responds by requiring the designer to choose the report layout (stepped, block, outline and align left) and its orientation (portrait and landscape).
Click Next after specifying the layout and orientation. (viii) Report wizard prompts the designer to choose a particular style of report from among six styles: bold, casual, compact, corporate, formal and soft-gray. After choosing a suitable style for report, click Next . (ix) Report wizard