Question: In Query Design view, create a Make Table query that selects all the fields from the Homeowners table in the same order that they are

 In Query Design view, create a Make Table query that selects

In Query Design view, create a Make Table query that selects all the fields from the Homeowners table in the same order that they are listed in the field list. Select all the fields individually for the design grid; do not use the () asterisk. a. Add criteria to select only those records where the PropertyDamage field value is greater than or equal to 750000 . b. In the Make Table dialog box, assign the name HighDamageAmts to the new table. Save the query using MakeHighDamageAmts as the name, run it, and then close the query. The new HighDamageAmts table should contain five records

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!