40. One purpose of a data manipulation language is to: a) b) c) d) 41. create data fields define the record structure create queries on the data all of these All of the following are data types that you can assign to data fields when creating records in Microsoft Access except: a) Short Text b) c) d) Number Yes/No Currency 2. 42. e) all of these are legitimate data types A company uses the account code 669 for maintenance expense. However, one of the company's clerks often codes maintenance expense as 996. The highest account code in the system is 750. What would be the best internal control check to build into the company's computer program to detect this error? a) b) 306 c) d) A check for this type of error would have to be made before the information was transmitted to the data processing center Valid-character test Sequence test Valid-code test