Top Research Professionals
The research experts and assignment help team consists exclusively of highly qualified graduate writers, each professional with in-depth subject matter expertise and significant experience in custom academic writing.
Boost Your Final Grades By Ordering Custom Writing Help!
For similar papers and sample answers; with a few clicks, Order your research paper, thesis, dissertation writing and other assignment help services
Posted: March 16th, 2022
Management Information System
Management Information System
Access Lab Examination
2022-3-15
[General Guidance]
Work on the provided Access file, “MIS Lab Exam 2022-3-15.accdb” 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.
1. On 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.
2. On 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.
3. Using the table SalesOrderHeader, provide grand total of the total due (TotalDue) at the bottom of the worksheet display of SalesOrderHeader.
4. Using the table SalesOrderHeader, set up a query, SalesQ4_query, 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. “Inclusive” means dates 10/1/2001 and 12/31/2001 are included in the Q4 range.
5. Using the table SalesOrderHeader, we want to know how much each SalesPerson has sold in year 2001. Set up a query, SalesPerformance_query, that displays SalesPersonID and TotalSale that is sum of SubTotal in the year 2001 in the Currency format and in descending order.
6. Using table SalesOrderDetail and table Product, create a query ProductSales_query that displays ProductID (from table Product), Name (from table Product), LineTotal (from table SalesOrderDetail) in descending order, including the products that didn’t make any sale even. You will need Left Join or Right Join to display all the products in the table Product.
7. Create a query, SalesByStateProvince_query that displays StateProvinceCode of customers (from table StateProvince) and “SumOfTotalDue” 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 query.
8. Using OrderedItems query, 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.
Study Notes, Research Topics & Assignment Examples: How are representations of gender roles in the family presented in Boots »Accounting Journal SummaryWhy Choose our Custom Writing Services
We prioritize delivering top quality work sought by college students.
Discounted Pricing
Our custom writing services maintain the highest quality while remaining affordable for students. Our pricing for research papers, theses, and dissertations is not only fair considering the superior quality but also competitive with other writing services.
0% Similarity Index
We guarantee plagiarism-free, human-written content. Every product is assured to be original and not AI-generated. Our writers, tutors and editors are research experts who ensures the right formating and citation sytles are followed. To note, all the final drafts undergo rigorous plagiarism checks before delivery for submission to ensure authenticity for our valued customers.
How it works
When you decide to place an order with Dissertation Help, here is what happens: