Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

7b Qry Part 3_Q1_FINAL See the chart provided (5 pts) qry_Part3_Q1_Final Job_Code . Job_Description . Hours2015 . GrossPay2015 . GrossPayPerHour2015 . Hours2016 * GrossPay2016 *

image text in transcribed
image text in transcribed
7b Qry Part 3_Q1_FINAL See the chart provided (5 pts) qry_Part3_Q1_Final Job_Code . Job_Description . Hours2015 . GrossPay2015 . GrossPayPerHour2015 . Hours2016 * GrossPay2016 * GrossPay . HoursDi * GrossPayDifference . GrossPay/ . 001 Office 11967.75 397979.46 33.25 11644.15 408802.19 35.11 -323.6 10822.73 1.86 002 Sales 12240.75 431972.96 35.29 11731.75 442132.52 37.69 -509 10159.56 2.4 EUU Travel 27671 78 31 67 710 75 31230 02 47 74 -273 75 1665 15 12 07 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) 7e 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

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_2

Step: 3

blur-text-image_3

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

Accounting Information Systems

Authors: Robert Hurt

2nd Edition

78111056, 978-0078111051

More Books

Students also viewed these Accounting questions

Question

Find each integral in Problems 5256. [xv xV16 - x dx

Answered: 1 week ago

Question

Coping with competitive pressure and sport performance anxiety

Answered: 1 week ago

Question

1. Why do we trust one type of information more than another?

Answered: 1 week ago