The payroll department at the Bonnie P Manufacturing Company has defined the following record structure for employee records.

All fields are required. The employee's Social Security number serves as the record key. Work phone extensions are always greater than ‘‘100'' and less than ‘‘999.'' Pay rates are always at least $7.75 and no more than $29.85. The maximum number of tax exemptions allowed is ‘‘10.'' Finally, there are only three departments: A, B, and C.

Requirements
1. Using a DBMS such as Access, create a record structure for the company.
2. Create data validation rules for as many data fields as you can. For each data validation rule, also create validation text that the system can use to display an appropriate error message. Create a list of such rules on a separate piece of paper.
3. Create employee records for yourself, and employees with the last names Anderson, Baker, and Chapman using data that you make up. Print this information.
4. Attempt to create one more record that violates a data validation rule. Create a screen capture of one or more violations, as suggested by yourinstructor.

Transcribed Image Text:

Date Field Last Name First Name Social Security number Home phone number Work phone extension Payrate Number of tax exemptions Department Data Type Example Text Text Text Text Number 123 Currency $12.34 Kerr Stephen 123-45-6789 (987) 456-4321 Number 3 Text