Assignment 8.3
A file has been created that did not use a Domain; this allowed users input Yes and No answers in different formats. Therefore, the data table is not uniform and a query cannot be successfully performed. The file contains yes, YES, Y, no, NO, and n. The correct format should be Yes and No. The task is to fix the file so that all Yes and No answers are in a single format. Provide your instructor with the script and screen shot of the file before and after the script has been run.
|