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.

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

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.

Similar questions