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. 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 Open the query in Datasheet View, then close it, saving if necessary. 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. 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 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 Set the caption to BirthDate for the DateOfBirth Save the changes to the ComparisonBirth Open the query in Datasheet View, confirm that the results match Figure 1, then close it, saving if necessary.

Oracle 12c: SQL

3rd Edition

ISBN:9781305251038

Author:Joan Casteel

Publisher:Joan Casteel

Chapter6: Additional Database Objects

Section: Chapter Questions

Problem 6HOA: A new table has been requested to support tracking automated emails sent to customers. Create the...

See similar textbooks

Related questions

Concept explainers

Question

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:
1. Add the CustomerID, FirstName, LastName, and DateOfBirth fields to the design grid in that order.
2. Sort the records in ascending order by LastName.
3. Save the query using CustomerLastNameSorted as the name.
  Open the query in Datasheet View, then close it, saving if necessary.
Open the HomeownersPremium query in Design View and make the following changes to the query:
1. Delete the CustomerID column from the design grid.
2. Add criteria to select only those records where the Premium field value is greater than 2,000.
3. Save the changes to the HomeownersPremium
  Open the query in Datasheet View, then close it, saving if necessary.
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.
Open the ComparisonBirth query in Design View and make the following changes to the query:
1. Add the FirstName field to the query design grid. The FirstName field should immediately follow the CustomerID
2. Add criteria to select only those records where the DateOfBirth field value is less than 1/1/1950.
3. Set the format to Medium Date for the DateOfBirth
4. Set the caption to BirthDate for the DateOfBirth
5. Save the changes to the ComparisonBirth
  Open the query in Datasheet View, confirm that the results match Figure 1, then close it, saving if necessary.

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 3 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.