Best writers. Best papers. Let professionals take care of your academic papers

Order a similar paper and get 15% discount on your first order with us
Use the following coupon "FIRST15"
ORDER NOW

Solomon enterprises MS access, business and finance homework help

i can only pay $2.00

Assignment 2.2 – Final Implementation of Solomon Enterprises MS Access 2013/16 Database using your Assignment 2.1 database (named after your “LAST_NAME“) and Learning Module 3

Please submit your completed Assignment 2.2 (showing both CRM & SCM tables) MS Access 2013/16 database (named after your “LAST_NAME”) with the following database objects (Tasks 9 to 14):

9. Open your Assignment 2.1 database file (named after your “LAST_NAME“) and implement the SCM tables using Assignment 2.2 MS Excel data file and establish the relational integrity constraints per Figure 3.7 shown on page 9 of Learning Module 3. – 30 points

10. Enter information for the SCM tables using the Assignment 2.2 MS Excel data file5 points

11. Create (steps shown on pages 14 – 16 in Learning Module 3) the following two queries using the QBE tool – 5 points

  1. Show raw materials that have quantities of 400 or more units and the respective suppliers.
  2. Show all orders by only Order Number, Order Date, Delivery Address, Customer Primary Contact, Employee Last Name, and Truck Type.

12. Create the following eight queries (refer page 18 of Learning Module 3) using the QBE tool – 30 points

  1. Show all customers by only Customer Number, Customer Name, and Customer Primary Contact.
  2. Show all orders by only Order Number, Delivery Address, Amount, and Truck Number.
  3. Show all raw materials by only Raw Material ID, Raw Material Name, and QOH.
  4. Show the following information for all raw materials: Raw Material ID, Raw Material Name, and Supplier Name.
  5. Show the following information for all orders: Order Number, Delivery Address, Amount, and Driver ID.
  6. Show the following information for all concrete types: Concrete Type, Type Description, Raw Material ID, and Unit.
  7. Show the following information for all orders that have more than four cubic yards of concrete: Order Number, Order Date, Delivery Address, and Truck Number.
  8. Show the following information for all orders using Truck Number 104: Order Number, Order Date, and Delivery Address.

13. Create a report showing customer names and phone numbers per Figure 3.19 of Learning Module 35 points

14. Create a complete and formattedSupply Chain Management” report per Figure 3.27of Learning Module 325 points

Note: You need to submit your MS Access 2013/16 database (named after your “LAST NAME”)showing Tasks 1 to 14 as output for Assignment 2.2