New Perspectives Access 365 | Module 7: SAM Project A

Please contact us if you need this project or any other project in any subject to be completed.
Whatsapp: +1-343-321-3276
Email: essayserviceusa@gmail.com
WhatsApp Link: https://wa.me/13433213276
#NewPerspectivesAccess365 #Module7SAMProjectA
#LighthouseCybersecurity
New Perspectives Access 365 | Module 7: SAM Project A
Lighthouse Cybersecurity
MODIFYING ADVANCED REPORTS
PROJECT STEPS
1. As a project assistant for Lighthouse Cybersecurity, you have created an Access database to track new clients and their projects, services, and analysts. To meet a need for well-formatted, professional-quality information, you will modify advanced reports.
Open the AnalystSalary report in Report Layout View and modify it as follows to identify the data more clearly:


a. Add a title to the report to identify its contents.
b. Modify the title to change its font size to 22 pt.
c. Resize the title label control so it is only wide enough to display its text.
d. Center the AnalystID label and the data in the AnalystID text box.

Save and close the AnalystSalary report.
2. Open the ClientGrouped report in Report Design View, and add a grouping level on the RegionCode field to group the data by region. Save and close the report.
3. Open the AnalystList report in Report Design View and modify the layout as follows to display the data in columns:

4. Open the RegionList report in Report Design View and modify the design as follows to remove clutter from the report:
5. With the RegionList report still open in Report Design View, format the report as follows to make it easier to read:
6. Create a new report in Report Design View as follows to list client revenue data:

7. In the Navigation Pane, copy the ClientList report and paste it, using ClientDetails as the name, to create a similar report with slightly different contents.
8. Open the ClientDetails report in Report Design View and modify it as follows to display complete field values:

9. While still working in Report Design View of the ClientDetails report, add a sort order to sort the records in ascending order by ClientName to make it easier to find information.
Save and preview the report, a portion of which is shown in Figure 2, and then close the ClientDetails report.
Figure 2: Final ClientDetails Report in Print Preview



10. Use the Label Wizard to create labels based on the Analyst table as follows:
11. Open the ProjectList report in Report Design View and then modify it as follows to add identifying information:

a. Add page numbers to the report using the Page N of M format positioned in the left side of the Page Footer.
b. Add the date (but not the time) to the report using the Medium Date (07-Feb-29) format.

Save the ProjectList report.
12. With the ProjectList report still open in Report Design View, modify the report as follows to calculate the total monthly fees:

a. Adjust the Report Footer section to be about 0.5" tall.
b. Add a text box to the right side of the Report Footer section directly below the MonthlyFee text box in the Detail section.
c. Within the text box, add an expression to sum the MonthlyFee field for the entire report.
d. Enter Total Monthly: as the caption for the new label in the Report Footer section. If necessary, resize the label to display the complete caption.

Save the ProjectList report.
13. With the ProjectList report still open in Design View, format the report as follows to make the information easier to interpret:

a. Right-align the content in the MonthlyFee text box in the Detail section and in the new text box in the Report Footer section.
b. Right-align the right edge of the new text box in the Report Footer section with the MonthlyFee text box in the Detail section.
c. Apply the Currency format to the text box in the Report Footer section.

Save and preview the report in Print Preview as shown in Figure 4, and then save and close the ProjectList report.