Homework Essay Help

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.

Don't use plagiarized sources. Get Your Custom Essay on
Bba 301 – week 2 data validation assignment
Just from $13/Page
Order Essay

On the Errors tab in Hospital.xlsx file, document each error by identifying the location of the error (ID Number), the type of error (omission, range, data entry, etc.), and the correct information, if known. You receive one point for each VALID error identified. Truncation of data to the maximum number of characters for a field is NOT considered an error as it is imposed by the system and not a data entry error. Extra credit is available for deeper analysis.

An additional file name Zipcode.xlsx is available as a reference.  

Order your essay today and save 30% with the discount code ESSAYHELP