Question

1. How do you display letters in uppercase in access? how do you display in lowercase in access?
2. how do you round a number to a spisfic number of decimal places in access? how do you remove everything to the right of the decimal place in access?
3. how do you add months to data in access? how do you add days to a date? How would you find the number of the days between two days?
4. how do you obtain today's date in access?
5. how do you concatenate values in character columns in access?
6. which function delets extra spaces at the end of a value?
7. what are stored procedures? what purpose do they serve?

Answer 1

Many Access SQL tutorials are available online. Here's one of them:

http://www.lynda.com/Access-training-tutorials/140-0.html?utm_source=google&utm_medium=cpc&utm_campaign=Search-Biz-Access&utm_content=PxYWfEX1&utm_term=%2Baccess%20%2Btutorials&gclid=CLbZy_HK9a8CFasBQAod8W9dFw