Access 2016 Intermediate

Access 2010

Lesson 12 – Using Advanced Report Design

E XERCISE

U SING A DVANCED R EPORT D ESIGN



Task

Use advanced report design.

1. Open ADVREPX.ACCDB . 2. Create a new report in Design view based on the Project table.

3. Add the Client ID field to the 1" mark on the horizontal ruler in the Detail section. Below the Client ID field, add the Course Name , Trainer Initials , and Students fields to the report at the 3" mark on the horizontal ruler in the Detail section. 4. Display the report header and footer. Using the toolbox, add a label to the left side of the report header. Enter the text Client Information . 5. Preview the report. Then, close the report and save it as Client Info . 6. Open the Project Information Report report in Design view. 7. Add a calculated control below the Trainer Initials text box to calculate the profit margin of each project. The calculation should use the following formula: =[Total Sale]*.08 . Format the calculation as currency. Position the calculated control under the Trainer Initials text box. Change the text in the label to Profit Margin . If necessary, resize the label to view all the text, and then, position it under the Trainer Initials label. 8. Preview the report. Notice the profit margin calculation. Then, switch back to Design view. 9. Display the Report Header/Footer section. 10. Insert the date only using the default date format. Move the date control to the Page Footer section. 11. Adjust the top and bottom page margins to 40mm . 12. Preview the report to see the new margins. Notice that the date appears on each page of the report. Close the report, saving the changes. 13. Use the Label Wizard to create labels based on the Trainer table. Use the Avery L7161 labels and the default font and color settings. Include the First Name and Last Name fields, separated by a space on the same line. Sort the labels by the Last Name and First Name fields. Use Labels Trainer as the name of the report. 14. Close the labels report after viewing it. 15. Close the database file.

OFFICEPRO, Inc.

Page 239