Table Fields Table Tell me what you want to do New Totals Calibri 11 abc Spelling Sbc Replace Go To Select Save X Delete Refresh All Find Av , - More Records Find Text Formatting File Home Create External Data Database Tools Help X Cut 7 L Ascending 17 Selection [6 Copy A Descending Advanced View Paste Filter Format Painter 20 Remove Sort Y Toggle Filter Views Clipboard Sort & Filter All Access Objects Tbl_Salary X grade min_sal Search... $800.00 Tables 2 $1,301.00 BE Tbl Department 3 $1,501.00 Tbl_Employee_Updated 4 $2,101.00 B Tbl Salary 5 $3,101.00 Queries * Query1 Click to Add max sal $1,300.00 $1,500.00 $2,100.00 $3,100.00 $9,999.00 File Home Create External Data Database Tools Help Table Fields Table Tell me what you want to do 7 El Ascending Calibri X Cut LB Copy Format Painter 11 - abc Spelling Slc Replace Go To Select EEE TV Paste Filter Find View v BIU A Views Clipboard Find Text Formatting All Access Objects A A Ascending 7 Selection New Totals A Descending Advanced Save Refresh 2 Remove Sort 7 Toggle Filter All X Delete More Sort & Filter Records 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 Search... Tables + BE Tbl_Department + * FEE Tbl_Employee_Updated BE Tbl_Salary Queries E Query1 ? 11 Le Copy abc Spelling KA 11 Text Formatting F grade Click to Add 1 3 HER 2 File Home Create External Data Database Tools Help Table Fields Table Tell me what you want to do X Cut AL Ascending 7 Selection New Totals Replace Calibri A Descending Advanced Save Go To View Paste Filter Refresh Find Format Painter BIU A 20 Remove Sort 7 Toggle Filter All X Delete A Select More Views Clipboard Sort & Filter Records Find All Access Objects 1350 1600 0 14 Write a query in MS ACCESS to list the employees whose salary is more than 3000 after giving 25% increment Output salary 1400 1750.00 2550 3187 50 hlighted columns shows the increased salary is 1000 6000 7500.00 3100 3875.00 3100 3875.00 1200 1500.00 900 1125.00 2957 3696 25 emp_id emp_name job_name date salary 68319 KAYLING PRESIDENT 33560 6000 1050 1312.50 66928 BLAZE MANAGER 33359 2750 2750 343750 67832 CLARE MANAGER 33398 2550 1700 2125.00 65546 JONAS MANAGER 33330 2957 1350 1687.50 67858 SCARLET ANALYST 35539 3100 1350 1687.50 69062 FRANK ANALYST 335753100 1600 2000.00 salary and increased have shown here . 15. Write a query in MS ACCESS to list the employees who joined in the month January, Output emp_id hire_date 68319 1991-11-18 66928 1991-05-01 67832 1991-06-09 65646 1991-04-02 54989 1991-02-20 65271 1991-02-22 empujd emp_same job_name manager_id hire_date salary co 66564 1991-08-28 69828 MARKER CLERK 67832 1992-01-23 1400 1991-09-08 68736 1997-05-23 69000 1991-12-03 1992-01-23 the hilighted column shows the is 1 1. January 67858 1997-04month of date 69062 1991-12-03 63679 1910-12-18 Write a query in MS ACCESS to list the employees and their experience in years. (Your put depend on your system date, you must be close to it or matching it.) emp_id - emp_name - hire_date - Experience - 53678 SANDRINE 12/18/1990 30 64989 ADELYN 2/20/1991 2 65271 WADE 2/22/1991 29 65646 JONAS 4/2/1991 29 66564 MADDEN 9/28/1991 29 66928 BLAZE 5/1/1991 29 67832 CLARE 6/9/1991 29 67858 SCARLET 4/19/1997 23 68319 KAYLING 11/18/1991 29 68454 TUCKER TONER 9/8/1991 29 68736 ADNRES 5/23/1997 23 69000 JULIUS 12/3/1991 29 69062 FRANK 12/3/1991 29 69324 MARKER 1/23/1992 28 Write a query in MS ACCESS to list the employees who have joined in the year 1991 emp_name hire_date KAYLING 1991-11-18 BLAZE 1991-05-01 CLARE 1991-06-09 JONAS 1991-04-02 ADELYN 1991-02-20 WADE 1991-02-22 MADDEN 1991-09-28 TUCKER 1991-09-08 ADNRES 1997-05-23 JULIUS 1991-12-03 MARKER 1992-01-23 SCARLET 1997-04-19 FRANK 1991-12-03 SANDRINE 1990-12-18 emp_id emp_name job_name manager_id hire_date salary commission dep_id 68319 KAYLING PRESIDENT 1991-11-18 6000 1001 66928 BLAZE MANAGER 68319 1991-05-01 2750 3001 67832 CLARE MANAGER 68319 1991-06-09 2550 1001 65646 JONAS MANAGER 68319 1991-04-02 2957 2001 64989 ADELYN SALESMAN 66928 1991-02-20 1700 400 3001 65271 WADE SALESMAN 66928 1991-02-22 1350 600 3001 66564 MADDEN SALESMAN 66928 1991-09-28 1350 1500 3001 68454 TUCKER SALESMAN 66928 1991-09-08 1600 0 3001 69000 JULIUS CLERK 66928 1991-12-03 1050 3001 69062 FRANK ANALYST 65646 1991-12-03 3100 2001 5494 Table Fields Table Tell me what you want to do New Totals Calibri 11 abc Spelling Sbc Replace Go To Select Save X Delete Refresh All Find Av , - More Records Find Text Formatting File Home Create External Data Database Tools Help X Cut 7 L Ascending 17 Selection [6 Copy A Descending Advanced View Paste Filter Format Painter 20 Remove Sort Y Toggle Filter Views Clipboard Sort & Filter All Access Objects Tbl_Salary X grade min_sal Search... $800.00 Tables 2 $1,301.00 BE Tbl Department 3 $1,501.00 Tbl_Employee_Updated 4 $2,101.00 B Tbl Salary 5 $3,101.00 Queries * Query1 Click to Add max sal $1,300.00 $1,500.00 $2,100.00 $3,100.00 $9,999.00 File Home Create External Data Database Tools Help Table Fields Table Tell me what you want to do 7 El Ascending Calibri X Cut LB Copy Format Painter 11 - abc Spelling Slc Replace Go To Select EEE TV Paste Filter Find View v BIU A Views Clipboard Find Text Formatting All Access Objects A A Ascending 7 Selection New Totals A Descending Advanced Save Refresh 2 Remove Sort 7 Toggle Filter All X Delete More Sort & Filter Records 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 Search... Tables + BE Tbl_Department + * FEE Tbl_Employee_Updated BE Tbl_Salary Queries E Query1 ? 11 Le Copy abc Spelling KA 11 Text Formatting F grade Click to Add 1 3 HER 2 File Home Create External Data Database Tools Help Table Fields Table Tell me what you want to do X Cut AL Ascending 7 Selection New Totals Replace Calibri A Descending Advanced Save Go To View Paste Filter Refresh Find Format Painter BIU A 20 Remove Sort 7 Toggle Filter All X Delete A Select More Views Clipboard Sort & Filter Records Find All Access Objects 1350 1600 0 14 Write a query in MS ACCESS to list the employees whose salary is more than 3000 after giving 25% increment Output salary 1400 1750.00 2550 3187 50 hlighted columns shows the increased salary is 1000 6000 7500.00 3100 3875.00 3100 3875.00 1200 1500.00 900 1125.00 2957 3696 25 emp_id emp_name job_name date salary 68319 KAYLING PRESIDENT 33560 6000 1050 1312.50 66928 BLAZE MANAGER 33359 2750 2750 343750 67832 CLARE MANAGER 33398 2550 1700 2125.00 65546 JONAS MANAGER 33330 2957 1350 1687.50 67858 SCARLET ANALYST 35539 3100 1350 1687.50 69062 FRANK ANALYST 335753100 1600 2000.00 salary and increased have shown here . 15. Write a query in MS ACCESS to list the employees who joined in the month January, Output emp_id hire_date 68319 1991-11-18 66928 1991-05-01 67832 1991-06-09 65646 1991-04-02 54989 1991-02-20 65271 1991-02-22 empujd emp_same job_name manager_id hire_date salary co 66564 1991-08-28 69828 MARKER CLERK 67832 1992-01-23 1400 1991-09-08 68736 1997-05-23 69000 1991-12-03 1992-01-23 the hilighted column shows the is 1 1. January 67858 1997-04month of date 69062 1991-12-03 63679 1910-12-18 Write a query in MS ACCESS to list the employees and their experience in years. (Your put depend on your system date, you must be close to it or matching it.) emp_id - emp_name - hire_date - Experience - 53678 SANDRINE 12/18/1990 30 64989 ADELYN 2/20/1991 2 65271 WADE 2/22/1991 29 65646 JONAS 4/2/1991 29 66564 MADDEN 9/28/1991 29 66928 BLAZE 5/1/1991 29 67832 CLARE 6/9/1991 29 67858 SCARLET 4/19/1997 23 68319 KAYLING 11/18/1991 29 68454 TUCKER TONER 9/8/1991 29 68736 ADNRES 5/23/1997 23 69000 JULIUS 12/3/1991 29 69062 FRANK 12/3/1991 29 69324 MARKER 1/23/1992 28 Write a query in MS ACCESS to list the employees who have joined in the year 1991 emp_name hire_date KAYLING 1991-11-18 BLAZE 1991-05-01 CLARE 1991-06-09 JONAS 1991-04-02 ADELYN 1991-02-20 WADE 1991-02-22 MADDEN 1991-09-28 TUCKER 1991-09-08 ADNRES 1997-05-23 JULIUS 1991-12-03 MARKER 1992-01-23 SCARLET 1997-04-19 FRANK 1991-12-03 SANDRINE 1990-12-18 emp_id emp_name job_name manager_id hire_date salary commission dep_id 68319 KAYLING PRESIDENT 1991-11-18 6000 1001 66928 BLAZE MANAGER 68319 1991-05-01 2750 3001 67832 CLARE MANAGER 68319 1991-06-09 2550 1001 65646 JONAS MANAGER 68319 1991-04-02 2957 2001 64989 ADELYN SALESMAN 66928 1991-02-20 1700 400 3001 65271 WADE SALESMAN 66928 1991-02-22 1350 600 3001 66564 MADDEN SALESMAN 66928 1991-09-28 1350 1500 3001 68454 TUCKER SALESMAN 66928 1991-09-08 1600 0 3001 69000 JULIUS CLERK 66928 1991-12-03 1050 3001 69062 FRANK ANALYST 65646 1991-12-03 3100 2001 5494
