Question: Part III: Analyzing the Data (25 points ) Instructions: Build a query that will mimic the chart provide (reproduced below). You will need to create

Part III: Analyzing the Data (25 points ) Instructions: Build a query that will mimic the chart provide (reproduced below). You will need to create formulas and format as per the case study instruction. 2015 2015 2016 2016 gross Gross pay Job Job 2015 gross gross pay 2016 gross pay per Hours Gross pay per hour code description hours pay per hour hours pay hour difference difference difference 2015 2015 gross 2016 2016 Gross Gross pay Employee Employee 2015 gross pay per 2016 gross gross pay Hours pay per hour Job code number name hours pay hour hours pay per hour difference |difference difference 01 01 2 01 01 etc. 7a Qry_Part 3_Q1_2015Data (10 pts) You will include the following fields: Job Code (from your CleanJob Code Query) Job Description . . Hours : Expression to compute total hours GrossPay2015: Expression to compute gross pay Create new query and repeat steps for 2016 data. 7b Qry Part 3_Q1_FINAL See the chart provided (5 pts) Job Code . Job Description . tours2015 . GrossPay2015 . GrossPayPerHour205 . Hours2016 . GrossPay2016 . GrossPay . HoursDi . GrossPayDifference . GrossPayl . Office 11967.75 397979.46 33.25 11644.15 404802.39 -123.6 10822-73 DOZ Sales 12240.75 431972.96 35.29 11731.75 442132.52 37.69 509 10159.56 2.4 23474 79 34739 97 13 M 7c Qry_Part 3_Q2_2015Data (5 pts) You will include the following fields: Job Code Employee Number . Employee Name Hours: Expression to compute total hours (use criteria in design view to show greater than 0) . . Gross Pay: Expression to compute gross pay (use criteria in design view to show greater than 0) Create new query and repeat steps for 2016 data. 7d Qry Part 3_Q2_FINAL See the chart provided (5 pts) Ze Write a memo to Noah about what you have learned. Make sure you include the tables (you will need to reproduce as a word table or excel table) in your memo. Discuss any discrepancies that you observed and

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 Accounting Questions!

Part III: Analyzing the Data (25 points) Instructions: Build a query that will mimic the chart provide (reproduced below). You will need to create formula: and format as per the case study...

Part II: Transforming the Data (25 points) Instructions: Load the data as per the Case Study instruction and build the appropriate relationships between the tables. Write two queries that extracts...

I would like assistance to see if I filled out the attached Form 1040 Schedule C correctly. I am attaching Schedule C, Schedule C Instructions, and the instructions with the information to work the...

Name: Date: 2.5 Assignment: Analyzing Functions, Data, and Quadratics Instructions Answer the five questions provided below. Answers can either be typed or handwritten. Be sure to write neatly and...

Dong Lee Math-138 Professor Deshpande 10-16-16 Project Part 2 Research Proposal: Introduction: The first variables I plan to study are the hours you spend on the smartphone daily and the monthly...

Study Guide Healthcare Statistics By Jacqueline K. Wilson, RHIA About the Author Jacqueline K. Wilson is a Registered Health Information Administrator (RHIA) who has more than ten years of experience...

Assignment #8: Business Report Proposal Outline Writing a Successful Outline Components of an Outline: Title (should be the title of your paper) Major headings according to major sections of your...

Welcome! Please read this page (in particular) very carefully. Instructions You need to understand how to send your assignments (deliverables) to your instructor. The tabs (bottom of each sheet) in...

What do the terms host cell and host range mean?

The following table shows the number of various foreign currencies required to buy a U.S. dollar on April 12, 2008, and April 12, 2013. Use this table to answer the questions that follow. Australian...

C corporations with annual average gross receipts of $ 3 0 million or more are allowed to use the cash method of accounting for at least the first two years of their existence. Group of answer...

Can I get help with this question ? Do you think intangible asset balances can be manipulated to benefit a company? How? Why would someone want to manipulate these balances, if they can?