Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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.

image text in transcribed
image text in transcribed
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. 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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Anxiety Audit

Authors: Lynn Lyons

1st Edition

0757324258, 978-0757324253

More Books

Students also viewed these Accounting questions

Question

analyze file formats and basic digital design rules.

Answered: 1 week ago