SQL

posted by .

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?

Respond to this Question

First Name
School Subject
Your Answer

Similar Questions

  1. Computers

    How do you remove everything to the right of the decimal place in Access?
  2. criminal procedure

    Should members of the news media have greater access than the general public to court proceedings and court records?
  3. computer science

    Use the Library and other resources to write a "work-from-home" policy manual for an insurance company, educational institution, or another organization concerned about protecting an individual's privacy. Your manual should include …
  4. statistics

    The U.S. Census Bureau reported 77% of the U.S population had internet access in 2009. Choosing 3 random individuals find the probability that a. none of the 3 inidivuals has internet b. all of the individuals have internet access …
  5. statistics

    . In his management information systems textbook, Professor David Kroenke raises an interesting point: “If 98% of our market has Internet access, do we have a responsibility to provide non-Internet materials to that other 2%?
  6. Statistics

    In his management information systems textbook,Professor David Kroenke raises and interesting point:"If 98% of our market has Internet access,do we have a responsibility to provide non-Internet materials to that other 2%?
  7. MATH

    Suppose a third world country in the last five years is now expanding their Internet access. If they went from 2.5% of their citizens having access to the Internet to 7.5% now having access, calculate the following: a) How many percentage …
  8. math

    Suppose a third world country in the last five years is now expanding their Internet access. If they went from 2.5% of their citizens having access to the Internet to 7.5% now having access, calculate the following: a) How many percentage …
  9. computer science

    An Internet service provider has three different subscription packages for its customers: Package A: For $9.95 per month 10 hours of access are provided. Additional hours are $2.00 per hour. Package B: For $13.95 per month 20 hours …
  10. computer science

    Internet Service Provider An Internet service provider has three different subscription packages for its customers: Package A: For $9.95 per month 10 hours of access are provided. Additional hours are $2.00 per hour. Package B: For …

More Similar Questions