Question 2 2.2.1 Define the following term use an example or table to aid your definition 0211 Record 2.2.1.2 Field Q213 Value 14 0.2.2 (15) You have been given the following table called themployees designed in MS Access. Use the information below to identify the primary key and data types and formatting were applied for each field Toda 2001 The Wome The 2017040 20170001 22 100 The Independent 2000 Field Name Field Duta Type Employee Employee Name Employee Surname StartDate Employee Salary Employee Bonus Department 0.23 write the formula to you would use to calculate the TotalEarnings a new culated field, using the EmployeeSalary and EmployeeBonus 0.24 What data type would you in to the new calculated field? (2 025 write the function would you use to total up the number of employees at tblEmployees table. Question Mars 2012 Management of the Techno company would like to find out more about there you decide to run a query for each of the request Q.2.2 (15) You have been given the following table called tbl Employees designed in MS Access. Use the information below to identify the primary key and data types and formatting (were applied for each field. Employee. Employeeame Employee Surname - StartDate. Employee Salary - Employer Bonus Department 2001 Thate Mokoena 2015093 R2.000 R3000 Development 2006 Karabo Mbele 20161022 R3.000 RS300 Engineering 2019 Chauke Sithole 201608/15 R 1.00 R5.000 Accounting 2045 Thate Sibanda 20170400 R 2.500 REngineering 2100 Precious Zuna 20170520 RES R6.000 Human Resources 3001 Brian Xaba 20190429 R2.000 R2100 Engineering The Independent Institute of Education (Pty) Ltd 2020 Page 2 of 5 18:19,20 2020 Field Name Field Data Type Employeeld Employee Name Employee Surname StartDate Employee Salary Employee Bonus Department 2.2.3 Write the formula to you would use to calculate the TotalEarnings, a new calculated (4) field, using the Employee Salary and EmployeeSonus. Q.2.4 What data type would you assign to the new calculated field? (2) Q.2.5 (2) Write the function would you use to total up the number of employees in the tblEmployees table Question 2 2.2.1 Define the following term use an example or table to aid your definition 0211 Record 2.2.1.2 Field Q213 Value 14 0.2.2 (15) You have been given the following table called themployees designed in MS Access. Use the information below to identify the primary key and data types and formatting were applied for each field Toda 2001 The Wome The 2017040 20170001 22 100 The Independent 2000 Field Name Field Duta Type Employee Employee Name Employee Surname StartDate Employee Salary Employee Bonus Department 0.23 write the formula to you would use to calculate the TotalEarnings a new culated field, using the EmployeeSalary and EmployeeBonus 0.24 What data type would you in to the new calculated field? (2 025 write the function would you use to total up the number of employees at tblEmployees table. Question Mars 2012 Management of the Techno company would like to find out more about there you decide to run a query for each of the request Q.2.2 (15) You have been given the following table called tbl Employees designed in MS Access. Use the information below to identify the primary key and data types and formatting (were applied for each field. Employee. Employeeame Employee Surname - StartDate. Employee Salary - Employer Bonus Department 2001 Thate Mokoena 2015093 R2.000 R3000 Development 2006 Karabo Mbele 20161022 R3.000 RS300 Engineering 2019 Chauke Sithole 201608/15 R 1.00 R5.000 Accounting 2045 Thate Sibanda 20170400 R 2.500 REngineering 2100 Precious Zuna 20170520 RES R6.000 Human Resources 3001 Brian Xaba 20190429 R2.000 R2100 Engineering The Independent Institute of Education (Pty) Ltd 2020 Page 2 of 5 18:19,20 2020 Field Name Field Data Type Employeeld Employee Name Employee Surname StartDate Employee Salary Employee Bonus Department 2.2.3 Write the formula to you would use to calculate the TotalEarnings, a new calculated (4) field, using the Employee Salary and EmployeeSonus. Q.2.4 What data type would you assign to the new calculated field? (2) Q.2.5 (2) Write the function would you use to total up the number of employees in the tblEmployees table