I used to do freelance IT support. Databases were the worst. I would have clients who wanted to convert from Excel spreadsheets to Access databases.
In theory, it’s an almost trivial exercise in reading the manual. In practice, the client has invariably put text in a field that should be numeric-only or numbers in a date field or long comments in a phone number field that should only have 11 characters. Cleaning up the formatting violations was 90% of the work.
I used to do freelance IT support. Databases were the worst. I would have clients who wanted to convert from Excel spreadsheets to Access databases.
In theory, it’s an almost trivial exercise in reading the manual. In practice, the client has invariably put text in a field that should be numeric-only or numbers in a date field or long comments in a phone number field that should only have 11 characters. Cleaning up the formatting violations was 90% of the work.