MS Access LCase() Function Quiz
3 Questions
1 Views

Choose a study mode

Play Quiz
Study Flashcards
Spaced Repetition
Chat to Lesson

Podcast

Play an AI-generated podcast conversation about this lesson

Questions and Answers

Which function is used to convert a string to lower-case in MS Access?

  • ConvertToLowerCase()
  • LowerCase()
  • UCase()
  • LCase() (correct)

What is the syntax for using the LCase() function in MS Access?

  • text(LCase)
  • LCaseString(text)
  • StringToLowerCase(text)
  • LCase(text) (correct)

Which SQL statement can be used to convert the text in the 'CustomerName' column of the 'Customers' table to lower-case?

  • SELECT LCASE(CustomerName) AS LowercaseCustomerName FROM Customers; (correct)
  • SELECT CustomerName TO LOWERCASE AS LowercaseCustomerName FROM Customers;
  • SELECT LOWER(CustomerName) AS LowercaseCustomerName FROM Customers;
  • SELECT CONVERT(CustomerName, lcase) AS LowercaseCustomerName FROM Customers;

More Like This

Mastering MS Access
5 questions
MS Access Database Design Basics
30 questions
MS Access: Reports and Macros
30 questions
Use Quizgecko on...
Browser
Browser