Access Homework

Create a Make Table query in the a04ch08_grader_pc_Marketing1.accdb database based on the tblCampaign and tblMailing tables.
• The new table should include MailingID, CustomerID, and Redeemed from the tblMailing and CampaignName, CampaignType, StartDate, EndDate, DiscountCode, Department, and Details from the tblCampaign.
• Criteria for Department should be Turquoise Oasis Spa. Clear the Show check box.
• Name the new table tblCampaign and add the table to the a04ch08_grader_pc_Spa2_LastFirst database.
• Run the query, and then save the query as qryMakeTable.
• Close the a04ch08_grader_pc_Marketing1 database.