Solomon enterprises MS access, business and finance homework help
Other
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 file– 5 points
11. Create (steps shown on pages 14 – 16 in Learning Module 3) the following two queries using the QBE tool – 5 points
- Show raw materials that have quantities of 400 or more units and the respective suppliers.
- 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
- Show all customers by only Customer Number, Customer Name, and Customer Primary Contact.
- Show all orders by only Order Number, Delivery Address, Amount, and Truck Number.
- Show all raw materials by only Raw Material ID, Raw Material Name, and QOH.
- Show the following information for all raw materials: Raw Material ID, Raw Material Name, and Supplier Name.
- Show the following information for all orders: Order Number, Delivery Address, Amount, and Driver ID.
- Show the following information for all concrete types: Concrete Type, Type Description, Raw Material ID, and Unit.
- 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.
- 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 3 – 5 points
14. Create a complete and formatted “Supply Chain Management” report per Figure 3.27of Learning Module 3 – 25 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
