Download the City Hospital database,Ch07Ex02. Write a query that sort’s registrants by the type of seminar they have attended.Include the session date as well as attendee information.Modify the query to identify registrants who attended a Knee Replacement seminar. Use the report wizard to create a report that lists the session dates and the names and phone numbers of those who have attended Knee Replacement seminars. This report serves as a “patient contact sheet” that hospital staff will use to call previous attendees to invite them to attend the new seminar. How many patients are listed on the report? Review the attendees table. Is there additional patient information the hospital could collect that may be useful for future marketing campaigns?

  • CreatedJanuary 03, 2015
  • Files Included
Post your question