Please see the attached screenshots and assist in writing SQL Queries for MS Access. Thanks

Query #1: Retrieve the First name and Last name of employees who are managers who also have responsibility for one or more PROJECTs. The first name should be displayed as 'Name' and Last name as 'Last' as well as include the description of the project(s) in your result set.

Query #2: For every project located in Ch7_ConstructCo_V2, list description of project and last name of manager who controls that project.

File Home Create External Data Database Tools Help Fields Table Tell me what you want to do Tables HER ASSIGNMENT X ES EMP 1 E EMP_2 EMP_2_MOD EMPLOYEE ESP JOB PROJECT E EMPLOYEE EMP_NU - EMP_LNAM - EMP_FNAMI - EMP_INITIA, EMP_HIREDATI, JOB_CO, EMP_YEAF Click to Add + 101 News John G 08-Nov-00 502 12 + 102 Senior David H 12-Jul-89 501 23 + 103 Arbough June E 01-Dec-96 503 16 + 104 Ramoras Anne 15-Nov-87 501 25 milor + 105 Johnson Alice K 01-Feb-93 502 19 mo + 106 Smith field William 22-Jun-04 500 8 mo + 107 Alonzo Maria D 10-Oct-93 500 19 + 108 Washington Ralph B 22-Aug-91 501 21 . + 109 Smith Larry W 18-Jul-97 501 15 . + 110 error Olenko Gerald A 11-Dec-95 505 17 we + 111 Wabash Geoff B 04-Apr-91 506 21 dos + 112 Smithson Darlene M 23-Oct-94 507 18 euro + 113 Joenbrood Delbert K 15-Nov-96 508 16 women 200 + 114 Jones Annelise 19 20-Aug-93 508 an + 115 Bawangi Travis B 25-Jan-92 501 20 + 116 Pratt Gerald L 05-Mar-97 510 15 + 117 Williamson Angie H 19-Jun-96 509 16 + 118 Frommer James J 04-Jan-05 510 7 + 119 Frimpong Anita 12-Feb-19 502 2 + 120 + Asare Pete Y 03-Dec-16 509 5 ** 0 PROJECT 3 JOB 0 x JOB_COI, JOB_DESCRIPTION JOB_CHG_HOL, JOB_LAST_UPDA, Click to Add + 500 Programmer 35.75 20-Nov-11 + 501 Systems Analyst 96.75 20-Nov-11 + 502 Database Designer 125.00 24-Mar-12 + 503 Electrical Engineer 84.50 20-Nov-11 + 504 Mechanical Engineer 67.90 20-Nov-11 + 505 Civil Engineer 55.78 20-Nov-11 + 506 Clerical Support 26.87 20-Nov-11 sen! + 507 DSS Analyst 45.95 20-Nov-11 + 508 Applications Designer 48.10 24-Mar-12 + 509 Bio Technician 34.55 20-Nov-11 + 510 General Support 18.36 20-Nov-11 + 511 Farmer 30.00 25-Feb-21 # 512 Information Security 50.00 03-Feb-20 * 0.00 7 Re PROJ_NUM + 12 + 15 + 18 + 22 + 25 + 30 * - PROJ_NAME - PROJ_VALUE - PROJ_BALANC - EMP_NU - Click Rock solid $500,000.00 $450,000.00 109 Evergreen $1,453,500.00 $1,002,349.75 103 Amber Wave $3,500,500.00 $2,110,346.00 108 Rolling Tide $805,000.00 $500,345.19 102 Starflight $2,650,500.00 $2,309,879.75 107 $0.00 $0.00 103 Stripe $0.00 $0.00 No Filter Search EMP_2_MOD EMP_NU, EMP_LNAM - EMP_FNAN, EMP_INITIA, EMP_HIREDAT, JOB_COL, EMP_PC, PROJ_NU, Cli 101 News John G 08-Nov-00 502 5.00 25 102 Senior David H 12-Jul-89 501 8.00 103 Arbough June E 01-Dec-96 500 3.85 18 104 104 Ramoras Anne K 15-Nov-87 501 10.00 10.00 105 Johnson Alice Alice 01-Feb-93 502 5.00 25 106 106 Smithfield William 22-Jun-04 500 6.20 18 Alonzo Maria D 10-Oct-93 500 5.15 18 108 Washington Ralph B 22-Aug-91 501 10.00 109 Smith Larry W 18-Jul-97 501 2.00 0.00 107