New Perspectives Access 2019 | Module 7: End of Module Project 1 скачать в хорошем качестве

New Perspectives Access 2019 | Module 7: End of Module Project 1

Please contact us if you need this project or any other projects in any subject to be completed. WhatsApp: +1-343-321-3276 Email: essayserviceusa@gmail.com WhatsApp Link: https://wa.me/13433213276 #newperspectivesaccess2019 #Module7EndofModuleProject1 #HomesteadPartners New Perspectives Access 2019 | Module 7: End of Module Project 1 Homestead Partners CREATING AND MODIFYING REPORTS PROJECT STEPS 1. Homestead Partners is a company that connects independent home owners with long-term renters. You work in the Customer Service Department of Homestead Partners as a data analyst. You are developing an Access database application to help manage and analyze several types of customer service data, including property and property manager effectiveness. In this project, you will improve an existing database by creating and modifying many different types of report controls. You will also format, modify, and create new reports. Open the ManagerScores report in Layout View and add a title. Modify the title to add a space between the words Manager and Scores and bold the title. Right-align the last names in the first column Bretz, Dzambazi, Perez, Walton, and Washington. Save and close the ManagerScores report. 2. Open the Properties report in Design View and set the number of columns to 2 with a down then across layout. Save and preview the Properties report, and then close it. 3. Open the Surveys report in Design View and remove the control layout from the controls in the Page Header, Detail, and Report Footer sections. Remove the Report Header and Report Footer sections. (Hint: Select Yes in the Microsoft Access window that appears asking if you want to delete the sections.) Resize the Comment text box so that the right edge reaches the 7.5" mark on the horizontal ruler. Save the Surveys report. 4. With the Surveys report still open in Design View, select all controls and change the font color to Automatic (black) and set the Alternate Back Color to White, Background 1 for the Detail section. Save and close the Surveys report. 5. Create a new report in Report Design View. Set the Record Source property to the Managers table. Add all of the fields from the field list to the top of the Detail section of the report at about the 2" mark on the horizontal ruler. Save the report with the name of ManagerList and close it. 6. In the Navigation window, copy the HomeStyles report and paste it with the name HomeInfo. Open the HomeStyles report in Design View, delete the Property No label in the Page Header section and the PropertyNo text box in the Detail section. Move the LName text box slightly to the right so that the left edge is at the 4.5" mark on the horizontal ruler. Save the HomeStyles report. 7. While still working in Design View of the HomeStyles report, add a sort order after the two grouping fields to sort the records in descending order, from largest to smallest, by the YearBuilt field. Save and preview the report as shown in Figure 1, then close the HomeStyles report. Figure 1: HomeStyles Report in Print Preview 8. Open the StateListing report in Design view expand the size of the Detail section to be about 2" tall, then use the Subreport Wizard to add a subreport control to the form just below the StateName label. Base the subreport on the Properties table. Include the PropertyNo, City, ManagerID, and YearBuilt fields from the Properties table. Use the default link and name for the subreport. Save and close the StateListing report. 9. Open the ManagerBonuses report in Design View and add page numbers to the report using the Page N format positioned in the left side of the Page Footer. Add the date (but not the time) to the report using the default date format. Save the ManagerBonuses report. 10. With the ManagerBonuses report still open in Design View, expand the Report Footer section to be about 0.5" tall and add a text box at about the 3" mark on the horizontal ruler. Within the text box, add an expression to total the SignonBonus field for the entire report. Delete the label in the Report Footer section. Right align the right edges of the new text box in the Report Footer section with the SignonBonus text box in the Detail section. Save and preview the report in Report View as shown in Figure 2, then close the ManagerBonuses report. Figure 2: ManagerBonuses Report in Report View