Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Create a new query in Design View and select all of the fields from the Surveys table.Add criteria to select only those records with any

Create a new query in Design View and select all of the fields from the Surveys table.Add criteria to select only those records with any date in June 2021. Change the query into a Delete query. Run the query, which should delete eight records from the Surveys table. Save the query with the name DeleteJune2021 and then close it.[Hint: The month of June has 30 days. Use the AND keyword in your criteria.]Create a new query in Query Design View and select the ManagerID field from the Properties table. Add criteria to select only those records with a ManagerID field value of3. Change the query into an Update query and update the ManagerID field value to 6.Run the query to update 53 records, save it with the name UpdateManager, and then close it.Open the PropertiesWithNo Surveys query in Query Design View and delete the 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

Learning MySQL Get A Handle On Your Data

Authors: Seyed M M Tahaghoghi

1st Edition

0596529465, 9780596529468

More Books

Students also viewed these Databases questions

Question

9-9. Is the hard sell approach unethical? Why or why not? [LO-2]

Answered: 1 week ago

Question

3. Explain the process of how loans undergo securitization. LOP8

Answered: 1 week ago