Bba 301 – week 2 data validation assignment
The HR tab in Hospital.xlsx file contains the employee records downloaded from the personnel database of a fictitious hospital. Data is required in all fields except Address 2 and Phone. If a phone number is entered it must adhere to the 999-999-9999 format. At least 100 data errors exist in this file. On the Errors tab in Hospital.xlsx file, document each error by identifying the […]