Using MIS (9th Edition)
Using MIS (9th Edition)
9th Edition
ISBN: 9780134106786
Author: David M. Kroenke, Randall J. Boyle
Publisher: PEARSON
Expert Solution & Answer
Book Icon
Chapter AE, Problem AE2.1

Explanation of Solution

a.

Creation of spreadsheet:

Step1: Open the Microsoft Excel and enter the given data in the “Ch02Ex01_U10e.docx” file.

Step2: Compute the difference between current salary and Industry Average Salary.

  • The formula for find the difference for Account department is “$B$2 – B7”.
  • Then click and drag for finding the remaining rows. Proposed increase is for those who are highlighted in green color.

Screenshot of Excel sheet

The formula for find the difference for Marketing department is “$B$3 – B7”. Then click and drag for finding the remaining rows.

Screenshot of Excel sheet

The formula for find the difference for Information Systems department is “$B$4 – B7”. Then click and drag for finding the remaining rows.

Screenshot of Excel sheet

Step3: calculating the percentage to meet Industry Average...

Explanation of Solution

b.

Analysis made in contributing employee salary decision:

The above analysis can be used for making employee salary decision, those who are below the industry average range is recommended for salary rectification...

Explanation of Solution

c.

Three ways the user can share the Access application with another:

Share data by using network folders:

  • This is the simplest option and has the least requirement. In this method, the database file is stored on a shared network drive and all users can use that file at a time.
  • Advantage – all the users can use that file simultaneously.
  • Disadvantage – the original data can be modified because of multiple users use that file simultaneously.

Share a database by using a server:

  • This method is store the tables on the network and each user has local copy of a database file which contains links to the tables, along with forms, quires, objects and reports...

Blurred answer
Students have asked these similar questions
7. Long-Distance CallsA long-distance provider charges the following rates for telephone calls: Rate Category    Rate per MinuteDaytime (6:00 a.m. through 5:59 p.m.)    $0.07Evening (6:00 p.m. through 11:59 p.m.)    $0.12Off-Peak (midnight through 5:59 a.m.)    $0.05Write a GUI application that allows the user to select a rate category (from a set of radio buttons), and enter the number of minutes of the call into an Entry widget. An info dialog box should display the charge for the call.
Name and Address The Name and Address Problem Write a GUI program that displays your name and address when a button is clicked. The program’s window should appear as the sketch on the left side of Figure 13-61 when it runs. When the user clicks the Show Info button, the program should display your name and address, as shown in the sketch on the right of the figure.
Exercise 1 Function and Structure [30 pts] Please debug the following program and answer the following questions. There is a cycle in a linked list if some node in the list can be reached again by continuously following the next pointer. #include typedef struct node { int value; struct node *next; } node; int 11_has_cycle (node *first) if (first == node *head = { NULL) return 0; first; while (head->next != NULL) { } if (head first) { return 1; } head = head->next; return 0; void test ll_has_cycle () { int i; node nodes [6]; for (i = 0; i < 6; i++) { nodes [i] .next = NULL; nodes [i].value = i; } nodes [0] .next = &nodes [1]; nodes [1] .next = &nodes [2]; nodes [2] .next = &nodes [3]; nodes [3] .next nodes [4] .next &nodes [4]; NULL; nodes [5] .next = &nodes [0]; printf("1. Checking first list for cycles. \n Function 11_has_cycle says it has s cycle\n\n", 11_has_cycle (&nodes [0])?"a":"no"); printf("2. Checking length-zero list for cycles. \n Function 11_has_cycle says it has %s…
Knowledge Booster
Background pattern image
Similar questions
SEE MORE QUESTIONS
Recommended textbooks for you
Text book image
Database System Concepts
Computer Science
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:McGraw-Hill Education
Text book image
Starting Out with Python (4th Edition)
Computer Science
ISBN:9780134444321
Author:Tony Gaddis
Publisher:PEARSON
Text book image
Digital Fundamentals (11th Edition)
Computer Science
ISBN:9780132737968
Author:Thomas L. Floyd
Publisher:PEARSON
Text book image
C How to Program (8th Edition)
Computer Science
ISBN:9780133976892
Author:Paul J. Deitel, Harvey Deitel
Publisher:PEARSON
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781337627900
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Text book image
Programmable Logic Controllers
Computer Science
ISBN:9780073373843
Author:Frank D. Petruzella
Publisher:McGraw-Hill Education