Listed below are the most commonly used Access functions. As a big user of Oracle, when I do need to use some Access functions I can never remember them or the parameters are different to the Oracle versions.
format
instr
replace
ucase
lcase
Access SQL
How to Replace Carriage Returns and New lines in Access data.
