Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1 . Copy the Surveys table and paste both the structure and the data back into the database as a table using the name BackupSurveys.

1. Copy the Surveys table and paste both the structure and the data back into the database as a table using the name BackupSurveys.
2. 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 a survey date in June 2021. Change the query into a Make Table query using June2021 as the new table name. Run the query, which should paste eight records into the new table. Save the query with the name MakeJune2021 and then close it.[Hint: The month of June has 30 days. Use the AND keyword in your criteria.]
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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Logidata+ Deductive Databases With Complex Objects Lncs 701

Authors: Paolo Atzeni

1st Edition

354056974X, 978-3540569749

More Books

Students also viewed these Databases questions