Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Im doing a microsoft access assignment and its called creating an electronic accessaries database. Im stuck with the queries. im on question 4 and im

Im doing a microsoft access assignment and its called creating an electronic accessaries database. Im stuck with the queries. im on question 4 and im not sure how to do it.

4. Display the Sales Rep ID, Full Name, Outlet ID, Quota, and YTD Sales for all Sales Reps with a quota of more than $2,000,000 and an Outlet ID of HME 17.

5. Display the Sales Rep ID, Full Name, Outlet ID, and YTD Sales for all Sales Reps with a Sales Rep ID that begins with 6.

6. Display the Sales Rep ID, Full Name, Hire Date, and Quota for all Sales Reps with a hire date before June 1, 2004 or a quote of less than $2,000,000.

7. Display the Sales Rep ID, Full Name, Outlet ID, and YTD Sales for the top 4 Sales Reps with YTD Sales greater than $1,500,000 and less than $3,000,000.

8. Display all fields from the Sales Reps table sorted in descending order by Full Name within Outlet ID.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Introduction To Constraint Databases

Authors: Peter Revesz

1st Edition

1441931554, 978-1441931559

More Books

Students also viewed these Databases questions

Question

=+2 Why did OBI create Centers of Excellence?

Answered: 1 week ago