I need help creating these queries in MS Access please!

we are given the outputs but i need to know how to get to these outputs

i was given these three tables and asked to write the following queries.

1. Write a query in MS Access to display all the information of the employees.

2. Write a query in MS Access to find the salaries of all employees.

3. Write a query in MS Access to display the unique designations for the employees

4. Write a query in MS access to list the emp_name, and salary is increased by 15% and expressed as a no. of dollars.

5. Write a query in MS Access to produce the output of employees name and job name as a format of "Employee & Job"

5 Refresh Find e Remove Sort Y All Sort & Filter Records Find Query1 X Query2 x 1 Tbl_Department X dep_id dep_name dep_location - Click to Add 1001 FINANCE HARTFORD 2001 AUDIT NEW HAVEN 3001 MARKETING NEW BRITAIN 4001 PRODUCTION BERLIN An Y I Ascending - 66925 Selection - New Totals Replace 11 Descending Filter Advanced Spelling Save Refresh Go To Find B1A-2 2 mesort Y loggie 2. = = = - All- x Delete More Select Sort & Filter Recordi Find Test Formatting Query! XQuery2 X Tbl Department XTl Employee Updated XL Salary X emp id emp_name.job_name manager id hire date salary - commission- dep_id - grade Click to Add - 53679 SANDRINE CLERK 69052 12/18/1930 $900.00 2001 64989 ADELYN SALESMAN 56928 2/20/1991 S1,700.00 $400.00 3001 3 65271 WADE SALESMAN 2/22/1991 $1,350.00 $600.00 3001 2 65646 JONAS MANAGER 68319 4/2/1991 $2,957.00 2001 . 66564 MADDEN SALESMAN 66928 9/28/1991 $1,350.00 $1,500.00 3001 2 66928 BLAZE MANAGER 68319 5/1/1991 $2,750.00 3001 4 67832 CLARE MANAGER 68319 5/9/1991 $2,550.00 1001 4 67858 SCARLET ANALYST 65646 4/19/1997 $3.100.00 2001 4 68319 KAYLING PRESIDENT 11/18/1991 $6,000.00 1001 5 68454 TUCKER SALESMAN 66928 9/8/1991 $1,600.00 3001 3 68735 ADNRES CLERK 67858 5/23/1997 $1,200.00 2001 1 69000 JUUUS CLERK 56928 12/3/1991 $1.050.00 3001 1 69062 FRANK ANALYST 65546 12/3/1991 $3,100.00 2001 4 69324 MARKER CLERK 57832 1/23/1992 $1,400,00 1001 2 0 2 / 8 100% + 900 3. Output Write a query in MS Access to display the unique designations for the employees. job name ANALYST ANALYST CLERK CLERK CLERK CLERK MANAGER MANAGER MANAGER PRESIDENT SALESMAN SALESMAN SALESMAN SALESMAN job_name SALESMAN CLERK MANAGER PRESIDENT ANALYST JONAS AC-340 Accounting Information Systems Hands-on MS Access Practice Lab 4. Write a query in MS Access to list the emp_name, and salary is increased by 15% and expressed as no. of Dollars. Output job name Salary KAYLING $5,900 BLAZE $3,163 CLARE $2,933 $3,401 ADELYN $1,955 WADE $1,553 MADDEN $1,553 TUCKER $1,840 ADNRES $1,380 JULIUS $1,208 MARKER $1,610 SCARLET $3,565 FRANK $3,565 SANDRINE $1,035 5. Write a query in MS Access to produce the output of employees name and job name as a format of "Employee & Job." Output Cengage. Courses I Joey WSU E Google Docs 2 / 8 100% + 5. Output TUCKER $1,340 ADNRES $1,380 JULIUS $1,208 MARKER $1,610 SCARLET $3,565 FRANK $3,565 SANDRINE $1,035 Write a query in MS Access to produce the output of employees name and job name as a format of "Employee & Job. Employee & Job KAYLING PRESIDENT BLAZE MANAGER CLARE MANAGER JONAS MANAGER ADELYN SALESMAN WADE SALESMAN MADDEN SALESMAN TUCKER SALESMAN ADNRES CLERK JULIUS CLERK 6. Write a query in MS Access to produce the output of employees as follows Employee JONAS(manager) Output Employee KAYLING president) BLAZE manager CLARE(manager JONAS manager ADELYN(Salesman WADEisalesman) MADDEN Salesman TUCKER Salesman) ADNRES clerk JULIUSicer AC-340 Accounting Information Systems a QW-D COACH W Ausgrein Y nocending selection C Data Database folle edetable PT XC CON V Part OC Il escending Advanced f A XD Cabod All Access Objects et TXT 2 ded depretep locatie Add Tables 100 LANCI HARTFORD 2001 AUDIT NEW HAVEN 301 MARKETING NEW BRITAIN TH 0 PRODUCTION BERUN TH Que Y condi salary Home Create tena Database Tools Table table Pee what you want to do X 17 Section New Replace Cali HE View Coy Posle Speling 1. Dende Adria Rech fund BTUALE re A X Date - Me S- Cound So Twing The de XS X All Access Objects. Bet X mod osion- en mejob name manager dhire date dep_id= 10 told 23678 SANDRINE CLE 02 12/11/ $900.00 200 Tales NADELN SALESMAN 20 3/20/1991 $1,200.00 S400.00 3001 I WADE SALISMAN 6692 2/22/17 $1,150.00 600.00 3001 2 Tree JONAS MANAGER 31 4/3/1991 $2.957.00 2001 4 T. SA MADDEN SALESMAN 9/2010 SL150,00 $1.500.00 3001 2 Cum MATE MANAGER 1/1991 220.00 2001 4 672 CLARI MANAGER 119 0.00 1001 GS SCARLET ANALYST 4/1997 $1,100.00 2003 4 1 KAVUNO PRESIDENT 11/1991 1.000.00 1001 5 6811A TUCKEN SALESMAN 60 9/11 1.000.00 3001 3 7 ADRES CLERK 199) $1,200.00 2001 1 UUS 12/19 51.000.00 1001 1 O PRANE ANALYST 65665 12/1/1991 $1,100.00 2005 4 MAREER CLERK 62 1/2012 STAKLO 1001 2 0 4 CUK GACH W Air Date CDC WA ) Teme File Home Chi utabase Toch Help Table Field 9 N D Y dumine on View F Descending SA Save A X DE Un Clo All Access Objects Butant X 30 Top Stary macab $800.00 L.00 $12.00 $1,300.00 $1,SOLDO $2,100.00 $2.501.00 51,100.00 $3.101.00 59.00 3 5 Refresh Find e Remove Sort Y All Sort & Filter Records Find Query1 X Query2 x 1 Tbl_Department X dep_id dep_name dep_location - Click to Add 1001 FINANCE HARTFORD 2001 AUDIT NEW HAVEN 3001 MARKETING NEW BRITAIN 4001 PRODUCTION BERLIN An Y I Ascending - 66925 Selection - New Totals Replace 11 Descending Filter Advanced Spelling Save Refresh Go To Find B1A-2 2 mesort Y loggie 2. = = = - All- x Delete More Select Sort & Filter Recordi Find Test Formatting Query! XQuery2 X Tbl Department XTl Employee Updated XL Salary X emp id emp_name.job_name manager id hire date salary - commission- dep_id - grade Click to Add - 53679 SANDRINE CLERK 69052 12/18/1930 $900.00 2001 64989 ADELYN SALESMAN 56928 2/20/1991 S1,700.00 $400.00 3001 3 65271 WADE SALESMAN 2/22/1991 $1,350.00 $600.00 3001 2 65646 JONAS MANAGER 68319 4/2/1991 $2,957.00 2001 . 66564 MADDEN SALESMAN 66928 9/28/1991 $1,350.00 $1,500.00 3001 2 66928 BLAZE MANAGER 68319 5/1/1991 $2,750.00 3001 4 67832 CLARE MANAGER 68319 5/9/1991 $2,550.00 1001 4 67858 SCARLET ANALYST 65646 4/19/1997 $3.100.00 2001 4 68319 KAYLING PRESIDENT 11/18/1991 $6,000.00 1001 5 68454 TUCKER SALESMAN 66928 9/8/1991 $1,600.00 3001 3 68735 ADNRES CLERK 67858 5/23/1997 $1,200.00 2001 1 69000 JUUUS CLERK 56928 12/3/1991 $1.050.00 3001 1 69062 FRANK ANALYST 65546 12/3/1991 $3,100.00 2001 4 69324 MARKER CLERK 57832 1/23/1992 $1,400,00 1001 2 0 2 / 8 100% + 900 3. Output Write a query in MS Access to display the unique designations for the employees. job name ANALYST ANALYST CLERK CLERK CLERK CLERK MANAGER MANAGER MANAGER PRESIDENT SALESMAN SALESMAN SALESMAN SALESMAN job_name SALESMAN CLERK MANAGER PRESIDENT ANALYST JONAS AC-340 Accounting Information Systems Hands-on MS Access Practice Lab 4. Write a query in MS Access to list the emp_name, and salary is increased by 15% and expressed as no. of Dollars. Output job name Salary KAYLING $5,900 BLAZE $3,163 CLARE $2,933 $3,401 ADELYN $1,955 WADE $1,553 MADDEN $1,553 TUCKER $1,840 ADNRES $1,380 JULIUS $1,208 MARKER $1,610 SCARLET $3,565 FRANK $3,565 SANDRINE $1,035 5. Write a query in MS Access to produce the output of employees name and job name as a format of "Employee & Job." Output Cengage. Courses I Joey WSU E Google Docs 2 / 8 100% + 5. Output TUCKER $1,340 ADNRES $1,380 JULIUS $1,208 MARKER $1,610 SCARLET $3,565 FRANK $3,565 SANDRINE $1,035 Write a query in MS Access to produce the output of employees name and job name as a format of "Employee & Job. Employee & Job KAYLING PRESIDENT BLAZE MANAGER CLARE MANAGER JONAS MANAGER ADELYN SALESMAN WADE SALESMAN MADDEN SALESMAN TUCKER SALESMAN ADNRES CLERK JULIUS CLERK 6. Write a query in MS Access to produce the output of employees as follows Employee JONAS(manager) Output Employee KAYLING president) BLAZE manager CLARE(manager JONAS manager ADELYN(Salesman WADEisalesman) MADDEN Salesman TUCKER Salesman) ADNRES clerk JULIUSicer AC-340 Accounting Information Systems a QW-D COACH W Ausgrein Y nocending selection C Data Database folle edetable PT XC CON V Part OC Il escending Advanced f A XD Cabod All Access Objects et TXT 2 ded depretep locatie Add Tables 100 LANCI HARTFORD 2001 AUDIT NEW HAVEN 301 MARKETING NEW BRITAIN TH 0 PRODUCTION BERUN TH Que Y condi salary Home Create tena Database Tools Table table Pee what you want to do X 17 Section New Replace Cali HE View Coy Posle Speling 1. Dende Adria Rech fund BTUALE re A X Date - Me S- Cound So Twing The de XS X All Access Objects. Bet X mod osion- en mejob name manager dhire date dep_id= 10 told 23678 SANDRINE CLE 02 12/11/ $900.00 200 Tales NADELN SALESMAN 20 3/20/1991 $1,200.00 S400.00 3001 I WADE SALISMAN 6692 2/22/17 $1,150.00 600.00 3001 2 Tree JONAS MANAGER 31 4/3/1991 $2.957.00 2001 4 T. SA MADDEN SALESMAN 9/2010 SL150,00 $1.500.00 3001 2 Cum MATE MANAGER 1/1991 220.00 2001 4 672 CLARI MANAGER 119 0.00 1001 GS SCARLET ANALYST 4/1997 $1,100.00 2003 4 1 KAVUNO PRESIDENT 11/1991 1.000.00 1001 5 6811A TUCKEN SALESMAN 60 9/11 1.000.00 3001 3 7 ADRES CLERK 199) $1,200.00 2001 1 UUS 12/19 51.000.00 1001 1 O PRANE ANALYST 65665 12/1/1991 $1,100.00 2005 4 MAREER CLERK 62 1/2012 STAKLO 1001 2 0 4 CUK GACH W Air Date CDC WA ) Teme File Home Chi utabase Toch Help Table Field 9 N D Y dumine on View F Descending SA Save A X DE Un Clo All Access Objects Butant X 30 Top Stary macab $800.00 L.00 $12.00 $1,300.00 $1,SOLDO $2,100.00 $2.501.00 51,100.00 $3.101.00 59.00 3