Question

1 Approved Answer

Posted on Jul 25, 2024

4. Write (not record) a Macro, QUESTION4, that will highlight records in blue color (ColorIndex = 5) with all employees that are either in Marketing

image text in transcribed

4. Write (not record) a Macro, QUESTION4, that will highlight records in blue color (ColorIndex = 5) with all employees that are either in Marketing or Accounting departments and those employees should have a hiring date between 1/1/1985 and 1/1/1990, both dates inclusive. (Hint: For dates, use # signs, example, #1/1/1985#) (Must use Do-Until loop). Create macro button in Database sheet. B D E F G H I J K L M N 0 P Name Box 2 6 7 Emp ID 8 1011 Age 57 37 9 1012 S6 1041 1054 34 23 1055 1075 1152 54 42 10 11 12 13 14 15 16 17 18 19 1153 50 58 51 51 1167 43 SS 20 21 22 23 24 1168 1169 1290 1299 1300 1301 1310 1311 1329 1330 Randy 36 56 60 56 67 58 13 53 1331 58 1333 56 56 1334 Last Name First Name Department Division Gorton Hazel Accounting Copier Preston Liza Engineering Printer Tercan Robert R and D Printer Smith Howard Art Copier Albert Maxine Marketing Copier Kane Sheryl Art Printer Henders Mark Accounting Printer Plant Allen Accounting Printer Berwick Sam Marketing Copier Asonte Toni Engineering Fax Dorfberg Jeremy Engineering Copier Cooper Linda Admin Fax Simpson Sandrae Engineering Copier Richards Phillip Accounting Printer Sindole Marketing Fax Smith Ellen Engineering Fax Cane Nate Marketing Printer Vuanuo Tuome Engineering Printer Selznick Anna Accounting Copier Cash Mary Engineering Printer Szczych Tadeuz Engineering Kancko Midori R and D Fax Lampstone Pete Fax Bell Tom Accounting Printer Quan Karen Engineering Printer Kellerman Tommie Engineering Printer Stewart lain Admin Printer Alexandra R and D Copier Davison Karen Engineering Printer Bates Lisa Admin. Copier Sargent Evelyn Marketing Copier Wells Rose Accounting Printer Boughton Frank Accounting Fax Melendez Jaime Accounting Fax Miller Janet Marketing Copier Wells Jason Copier Levinc Eric R and D Fax Alstain Isolde Engineering Fax Chu Steven Marketing Printer Barton Eileen Art Copier Able Aaron Admin. Fax Goldherg Malcolm Marketing Fax Al-Sabah Daoud Engineering Fax Lin Michael Engineering Fax Mueller Ursula Accounting Copier Fontaine Jean Accounting Copier 1426 1516 Marketing Q6 Q7 Q8 Years In New Salary New Salary Birth Service 1 Month 22 $30,281.74 $3,311.74 November 16 $46,106.28 $5,207.30 December 20 $30,770.93 $3,365.24 September 13 $25,176.06 $3,021.13 August $28,573.00 $3,124.87 August 15 $24,691.91 $2,788.73 August 22 $29,237.54 $3,197.54 October 13 $28,043.68 $3,365.24 November 21 $35,017.50 $3,829.67 September 23 $69,166.12 $7,564.31 July 23 $63,642.75 $6,960.25 July 17 $27,745.98 $3,133.66 October 16 $37,032.59 $4,182.50 September 28 $33,413.11 $3,654.20 September 13 $27,081.04 $2,301.89 June 35 $35,562.81 $3,889.30 November 19 $47,716.06 $5,218.43 November $55,410.85 $4,709.92 May 23 $34,606.43 $3,784.71 September 23 $54,722.22 $5,984.66 May 27 $65,135.17 S7,123.46 October 24 $30,770.93 $3,365.24 October 36 $70,980.01 $7,762.68 September 18 $30,333.84 $3,425.94 June 33 $82,940.69 $9,070.75 July $45,146.68 $3,837.47 September $27,592.19 $3,017.60 January 26 $45,045.93 $4,926.42 January 15 $29,362.20 $2,495.79 September 12 $27,081.04 $3,249.72 March 16 $44,611.61 $5,038.49 September $34,665.98 $3,915.22 October $29,322.72 S3,311.74 January 26 $31,869.89 $3,485.43 January 23 $36,540.01 $3,996.17 September 20 $25,469.72 $2,785.48 September 14 $37,895.52 $3,221.12 September 23 $76,107.67 $8,323.46 September 24 $30,770.93 $3,365.24 May 14 $28,859.25 $3,463.11 October 18 $25,690.72 $2,901.54 October 14 $57,488.75 $4,886.54 October 30 $56,292.88 $6,156.43 September 19 $38,930.87 $4,257.65 September 12 $36,101.44 $4,332.17 May 29 $30,770.93 $3,365.24 March Salary $27,597.85 $43,394.15 $28,043.68 $ $25,176.06 $26,040.56 $23,239.44 $26,646.20 $28,043.68 $31,913.88 $63,035.88 $58,002.05 $26,113.86 $34,854.20 $30,451.68 $27,081.04 $32,410.85 $43,486.95 $55,410.85 $31,539.24 $49,872.15 $59,362.20 $28,043.68 $64,689.00 $28,549.50 $75,589.60 $45, 146.68 $25, 146.68 $41,053.48 $29,362.20 $27,081.04 $41,987.40 $32,626.80 $27,597.85 $29,045.24 $33,301.44 $23,212.32 $37,895.52 $69,362.20 $28.043.68 $28,859.23 $24,179.50 $57,488.75 $51,303.60 $35,480.40 $36,101.44 $28.043.68 Hire Date Birth Date 2/3/00 11/21/64 1/26/06 12/2/84 4/16/02 9/21/6S 4/16/09 8/9/87 4/8/99 8/20/67 8/7/06 8/28/79 1/21/00 10/23/71 1/13/09 11/3/63 4/18/01 9/28/70 4/10/99 7/8/70 10/13/98 7/12/78 1/3/05 10/1/66 12/21/05 9/16/85 12/13/93 9/24/65 8/6/08 6/25/61 10/4/86 11/2/65 9/26/02 11/13/54 2/22/09 S/6/64 /6/ 2/14/99 9/23/6R 5/11/99 5/21/64 4/16/95 10/7/65 4/8/98 10/18/65 9/8/85 9/23/58 3/6/04 6/26/63 2/26/89 7/7/63 1/28/07 9/10/71 1/20/91 1/15/67 5/11/96 1/19/67 11/26/06 9/23/87 8/18/09 3/22/90 10/16/05 9/26/62 12/6/02 10/10/83 3/25/06 1/17/80 3/17/96 1/28/64 10/26/98 9/1/60 10/18/01 9/12/82 11/6/07 9/16/89 10/89 8/6/98 9/23/65 7/29/97 5/21/65 10/3/68 12/16/03 10/14/76 2/18/08 10/18/86 3/4/92 9/28/69 7/8/02 9/1/89 6/20/09 5/28/86 11/13/92 3/22/65 63 58 58 SO 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 15 1517 1529 1530 1531 31 Lempert 55 55 34 32 1556 1557 1558 1657 59 38 19 42 16 58 1674 1675 1675 1676 1677 52 Admin. 39 32 56 57 1723 1724 1792 1793 12/24/07 53 45 35 49 52 50 51 52 53 1794 1814 1816 1931 1960 32 35 57 4. Write (not record) a Macro, QUESTION4, that will highlight records in blue color (ColorIndex = 5) with all employees that are either in Marketing or Accounting departments and those employees should have a hiring date between 1/1/1985 and 1/1/1990, both dates inclusive. (Hint: For dates, use # signs, example, #1/1/1985#) (Must use Do-Until loop). Create macro button in Database sheet. B D E F G H I J K L M N 0 P Name Box 2 6 7 Emp ID 8 1011 Age 57 37 9 1012 S6 1041 1054 34 23 1055 1075 1152 54 42 10 11 12 13 14 15 16 17 18 19 1153 50 58 51 51 1167 43 SS 20 21 22 23 24 1168 1169 1290 1299 1300 1301 1310 1311 1329 1330 Randy 36 56 60 56 67 58 13 53 1331 58 1333 56 56 1334 Last Name First Name Department Division Gorton Hazel Accounting Copier Preston Liza Engineering Printer Tercan Robert R and D Printer Smith Howard Art Copier Albert Maxine Marketing Copier Kane Sheryl Art Printer Henders Mark Accounting Printer Plant Allen Accounting Printer Berwick Sam Marketing Copier Asonte Toni Engineering Fax Dorfberg Jeremy Engineering Copier Cooper Linda Admin Fax Simpson Sandrae Engineering Copier Richards Phillip Accounting Printer Sindole Marketing Fax Smith Ellen Engineering Fax Cane Nate Marketing Printer Vuanuo Tuome Engineering Printer Selznick Anna Accounting Copier Cash Mary Engineering Printer Szczych Tadeuz Engineering Kancko Midori R and D Fax Lampstone Pete Fax Bell Tom Accounting Printer Quan Karen Engineering Printer Kellerman Tommie Engineering Printer Stewart lain Admin Printer Alexandra R and D Copier Davison Karen Engineering Printer Bates Lisa Admin. Copier Sargent Evelyn Marketing Copier Wells Rose Accounting Printer Boughton Frank Accounting Fax Melendez Jaime Accounting Fax Miller Janet Marketing Copier Wells Jason Copier Levinc Eric R and D Fax Alstain Isolde Engineering Fax Chu Steven Marketing Printer Barton Eileen Art Copier Able Aaron Admin. Fax Goldherg Malcolm Marketing Fax Al-Sabah Daoud Engineering Fax Lin Michael Engineering Fax Mueller Ursula Accounting Copier Fontaine Jean Accounting Copier 1426 1516 Marketing Q6 Q7 Q8 Years In New Salary New Salary Birth Service 1 Month 22 $30,281.74 $3,311.74 November 16 $46,106.28 $5,207.30 December 20 $30,770.93 $3,365.24 September 13 $25,176.06 $3,021.13 August $28,573.00 $3,124.87 August 15 $24,691.91 $2,788.73 August 22 $29,237.54 $3,197.54 October 13 $28,043.68 $3,365.24 November 21 $35,017.50 $3,829.67 September 23 $69,166.12 $7,564.31 July 23 $63,642.75 $6,960.25 July 17 $27,745.98 $3,133.66 October 16 $37,032.59 $4,182.50 September 28 $33,413.11 $3,654.20 September 13 $27,081.04 $2,301.89 June 35 $35,562.81 $3,889.30 November 19 $47,716.06 $5,218.43 November $55,410.85 $4,709.92 May 23 $34,606.43 $3,784.71 September 23 $54,722.22 $5,984.66 May 27 $65,135.17 S7,123.46 October 24 $30,770.93 $3,365.24 October 36 $70,980.01 $7,762.68 September 18 $30,333.84 $3,425.94 June 33 $82,940.69 $9,070.75 July $45,146.68 $3,837.47 September $27,592.19 $3,017.60 January 26 $45,045.93 $4,926.42 January 15 $29,362.20 $2,495.79 September 12 $27,081.04 $3,249.72 March 16 $44,611.61 $5,038.49 September $34,665.98 $3,915.22 October $29,322.72 S3,311.74 January 26 $31,869.89 $3,485.43 January 23 $36,540.01 $3,996.17 September 20 $25,469.72 $2,785.48 September 14 $37,895.52 $3,221.12 September 23 $76,107.67 $8,323.46 September 24 $30,770.93 $3,365.24 May 14 $28,859.25 $3,463.11 October 18 $25,690.72 $2,901.54 October 14 $57,488.75 $4,886.54 October 30 $56,292.88 $6,156.43 September 19 $38,930.87 $4,257.65 September 12 $36,101.44 $4,332.17 May 29 $30,770.93 $3,365.24 March Salary $27,597.85 $43,394.15 $28,043.68 $ $25,176.06 $26,040.56 $23,239.44 $26,646.20 $28,043.68 $31,913.88 $63,035.88 $58,002.05 $26,113.86 $34,854.20 $30,451.68 $27,081.04 $32,410.85 $43,486.95 $55,410.85 $31,539.24 $49,872.15 $59,362.20 $28,043.68 $64,689.00 $28,549.50 $75,589.60 $45, 146.68 $25, 146.68 $41,053.48 $29,362.20 $27,081.04 $41,987.40 $32,626.80 $27,597.85 $29,045.24 $33,301.44 $23,212.32 $37,895.52 $69,362.20 $28.043.68 $28,859.23 $24,179.50 $57,488.75 $51,303.60 $35,480.40 $36,101.44 $28.043.68 Hire Date Birth Date 2/3/00 11/21/64 1/26/06 12/2/84 4/16/02 9/21/6S 4/16/09 8/9/87 4/8/99 8/20/67 8/7/06 8/28/79 1/21/00 10/23/71 1/13/09 11/3/63 4/18/01 9/28/70 4/10/99 7/8/70 10/13/98 7/12/78 1/3/05 10/1/66 12/21/05 9/16/85 12/13/93 9/24/65 8/6/08 6/25/61 10/4/86 11/2/65 9/26/02 11/13/54 2/22/09 S/6/64 /6/ 2/14/99 9/23/6R 5/11/99 5/21/64 4/16/95 10/7/65 4/8/98 10/18/65 9/8/85 9/23/58 3/6/04 6/26/63 2/26/89 7/7/63 1/28/07 9/10/71 1/20/91 1/15/67 5/11/96 1/19/67 11/26/06 9/23/87 8/18/09 3/22/90 10/16/05 9/26/62 12/6/02 10/10/83 3/25/06 1/17/80 3/17/96 1/28/64 10/26/98 9/1/60 10/18/01 9/12/82 11/6/07 9/16/89 10/89 8/6/98 9/23/65 7/29/97 5/21/65 10/3/68 12/16/03 10/14/76 2/18/08 10/18/86 3/4/92 9/28/69 7/8/02 9/1/89 6/20/09 5/28/86 11/13/92 3/22/65 63 58 58 SO 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 15 1517 1529 1530 1531 31 Lempert 55 55 34 32 1556 1557 1558 1657 59 38 19 42 16 58 1674 1675 1675 1676 1677 52 Admin. 39 32 56 57 1723 1724 1792 1793 12/24/07 53 45 35 49 52 50 51 52 53 1794 1814 1816 1931 1960 32 35 57