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

Question

"Do not use AI tools. Solve the problem by hand on paper only and upload a photo of your handwritten solution."

Answer 1

Expert Solution & Answer

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

Expert Solution & Answer

Trending nowThis is a popular solution!

See solution

Check out sample textbook solution

Students have asked these similar questions

"Do not use AI tools. Solve the problem by hand on paper only and upload a photo of your handwritten solution."

| √ (r² + r + 1)e^ dr

Ensure you answer the question asked at the end of the document. Do not just paste things without the GNS3 console outputs

Answer 2

Expert Solution & Answer

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

Expert Solution & Answer

Trending nowThis is a popular solution!

See solution

Check out sample textbook solution

Answer 3

Expert Solution & Answer

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

Expert Solution & Answer

Trending nowThis is a popular solution!

See solution

Check out sample textbook solution

Answer 4

Expert Solution & Answer

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

Expert Solution & Answer

Trending nowThis is a popular solution!

See solution

Check out sample textbook solution

Answer 5

Expert Solution & Answer

Answer 6

Expert Solution & Answer

Answer 7

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

Answer 8

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

Answer 9

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

Answer 10

Explanation of Solution

b. Use of data for salary increase decision:

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

Answer 11

Explanation of Solution

b. Use of data for salary increase decision:

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

Answer 12

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

Answer 13

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

Answer 14

Expert Solution & Answer

Answer 15

Expert Solution & Answer

Answer 16

Trending nowThis is a popular solution!

See solution

Check out sample textbook solution

Answer 17

Trending nowThis is a popular solution!

See solution

Check out sample textbook solution

Answer 18

Trending nowThis is a popular solution!

See solution

Check out sample textbook solution

Answer 19

Trending nowThis is a popular solution!

Answer 20

Trending nowThis is a popular solution!

Answer 21

Trending nowThis is a popular solution!

Answer 22

Trending now

Answer 23

This is a popular solution!

Answer 24

See solution

Check out sample textbook solution

Answer 25

Ch. AE - The spreadsheet in Microsoft Excel file...Ch. AE - Prob. AE1.2 Ch. AE - Prob. AE2.1 Ch. AE - Prob. AE2.2 Ch. AE - Prob. AE3.1 Ch. AE - In this exercise, you will learn how to create a...Ch. AE - Prob. AE4.1 Ch. AE - Prob. AE4.2 Ch. AE - In some cases, users want to use Access and Excel...Ch. AE - Prob. AE5.2

Solution Summary: The author demonstrates how MS Access creates a query form for each employee's name, department, and salary.

Explanation of Solution

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

Chapter AE Solutions

Solution Summary: The author demonstrates how MS Access creates a query form for each employee's name, department, and salary.

Explanation of Solution

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

Chapter AE Solutions

b. Use of data for salary increase decision:

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