<\/p>\n
This is a two part lab assignment. In part one, you will create a database and two tables; a Sales Rep Table and a Sales Rep Manager Table. Input data forms for each table will be created with the two tables populated with data listed in Table 1 and 2 below. A relationship between will be established between the two tables based on Sales Manager ID with a query set up to show Sales Rep Manager and the assigned Sales Rep. In Part Two, you will add two more tables to the database created in Part One and establish relationships between the four tables, completing a query, report, and exporting the data to an Excel Workbook.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"
This is a two part lab assignment. In part one, you will create a database and two tables; a Sales Rep Table and a Sales Rep Manager Table. Input data forms for each table will be created with the two tables populated with data listed in Table 1 and 2 below. A relationship between will […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","_joinchat":[]},"categories":[1],"tags":[],"_links":{"self":[{"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/posts\/180761"}],"collection":[{"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/comments?post=180761"}],"version-history":[{"count":0,"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/posts\/180761\/revisions"}],"wp:attachment":[{"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/media?parent=180761"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/categories?post=180761"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/tags?post=180761"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}