Access: Tables and Controls 4-22. Benjamin Department Store (Data Validation Using a DBMS)The payroll department at the Benjamin Department Store has defined the following recordstructure for employee records.Date (sic) FieldData TypeЕxampleLast nameТеextKerrFirst nameТextStephen123-45-6789Social Security numberHome phone numberWork phone extensionPay rateNumber of tax exemptionsDepartmentТext(987)456–4321124ТextNumberCurrencyNumber$12.343ТextAAll fields are required. The employee's Social Security number serves as the primarykey. Work phone extensions are always greater than "100" and less than "999." Hourlypay rates are always at least $12.50 and no more than $55.00. The maximum number of taxexemptions allowed is "6." Finally, there are only three departments: A, B, and C.Requirements1. 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.3. Create employee records for yourself and employees with the last names Strawswer, Smith,and Wolfe using data that you make up. (Do NOT use your real information)4. Attempt to create one more record that violates a data validation rule. (Create a screencapture of one of the violations) Go the extra mile: At Antiques, Inc, each salesperson uses the database to add/update his/her own information as well as to record sales (i.,e., invoices).Perform the steps necessary to1) add yourself as a new Sales_Rep, and2) record a sale that you made today to Value Furniture for the following order:Product_ID Product_Description Quanity1 End Table63 Computer Desk3Complete Simkin-8-21 . (Add this information as a new table to the Pine Valley Antiques database. Do NOT use your real Social Security Number)Go the extra mile: Benjamin Department Store is a rapidly growing company. You anticipate needing a way to quickly pull up your information from thethousands of future employees. Write a query that will show your information excluding your Social Security Number, Pay rate, and Number of taxexemptions.

Question

Access: Tables and Controls 4-22. Benjamin Department Store (Data Validation Using a DBMS)The payroll department at the Benjamin Department Store has defined the following recordstructure for employee records.Date (sic) FieldData TypeЕxampleLast nameТеextKerrFirst nameТextStephen123-45-6789Social Security numberHome phone numberWork phone extensionPay rateNumber of tax exemptionsDepartmentТext(987)456–4321124ТextNumberCurrencyNumber$12.343ТextAAll fields are required. The employee's Social Security number serves as the primarykey. Work phone extensions are always greater than &#34;100&#34; and less than &#34;999.&#34; Hourlypay rates are always at least $12.50 and no more than $55.00. The maximum number of taxexemptions allowed is &#34;6.&#34; Finally, there are only three departments: A, B, and C.Requirements1. 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.3. Create employee records for yourself and employees with the last names Strawswer, Smith,and Wolfe using data that you make up. (Do NOT use your real information)4. Attempt to create one more record that violates a data validation rule. (Create a screencapture of one of the violations) Go the extra mile: At Antiques, Inc, each salesperson uses the database to add/update his/her own information as well as to record sales (i.,e., invoices).Perform the steps necessary to1) add yourself as a new Sales_Rep, and2) record a sale that you made today to Value Furniture for the following order:Product_ID Product_Description Quanity1 End Table63 Computer Desk3Complete Simkin-8-21 . (Add this information as a new table to the Pine Valley Antiques database. Do NOT use your real Social Security Number)Go the extra mile: Benjamin Department Store is a rapidly growing company. You anticipate needing a way to quickly pull up your information from thethousands of future employees. Write a query that will show your information excluding your Social Security Number, Pay rate, and Number of taxexemptions.

Accepted Answer

Using a DBMS such as Access, create a record structure for the company.

2. Create data validation…

4-22. Benjamin Department Store (Data Validation Using a DBMS) The payroll department at the Benjamin Department Store has defined the following record structure for employee records.