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

Want to see the full answer?

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

Want to see the full answer?

Check out a sample textbook solution

See solution

Students have asked these similar questions

1) Apply the Paint Blue algorithm discussed in class to the following Finite Automata. a a a b b a COIS-3050H-R-W01-2025WI-COMB Formal Languages & Automata a b Show the status of the Finite Automata at the conclusion of the Paint Blue Algorithm (mark the visited states with an X and only include edges that have not been followed). 2) Use the pumping lemma to prove the following language is nonregular: L= {ab} = {abbb, aabbbbbb, aaabbbbbbbbb, ...}

3) Find CFGs that for these regular languages over the alphabet Σ= {a, b}. Draw a Finite Automata e CFG. 1 COIS-3050H-R-W01-2025WI-COMB Formal anguages & Automata Is that contain the substring aba. (b) The language of all words that have an odd number letters and contains the string bb. (c) The language of all words that begin with the substring ba and contains an odd number of letters. 4) Convert the following FA into a PDA. a a S± b a a Ν Ꮓ

COIS-3050H-R-W01-2025WI-COMB Formal ministic PDA. Are the following words accepted by this Languages & Automata UI MIUSɩ that aTU I ed, indicate which state the PDA is in when the crash occurs. (a) aabbaa (b) aaabab (c) bababa Start (d) aaaabb A Accept Read₁ Push a (e) aaaaaa a b Read, Popi a a,b A Read₂ Accept A Pop₂

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

Want to see the full answer?

Check out a sample textbook solution

See 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

Want to see the full answer?

Check out a sample textbook solution

See 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

Want to see the full answer?

Check out a sample textbook solution

See 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

Want to see the full answer?

Check out a sample textbook solution

See solution

Answer 17

Ch. AE - Prob. AE1.1 Ch. AE - Prob. AE1.2 Ch. AE - Prob. AE2.1 Ch. AE - Prob. AE2.2 Ch. AE - Prob. AE3.1 Ch. AE - Prob. AE3.2 Ch. AE - Prob. AE4.1 Ch. AE - Prob. AE4.2 Ch. AE - Prob. AE5.1 Ch. AE - Prob. AE5.2

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

Want to see the full answer?

Chapter AE Solutions

b. Use of data for salary increase decision:

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