Personal Insurance Query Creation and Modification

Query Design View for Customers Table

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:
Add the CustomerID, FirstName, LastName, and DateOfBirth fields to the design grid in that order.
Sort the records in ascending order by LastName.
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:
Delete the CustomerID column from the design grid.
Add criteria to select only those records where the Premium field value is greater than 2,000.
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:
Add the FirstName field to the query design grid. The FirstName field should immediately follow the CustomerID field.
Add criteria to select only those records where the DateOfBirth field value is less than 1/1/1950.
Set the format to Medium Date for the DateOfBirth field.
Set the caption to BirthDate for the DateOfBirth field.
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.