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

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

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 Mathematics Questions!