Question: 3. Create a new Append query in Design View with the following instructions: a. Select all of the fields from the from the Consultant table.

3. Create a new Append query in Design View with the following instructions: a. Select all of the fields from the from the Consultant table. b. Add criteria to select only those records greater than or equal to $70,000 and less than $80,000 in the Salary field. C. Append the records to the HighSalaries table. d. Run the query which should append 13 records into the HighSalaries table. Save the query with the name AppendHighSalaries and then close it. e. Open the HighSalaries table to review all 16 records as shown in Figure 1. Close the HighSalaries table
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
