Shelly Cashman Access 2019 Module 2 SAM Project 1a Personal Insurance Inc

Shelly Cashman Access 2019 Module 2 SAM Project 1a Personal Insurance Inc Contact Me: WhatsApp No:+1(725) 272-9378 1. 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 need to be able to query the database to help make decisions and to answer questions from other employees. Create a query based on the Customers table in Query Design View with the following options: a. Add the CustomerID, FirstName, LastName, and DateOfBirth fields to the design grid in that order. b. Sort the records in ascending order by LastName. c. Save the query using CustomerLastNameSorted as the name. Open the query in Datasheet View, then close it, saving if necessary. 2. Open the HomeownersPremium query in Design View and make the following changes to the query: a. Delete the CustomerID column from the design grid. b. Add criteria to select only those records where the Premium field value is greater than 2,000. c. Save the changes to the HomeownersPremium query. Open the query in Datasheet View, then close it, saving if necessary. 3. Open the LiabilityOrProperty query in Design View and add criteria to select only those records where the Liability field values equal 75,000 or the PersonalProperty field values equal 75,000. Save the changes to the query. Open the query in Datasheet View, confirm that 3 records appear in the LiabilityOrProperty query results, then close the query, saving if necessary. 4. Open the ComparisonBirth query in Design View and make the following changes to the query: a. Add the FirstName field to the query design grid. The FirstName field should immediately follow the CustomerID field. b. Add criteria to select only those records where the DateOfBirth field value is less than 1/1/1950. c. Set the format to Medium Date for the DateOfBirth field. d. Set the caption to BirthDate for the DateOfBirth field. e. Save the changes to the ComparisonBirth query. Open the query in Datasheet View, confirm that the results match Figure 1, then close it, saving if necessary. Figure 1: ComparisonBirth query results 5. Open the StateCitySort query in Design View and make the following changes: a. Move the State field to the beginning of the design grid so that the order of the fields in the grid is State, City, FirstName, and LastName. b. Sort the records in descending order by the State field and in ascending order by City. Save the changes to the query. View the query in Datasheet View, then close it, saving if necessary. 6. Open the LiabilityAndProperty query in Design View and add criteria to select only those records where the Liability field values equal 100,000 and the PersonalProperty field values equal 100,000. Save the changes to the query. Open the LiabilityAndProperty query in Datasheet View, confirm that 2 records appear in the query results, then close the query, saving if necessary. #newperspectives #samprojects #accessproject #access2019 #module2 #samproject1b #samproject1a #eom2 #eom1 #endofmodule #eomproject2 #EOMProject1 #shellycashman #samcapstone1a #textbookproject #personalinsurance