Information systems

Hello, I need help solving some questions using access for my accounting information systems class. I have created the database I could send the link for the dropbox it is stored. The questions are:

1. Who were the top 50 retail employees that worked for Smart-Buy? Report the city and state in which they worked, their hourly_rate, total number of hours worked, and marital status, in descending order based upon the number of hours worked.

Don't use plagiarized sources. Get Your Custom Essay on
Information systems
Just from $13/Page
Order Essay

2. Several employees believe that their paychecks were calculated incorrectly. Management has asked that you produce a report that shows all employees living in Oklahoma in the executive department that made more than $155,000 in the 3rd Quarter of 2018. Report the employee_id, last name, first name, department name, total gross salary. This report should be in alphabetical order from A – Z. 

3. Smart-Buy wants to understand how many periods their seasonal workers worked during the busy season (4th quarter). 

4. If smart-buy wants to relocate headquarters, where should they do this? HINT: It is easier to use at least 2 queries to answer this question. Take into consideration where the employees associated with headquarters (for example: accountants, IT workers, executives, and possibly others) currently live. Also consider the location of our most lucrative stores. Figure out how to provide a heatmap of the location of the most lucrative stores, however you can be creative and use other tools if you like.

Calculate your order
Pages (275 words)
Standard price: $0.00
Client Reviews
4.9
Sitejabber
4.6
Trustpilot
4.8
Our Guarantees
100% Confidentiality
Information about customers is confidential and never disclosed to third parties.
Original Writing
We complete all papers from scratch. You can get a plagiarism report.
Timely Delivery
No missed deadlines – 97% of assignments are completed in time.
Money Back
If you're confident that a writer didn't follow your order details, ask for a refund.

Calculate the price of your order

You will get a personal manager and a discount.
We'll send you the first draft for approval by at
Total price:
$0.00
Power up Your Academic Success with the
Team of Professionals. We’ve Got Your Back.
Power up Your Study Success with Experts We’ve Got Your Back.
error: Content is protected !!
Live Chat+1(978) 822-0999EmailWhatsApp

Order your essay today and save 20% with the discount code GOODESSAY