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 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
Get step-by-step solutions from verified subject matter experts
