Management Information System
\nAccess Lab Examination
\n2022-3-15
\n[General Guidance]
\nWork on the provided Access file, \u201cMIS Lab Exam 2022-3-15.accdb\u201d to solve the problems below. When you have finished the lab works, please post the result on the Google Classroom by 9 pm, 3-15-2022. Later submission will have some points subtracted.
\n1.\tOn the table SalesOrderHeader, set a validation rule such that OrderDate should be earlier than DueDate and provide an error message when the rule is not kept during the data entry on the OrderDate and DueDate.<\/p>\n
2.\tOn the table StateProvince, set up a table-based Lookup table for the data field CountryRegionCode that displays the names of the table CountryRegion, instead of the abbreviated CountryRegionCode.<\/p>\n
3.\tUsing the table SalesOrderHeader, provide grand total of the total due (TotalDue) at the bottom of the worksheet display of SalesOrderHeader.<\/p>\n
4.\tUsing the table SalesOrderHeader, set up a Question Assignment, SalesQ4_Question Assignment, that displays SalesOrderID, OrderDate, TotalDue, for the orders made in the fourth quarter of year 2001, that is, from 10\/1\/2001 to 12\/31\/2001 inclusive. \u201cInclusive\u201d means dates 10\/1\/2001 and 12\/31\/2001 are included in the Q4 range.<\/p>\n
5.\tUsing the table SalesOrderHeader, we want to know how much each SalesPerson has sold in year 2001. Set up a Question Assignment, SalesPerformance_Question Assignment, that displays SalesPersonID and TotalSale that is sum of SubTotal in the year 2001 in the Currency format and in descending order.<\/p>\n
6.\tUsing table SalesOrderDetail and table Product, create a Question Assignment ProductSales_Question Assignment that displays ProductID (from table Product), Name (from table Product), LineTotal (from table SalesOrderDetail) in descending order, including the products that didn\u2019t make any sale even. You will need Left Join or Right Join to display all the products in the table Product.<\/p>\n
7.\tCreate a Question Assignment, SalesByStateProvince_Question Assignment that displays StateProvinceCode of customers (from table StateProvince) and \u201cSumOfTotalDue\u201d that is the sum of TotalDue (from table SalesOrderHeader) in descending order and in currency format for each StateProvinceCode. Use Relationship Diagram to find related tables for the Question Assignment.<\/p>\n
8.\tUsing OrderedItems Question Assignment, set up a crosstab, SaleByCustomerAndProductCategory_Crosstab that displays sum of sale amount ([UnitPrice]*[OrderQty]) by each Customer and each ProductCategory, and SaleTotal that is sum of [UnitPrice]*[OrderQty] per each customer.<\/p>\n","protected":false},"excerpt":{"rendered":"
Management Information System Access Lab Examination 2022-3-15 [General Guidance] Work on the provided Access file, \u201cMIS Lab Exam 2022-3-15.accdb\u201d to solve the problems below. When\u2026<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[479,172,478],"tags":[181,21,535,31,527,534,536,526,532,533,531,530,525,528,27,529],"class_list":["post-12694","post","type-post","status-publish","format-standard","hentry","category-nursing-course-hero","category-nursing-study-bay","category-nursing-study-pool","tag-buy-psychology-essay","tag-nursing-assignment-writing-service-uk","tag-nursing-essay-writing","tag-nursing-essay-writing-service","tag-nursing-essay-writing-service-uk","tag-nursing-essay-writing-uk","tag-nursing-essays-online","tag-nursing-essays-uk","tag-psychology-assignment-writing-service","tag-psychology-essay-pro-top-writers","tag-psychology-essay-writing-service-uk","tag-psychology-pro-papers","tag-sociology-essay-pro-research","tag-sociology-peachy-essay-writers","tag-write-my-nursing-essay","tag-writers-per-hour-sociology-writers"],"_links":{"self":[{"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/posts\/12694","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/comments?post=12694"}],"version-history":[{"count":0,"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/posts\/12694\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/media?parent=12694"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/categories?post=12694"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/tags?post=12694"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}