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...