You need to create a single table query to return visits where a sample is left...

 

Transcribed Image Text:

You need to create a single table query to return visits where a sample is left and a multitable query including who was visited, what medications were discussed, and if a sample was left. k. Create a single table query for tblVisits. Display all fields and set the criteria to search where Sample Left is Yes. Save the query as qrySampleLeft. I. Create a multitable query that includes all three tables. Include the following fields: a. ID (tblVisits) b. Date (tblVisits) c. First Name (tblSalesRep) d. Last Name (tblSalesRep) e. Dr Visited (tblVisits) f. MedName (tbIMedication) g. MedDosage (tbIMedication) h. Sample Left (tblVisits) m. Set the criteria to only show visits that occurred after 2/14/18. n. Save the query as qryFullReport. o. Save and close the file. Based on your instructor's directions submit a02_exam_chap_LastFirst. You need to create a single table query to return visits where a sample is left and a multitable query including who was visited, what medications were discussed, and if a sample was left. k. Create a single table query for tblVisits. Display all fields and set the criteria to search where Sample Left is Yes. Save the query as qrySampleLeft. I. Create a multitable query that includes all three tables. Include the following fields: a. ID (tblVisits) b. Date (tblVisits) c. First Name (tblSalesRep) d. Last Name (tblSalesRep) e. Dr Visited (tblVisits) f. MedName (tbIMedication) g. MedDosage (tbIMedication) h. Sample Left (tblVisits) m. Set the criteria to only show visits that occurred after 2/14/18. n. Save the query as qryFullReport. o. Save and close the file. Based on your instructor's directions submit a02_exam_chap_LastFirst.

Answer rating: 100% (QA)

k qrySampleLeft SELECT FROM tblVisits WHERE Sample LeftYES l SELECT vI... View the full answer