Solved:
Answered by AI, Verified by Human Experts
Modify this query to show only medical insurance plans. Add criteria to the InsuranceType field to return only records where the classification is Medical. Run the query. A) Go to the query design view and add a filter to the InsuranceType field with the "Medical" value. B) Delete the query and create a new one from scratch with the specified criteria. C) Use the "Sort and Filter" options in the query results to filter for medical insurance plans. D) Create a new query without any modifications.
Modify this query to show only medical insurance plans. Add criteria to the InsuranceType field to return only records where the classification is Medical. Run the query. A) Go to the query design view and add a filter to the InsuranceType field with the "Medical" value. B) Delete the query and create a new one from scratch with the specified criteria. C) Use the "Sort and Filter" options in the query results to filter for medical insurance plans. D) Create a new query without any modifications.
Final answer:The correct answer is A) Go to the query design view and add a filter to theInsuranceTypefield with the "Medical" value.Explanation:The correct answer is A) Go to thequery designview and add a filter to the InsuranceType field with the "Medical" value. By adding a filter with the criteria "Medical" to the InsuranceType field in the query design view, you are specifying that you only want to retrieve records where the classification is Medical. This will effectively show only medical insurance plans in the query results. The other options mentioned (B, C, and D) are not necessary for achieving the desired result in this case.Learn more about Modifying a query to show only medical insurance plans here:brainly.com/question/33946700#SPJ11...