In the Books4U Customer Sales Report that was created by Access using the Report Wizard, some of the control fields are not in the correct place based on our specificati In this exercise, we will m
ons.
odify the report to match the requirements given to us by the
rea.
4. Notice that the title, date, and page numbers must be repositioned. Click the Title label control in the Report Header section to select it. Position the mouse pointer inside the orange border of the title control until the pointer changes to a double arrow. Click and drag the mouse pointer until the title is centered above the data on the report. Release the mouse pointer.
he Date control is located in the Page Footer section. We need to move it up to the
til the date is above and to the right of the title in the Report Header section of the report.
e pointer.
6. d on the page. Click the page control in the
Page Footer section to select it. Position the mouse pointer inside the orange border of the page control until the pointer changes to a double arrow. Click and drag the mouse pointer until the page number is centered. Release the mouse pointer.
manager, Ana Rivera.
1. The Books4U Customer Sales Report is currently open in Print Preview.
2. Click the Design View button on the Status bar in the lower right corner of the screen.
3. If needed, close the Shutter Bar on the Navigation pane for a larger viewing a
5. T
Report Header section. Click the date control to select it. Position the mouse pointer inside the orange border of the date control until the pointer changes to a double arrow. Click and drag the mouse pointer through the various report sections un Release the mous
The Page Number control must be centere
EXERCISE – ENHANCING REPORTS IN DESIGN VIEW
7 Click the button on the Status bar in the lower right corner of the screen ications to the
ol bar or click the preview. Advance
title and date to the top of page.
nd CLName Header sections until the pointer changes to a Page Header section.
10. Click the Title control, hold down the Shift key, and click the Date control. Both controls are selected. Right-click the mouse, select copy. Click in the Page Header section. Right-click the mouse and paste. Reposition the Title and Date controls.
11. As you preview the changes, you will notice that the Title and Date appears twice on the first page. This is because we left the controls in the Report Header section. In Design View, Report Header Section, select the Title and Date controls. Press the Delete key. Collapse the Report Header section by placing the mouse pointer just above the Page Header border until the mouse control turns into a double arrow.
Click and drag the Page Header border until it touches the Report Header.
We will now add the totals to the report.
. Report View
to view the changes. Go back to Design View to make any modif controls.
8. Preview the report. Click Print Preview on the Quick Access To Office button roll the mouse over the print option and click print to the next page using the Record Navigator bar. We need to add
each
9. Click the Design View button on the Status bar in the lower right corner of the screen. Expand the Page Header section by positioning the mouse pointer between the Page Header a
double arrow. Click and drag downward to expand the
12. Adjust the control boxes to fit the text. The Date control can be shortened by clicking the Date control. Click the bottom and right orange borders and drag to shorten. You can change the font size of the title and fit the control box to accommodate it.
13. Save the report.
Access 2007 permits the calculation of a sum, average, count, or other aggregates for a field. A grand total is added to the end of the report, and group totals are added to any
2. Click the Total Price text box in the Detail section to select it.
On the Design tab in the Grouping & Totals group, click the Totals pull-down menu and select Sum.
3. Access adds a calculated text box control to the Report Footer
section, which creates a grand total. Access also adds group footer sections to Transaction and Customer groups and places a total in each footer group.
4. Click the Report View button on the Status bar in the lower right corner of the screen.
5. Examine the data. The report is very similar to the sketch provided. We need to add labels to identify each aggregate total. Click back to Design View.
6. dd a Label control to the T# Footer section. On the Design tab, in the Controls control.
groups that exist on the report.
1. Click the Design View button on the Status bar in the lower right corner of the screen.
A
group, click the Label