Answered step by step
Verified Expert Solution
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 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 DeleteJune and then close itHint: The month of June has 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 of Change the query into an Update query and update the ManagerID field value to Run the query to update records, save it with the name UpdateManager, and then close itOpen 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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started