Shelly Cashman Access 2019 | Module 4: SAM Project 1a | Personal Insurance, Inc. скачать в хорошем качестве

Shelly Cashman Access 2019 | Module 4: SAM Project 1a | Personal Insurance, Inc.

For Solution contact us on WhatsApp or Email WhatsApp: +1 209 345 9376 Email address: schoolworkhelper664@gmail.com Whatsapp link : https://wa.link/t4mgjz #shellycashmanaccess2019module4samproject1a,#shellycashmanaccess365 2021module2samproject1a,#shellycashmanaccess2019module1samprojct1a,#module4samproject1apersonalinsuranceinc,#shellycashmanword 2019module4samproject1a,#shellycashmanexcel2019module4samproject1a,#shellycashmanaccess365 #access2019 | #module1samproject1a,#shellycashmanaccess2019 #module2samproject1a,#shellycashmanaccess2019 #module10samproject1a Personal Insurance, Inc. is a national company that insures homeowners and renters. As a regional manager, you need to be able to prepare reports for other managers and create forms that help in making database updates. Open the Regional Customer Report in Layout View. Group the report by the Region field, and then sort the report by the CustomerID field in ascending order. Do not add any additional grouping or sorting options to the report. Close the Group, Sort, & Total pane, then save and close the report. 2. Open the Renter Policy Report in Layout View, and modify the report as follows: a. Average the values in the PersonalProperty column and sum the values in the Premium column. b. Switch to Print Preview to view the report and to check that the values in the subtotal controls and the total controls are not truncated (cut off) vertically. c. Return to Layout View, and, if necessary, drag the sizing handles for the subtotal control and the total control down so that the values display completely. Save the report without closing it. 3. With the Renter Policy Report still open in Layout View, apply conditional formatting to the Premium column. If the premium amount is greater than $225, display the value in bold, Maroon font (6th column, 1st row of the Standard Colors palette). Save the report again, confirm that it matches Figure 1, and then close it. Figure 1: Renter Policy Report 4. Open the NE Homeowners Report in Layout View, and then create a summary report. Save and close the report. 5. Open the Customer Contact Report in Layout view. Apply the Office theme to this object only. Save and close the report. 6. Use the Label Wizard to create mailing labels for the Customers table, and include the following options: a. Use Avery C2163 as the label size. b. Use Arial font, 11 point font size, Light font weight, and Black (1st column, 6th row of the Basic Colors palette) font color with no special font styles for the labels. (Hint: These formatting options may be the default settings for your label.) c. On the first line of the label, include the FirstName field, a space, and the LastName field. d. On the second line of the label, include the Address field. e. On the third line of the label, include the City field, a comma (,), a space, the State field, a space, and the PostalCode field. Your label should match Figure 2. f. Sort the labels by the PostalCode field. g. Save the report as Labels Customers (which is the default name). Preview the report, confirm that it matches Figure 3, and then close it. Figure 2: Prototype Customers Label Figure 3: Labels Customer Report 7. Use the Report Wizard to create a report based on the Customers and Renters tables. The report should include the following options: a. Include the CustomerID and LastName fields from the Customers table. b. Include the PolicyNumber and Premium fields from the Renters table. c. The data will automatically be grouped by the CustomerID and LastName fields, but do not add any additional grouping levels. d. Sort the report by the PolicyNumber field in ascending order. e. Use the Stepped layout and Portrait orientation. f. Save the report using Customers and Renters Report as the report na