prompts the designer to specify the title of report being designed. Further, the designer is provided with two options: preview the report or modify its design. After exercising the option, click Finish . (x) Access presents the report in preview mode or design mode depending on which option is chosen in (i) above.
(c) Design View : The design view method offers greatest flexibility to the designer in designing a report. In this method, the report is designed by assembling and embedding various components from report tool box. In order to design a report by using design view, following steps are required: (i) After selecting Reports object, double click Create report in Design view . Access responds by providing a blank report object with three sections: Report/Page header, Detail and Report/Page footer as shown in Figure : .
. (ii) Right click the mouse at the black spot appearing at the left of horizontal ruler of above report. Report object responds by displaying a drop down window. (iii) Click Properties and select Record Source from Data tab.
The record source turns into a combo control giving a list of various tables and queries. Choose the appropriate source of information to be presented in the report being designed. Access responds by providing a list of fields of the selected record source. If this list does not appear or it is closed by mistake, it can be recalled by clicking at the field list icon appearing before the icon for tool box.
Fig. . : Window displaying design view of report (iv) Select the required fields from list of fields displayed as discussed in (c) above, by clicking at each of the fields to be selected while keeping the Ctrl key pressed. Drag and drop the selected fields to Detail section.
(v) The label part of each field is moved to Report/Page header and text part is accordingly aligned below their respective labels column wise. The caption of each label giving headings can be suitably modified, if required. (vii) The vertical ruler controlling the distance between various report sections can be suitably adjusted