to this blank design of report. (iii) Alternatively, double click at Create report in design view . Access respond by displaying a blank report design duly divided into three sections as stated above. Right Click at the left most corner point of report design where horizontal and vertical rulers converge.
Click at Properties of report and select Data tab to define the record source as Query . Immediately, there appears as list of available fields of Query so as to be placed on to blank design of report. (iv) Right click at any part of the report design and choose Report Page Header and Footer. Access responds by providing two more sections: Page Header and Page Footer.
(v) Click at the icon for tool bar and pick up a label control to be placed at Page Header Section and assign set its caption property to Trial Balance , Font Size to , Font colour to Blue, Text align to Left and Font weight to Bold. (vi) Select all the fields of Query by clicking at every field while keeping the Ctrl key pressed. Drag and drop the selected fields on Details section. It may be noted that each of the dropped fields has two controls: Label and Text.
The former gives caption and the latter provides the data content. (vii) Select the label controls of all the four fields by clicking at each while keeping the Shift Key pressed. Right click at selected label controls and choose cut . Place the mouse at Page Header section and paste these controls.
(viii) Re-arrange these label controls to appear as headings of columns for trial balance as: Code, Name of Account, Debit and Credit. Select all these label controls and right click to choose properties. Access provides Properties of these controls. Choose format tab and set the Font weight Property to Bold; Font Size to ; Font colour to Blue and Text align to Centre.
(ix) Align the Text controls in Detail section to appear just below each of the respective label controls appearing in Page Header section. (x)