Hire Me For Complete Course
For Help Contact Me on
WhatsApp Number : +994 40 158 33 14
Whatsapp Link : [ Ссылка ]
#SC_AC365_3a_2
#SC_AC365_3a_FirstLastName_1
#SC_AC365_3a_FirstLastName_1.accdb
#SC_AC365_3a_FirstLastName_2.accdb
#Module3
#SAMProject1a
#SAMProject1aPersonalInsuranceInc.
#ShellyCashmanAccess365
#SAMProject
1.Personal Insurance, Inc. needs to update their database on a regular basis. For example, customers move, change coverage limits, and add and delete policies. In Query Design View, create an Update query based on the Renters table.
a. Select the PolicyNumber and PersonalProperty fields from the Renters table.
b. Add criteria to select only those records where the PolicyNumber field values equal R11234.
c. Update the PersonalProperty field with 100,000 as the new field value.
d. Save the query using UpdatePersonalProperty as the name, run it, and then close it. The query should update one record.
2. In Query Design View, create a Make Table query that selects all the fields from the Homeowners table in the same order that they are listed in the field list. Select all the fields individually for the design grid; do not use the (*) asterisk.
a. Add criteria to select only those records where the PropertyDamage field value is greater than or equal to 750,000.
b. In the Make Table dialog box, assign the name HighDamageAmts to the new table.
c. Save the query using MakeHighDamageAmts as the name, run it, and then close the query. The new HighDamageAmts table should contain five records
10. Open the Claims table in Design View and perform the following tasks:
a. Make the ClaimID field the primary key.
b. Change the field size property for the CustomerID field to 6.
c. Change the data type for the ClaimAmount field to Currency.
d. Add a new field AmountDue after the Paid field. The field is a calculated field. Type the expression ClaimAmount - Paid to calculate the field values.
Save the changes to the Claims table and then close it.
11. Open the Umbrella table in Design View and perform the following tasks:
a. Change the Decimal Places property for the Coverage field to 0.
b. Change the Format property for the PolicyNumber field so that any letters in the field display in uppercase.
c. Enter Additional Liability Coverage as the Description for the Coverage field.
Save the changes to the Umbrella table and then close it.
12. Open the Homeowners table in Datasheet View. Add a new field, to the end of the table (Click to Add column). The field is a calculated field with the currency format. Use the expression to calculate the field values. Assign the name TotalCoverage to the field. Save the changes to the table and close it.
13. Open the Claims table in Datasheet View and perform the following tasks:
a. Resize the PolicyNumber, ClaimAmount, and ClaimApproved columns to display the complete field names.
b. Remove the Total row from the table.
c. Sort the records in ascending order by ClaimAmount.
Save the changes to the Claims table and then close it.
14. Open the Renters table in Design View and make the following changes:
a. Enter a Validation Rule for the Deductible field to ensure that values in the field are greater than or equal to 0.
b. Enter the text, Must be greater than or equal to 0 in the Validation Text property box.
Save the changes to the Renters table and then close it. (Hint: Because a validation rule was added, a warning message appears asking if you want to test the data. The data is valid, so ignore this message and continue saving the table.)
15. Open the Relationships window and add the Customers and Renters tables to the Relationships window. Create a one-to-many relationship between the CustomerID field
17. Open the TotalCoverage query in Design View. Use the Expression Builder to create a calculated field at the end of the query grid that calculates the sum of the Liability and PropertyDamage fields. Assign the alias (caption) TotalCoverage to the calculated field. Open the query in Datasheet View, and then close it, saving if necessary.
18. Open the Renters table in Datasheet View. Modify the expression in the TotalCoverage field to subtract the Deductible from the calculation. (Hint: The final expression will be [Liability]+[PersonalProperty]-[Deductible]). Save the changes to the table and close it.
19. Open the Umbrella table in Datasheet View. Add the Total row to the datasheet and calculate the Average for the Premium field. Save the changes to the table and close it.
20. Open the Customers table in Datasheet View and display the Subdatasheet for the customer with CustomerID 11004. Update the Deductible for policy R10223 to $1,000. Close the Customers table.
