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:

Verify telephone area codes for employee phone numbers in
frmEmployeeData. For employees living in Oregon, the valid area codes are 541,
503, and 971; for employees living in Washington, the valid area codes are 425,
360, 206, 509, and 253; for employees living in Wyoming, the valid area code is
307. Warehouse managers should be able to enter phone area codes for other
states not included in the lists.

»