(35 POINTS) ACCESS - Comfort Insurance (Data File: Question 3.accdb) The Comfort Insurance Agency is a mid-sized company with offices located across the country. Each employee receives a performance review annually. The review determines employee eligibility for salary increases and the annual performance bonus. The employee data are stored in an Access database, used by the human resources department to monitor and maintain employee records. which is Task 1: Database Setup (a) Open the Question 3.accdb database and save it as Comfort Insurance.accdb. Open each table and look at their contents to become familiar with the field names and the type of information stored in (b) Open the Employees table, and then locate Elise Imber's name. Replace her name with your own (c) Update the design of the Employees table Performance field property to a Lookup data type so that it each tables. first and last name (also change the gender to your gender). displays Excellent, Average, Good, and Poor options as a dropdown list. Save and close the Employees table. Task 2: Create Forms Create user forms for the Employees and Location tables. Save your forms as frmEmployee and frmLocation respectively. For the Employees form, add a new text fields to show each employee's years of service. Hint: Use the DATEDIFF and NOW functions . Add appropriate titles in the forms header section. Add appropriate design elements to your forms (font, background color, form size..etc.) (35 POINTS) ACCESS - Comfort Insurance (Data File: Question 3.accdb) The Comfort Insurance Agency is a mid-sized company with offices located across the country. Each employee receives a performance review annually. The review determines employee eligibility for salary increases and the annual performance bonus. The employee data are stored in an Access database, used by the human resources department to monitor and maintain employee records. which is Task 1: Database Setup (a) Open the Question 3.accdb database and save it as Comfort Insurance.accdb. Open each table and look at their contents to become familiar with the field names and the type of information stored in (b) Open the Employees table, and then locate Elise Imber's name. Replace her name with your own (c) Update the design of the Employees table Performance field property to a Lookup data type so that it each tables. first and last name (also change the gender to your gender). displays Excellent, Average, Good, and Poor options as a dropdown list. Save and close the Employees table. Task 2: Create Forms Create user forms for the Employees and Location tables. Save your forms as frmEmployee and frmLocation respectively. For the Employees form, add a new text fields to show each employee's years of service. Hint: Use the DATEDIFF and NOW functions . Add appropriate titles in the forms header section. Add appropriate design elements to your forms (font, background color, form size..etc.)
