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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!