Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Personal Insurance, Inc. is a national company that insures homeowners and renters. It also offers umbrella policies that provide additional coverage. As a regional manager,
Personal Insurance, Inc. is a national company that insures homeowners and renters. It also offers umbrella policies that provide additional coverage. As a regional manager, you've decided to create an Access database to better manage information on customers and policies. Create a new table in Datasheet View with the following options: Rename the default primary key ID field PolicyNumber and change the data type to Short Text. PolicyNumber should remain the primary key. Add a new field with the name CustomerID and the Short Text data type. Change the field size of the CustomerID field to Add a new field with the name PersonalProperty and the Currency data type.Save the table using Renters as the name. With the Renters table still open in Datasheet View, add the record shown in Table Save and close the Renters table. Table : Record for Renters TablePolicyNumber CustomerID PersonalPropertyR Create a new table in Design View to store the clients of Personal Insurance, Inc. who own homes as follows: Add a field with the name PolicyNumber and the AutoNumber data type. Set PolicyNumber as the table's primary key.Save the table with the name Homeowners but do not close it With the Homeowners table still open in Design View, add a second field to the table with the field name CustomerID and the Short Text data type. Save the table and then close it Open the Customers table in Design View and change the name of the field named First to FirstName and use LastName to change the name of the field named Last. With the Customers table still open in Design View, change the data type property for the CustomerID field from Number to Short Text. In Design View, add a new field to the Customers table after the PostalCode field. The field should be named DateOfBirth and have the DateTime data type. Save the Customers table. Switch the Customers table to Datasheet View, navigate to the third record which has a CustomerID field value of and delete the record. With the Customers table still open in Datasheet View, navigate to the fifth record which has a CustomerID field value of and change the value to Alberts for the LastName field. Close the Customers table. You also need to view individual customer records. Use the Form tool to create a form for the Customers table. Save the form with the name Customer Data Form and confirm that the form matches Figure Close the form.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started