Enhancing Data Entry and Verifying Data for MovinOn Inc. David Bowers, general manager of MovinOn,..

Enhancing Data Entry and Verifying Data for MovinOn Inc.

David Bowers, general manager of MovinOn, met with his
warehouse managers to discuss the progress you have made in developing the
MovinOn database. Because MovinOn Inc. recently adopted a pension plan for all
employees, the managers want to inform employees when they are fully vested in
the plan, which happens after five years of service. David asks if you can add
a message to the form that indicates when an employee is fully vested based on
the length of service. He also wants you to add a control that calculates an
employee’s years
»

Enhancing Data Entry and Verifying Data for MovinOn Inc.

David Bowers, general manager of MovinOn, met with his
warehouse managers to discuss the progress you have made in developing the
MovinOn database. Because MovinOn Inc. recently adopted a pension plan for all
employees, the managers want to inform employees when they are fully vested in
the plan, which happens after five years of service. David asks if you can add
a message to the form that indicates when an employee is fully vested based on
the length of service. He also wants you to add a control that calculates an
employee’s years of service. For active employees, he wants you to hide the End
Date field; for inactive employees, he wants you to hide the Review field.
Finally, to help with data entry, the warehouse managers want to verify phone
and cell phone area codes entered into frmEmployeeData.

Complete the following:

Add a label control to frmEmployeeData in the appropriate
position on the form, using the name Vested_Label and the caption Fully Vested.
The message should appear on the form when an active or inactive employee has
five or more years of service. Display the message in red font. (Hint: Set your
computer’s system clock to the year 2016 or later to test the procedure.)

»