Chapter AE, Problem AE2.2

Explanation of Solution

a.

Results for the above query:

1) List the names, department and salary of all employees earning more than 100000:

Open the given an Access database which contains a table of employee data.

Screenshot of MS Access

• Select “CREATE” option from the menu bar and then choose “Query Design” from it.
• Close the “Show Table” dialog box and click “SQL View” from the top left corner.
• A query form gets displayed as shown below:

SELECT Name, Department, Salary

FROM EMPLOYEE

WHERE Salary > 100000;

• After writing the query save it by pressing “Ctrl+S” and name it as “Query 1”.
• Right click “Query 1” and then choose “Datasheet View” to view the result.

Screenshot of MS Access

2)

List the name and specialty of all employees in the Marketing department:

• Create another “Query design” and write the below “Query 2” query.

SELECT Name, Specialty

FROM Employee

WHERE Department = "Marketing";

• After writing the query save it by pressing “Ctrl+S” and name it as “Query 2”.
• Right click “Query 2” and then choose “Datasheet View” to view the result.

Screenshot of MS Access

3)

Computation of average, maximum, minimum salary of employees in the company:

• Create another “Query design” and write the below “Query 3” query.

SELECT AVG(Salary) AS Average, MAX(Salary) AS Maximum, MIN(Salary) AS Minimum

FROM Employee;

• After writing the query save it by pressing “Ctrl+S” and name it as “Query 3”.
• Right click “Query 3” and then choose “Datasheet View” to view the result.

Screenshot of MS Access

Explanation of Solution

b. Use of data for salary increase decision:

Manager will coming to know the average salary for employees in every d...

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