Skip to content

this assignment was done already by tutor on this site but h

    this assignment was done already by tutor on this site but he don’t knows how follow instruction.Assignment 2.10%5%Assignment 2.1 (CRM)Oct 16, 20160/100Re-do Assignment 2.1! (100 points)from Assignments$1.00THIS ASSIGNMENT SHOULD BE FREE SINCE AS I HAVE ALREADYPAID FOR..Assignment 2.1 – Implementation of Solomon Enterprises MS Access 2013/16 DatabasePlease submit the Solomon Enterprises MS Access 2013/16database — named after your LAST_NAME — you created in BC207 class room on 10/05 & 10/10 with the following database objects (Tasks 1 to 8):1. Create Employee, Customer, Concrete Type, Truck, and Order tables using MS Access 2013/16 and establish relational and business-critical integrity constraints – 20 points2. Enter data for all the tables using Assignment 2.1 MS Excel data file – 5 points3. Create a query using the QBE tool to find the “Gross Sales” – 5 points4. Create a query using the QBE tool to find “Triple A Homes favorite driver” (refer to Chapter 6 slide 34) – 10 points5. Create a query using the QBE tool to find “Total Amount of Concrete (in cubic yards and sorted in ascending order) Sold for all Concrete Types” – 15 points6. Create a query using the QBE tool to find “Best and Worst Revenue Generating Customers” – 15 points7. Create a query using the QBE tool to find ‘Best and Worst Revenue Generating Concrete Types ” – 15 points8. Create a query using the QBE tool to find ‘Customers and Concrete types that have Generated Revenue (ascending order) above $10,000” – 15 pointsNote: You need to submit (upload) one electronic file — Solomon Enterprises MS Access 2013/16 database — named after your LAST_NAME — showing Tasks 1 to 8 as output for Assignment 2.1.

    Do You Need A Similar Assignment Done For You From Scratch? We Have Qualified Writers To Help You. We Assure You An A+ Quality Paper That Is Free From Plagiarism. Order Now For An Amazing Discount!

    Very professional support! Highly recommended.

    Amos

    Researched complicated topic and delivered report by the requested deadline. The paper is of a high standard reflecting careful research and clear assessments. I recommend iLecturers.com.com

    Daria K

     

    It’s a 5 start for me. Excellent research and writing. The paper reflects a careful assessment of scientific information.

    Mahone

     

    With Gib’s reflection, they wrote a really specific essay. Very well written, containing all of the languages I required and excellent references. The writer follows my instructions and writes clearly in English.

    Mario G

     

    I am so grateful and I am 100% happy with your work.

    Julie

     

    A fantastic piece of work 👏. The writer demonstrated full knowledge of the topic and applying the relevant provided material. Well done.

    Dieny