Transforming Data with Microsoft Access
There are times when you as the IT professional need to cleanse information. Transforming data with Microsoft Access is easy. This video shows how to:
1. Find and remove duplicate records,
2. find and fill in blank or null fields,
3. concatenate fields or add text to fields,
4. change case with the StrConv function,
5. remove leading and trailing spaces with the Trim function, and
6. replace specific text with the Replace function.