CourseLover

(12)

$10/per page/Negotiable

About CourseLover

Levels Tought:
Elementary,Middle School,High School,College,University,PHD

Expertise:
Algebra,Applied Sciences See all
Algebra,Applied Sciences,Architecture and Design,Art & Design,Biology,Business & Finance,Calculus,Chemistry,Engineering,Health & Medical,HR Management,Law,Marketing,Math,Physics,Psychology,Programming,Science Hide all
Teaching Since: May 2017
Last Sign in: 188 Weeks Ago, 1 Day Ago
Questions Answered: 27237
Tutorials Posted: 27372

Education

  • MCS,MBA(IT), Pursuing PHD
    Devry University
    Sep-2004 - Aug-2010

Experience

  • Assistant Financial Analyst
    NatSteel Holdings Pte Ltd
    Aug-2007 - Jul-2017

Category > Engineering Posted 27 Jun 2017 My Price 10.00

create a query using the qbe tool to find

Question description

 

Assignment 2.1 - Implementation of Solomon Enterprises MS Access 2013/16 Database

Please 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 points

2. Enter data for all the tables using Assignment 2.1 MS Excel data file – 5 points

3. Create a query using the QBE tool to find the “Gross Sales” – 5 points

4. Create a query using the QBE tool to find “Triple A Homes favorite driver” (refer to Chapter 6 slide 34) – 10 points

5. 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 points

6. Create a query using the QBE tool to find “Best and Worst Revenue Generating Customers” – 15 points

7. Create a query using the QBE tool to find "Best and Worst Revenue Generating Concrete Types ” – 15 points

8. Create a query using the QBE tool to find "Customers and Concrete types that have Generated Revenue (ascending order) above $10,000” – 15 points

Note: 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

Answers

CourseLover
(12)
Status NEW Posted 27 Jun 2017 04:06 PM My Price 10.00

----------- He-----------llo----------- Si-----------r/M-----------ada-----------m -----------Tha-----------nk -----------You----------- fo-----------r u-----------sin-----------g o-----------ur -----------web-----------sit-----------e a-----------nd -----------acq-----------uis-----------iti-----------on -----------of -----------my -----------pos-----------ted----------- so-----------lut-----------ion-----------. P-----------lea-----------se -----------pin-----------g m-----------e o-----------n c-----------hat----------- I -----------am -----------onl-----------ine----------- or----------- in-----------box----------- me----------- a -----------mes-----------sag-----------e I----------- wi-----------ll

Not Rated(0)