Question: 3 . Create a new query in Design View and individually select all of the fields from the Surveys table. Add criteria to select only

3. Create a new query in Design View and individually select all of the fields from the Surveys table. Add criteria to select only those records with any date in July 2021. Change the query into an Append query and select the June2021 table to append the records into. Run the query, which should append 46 records into the June2021 table. Save the query with the name AppendJuly2021 and then close it. Rename the June2021 table to be JuneJuly2021 and then open it to review all 54 records as shown in Figure 1. Close the JuneJuly2021 table. [Hint: The month of July has 31 days. Use the AND keyword in your criteria.]

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