Recent Lessons

Show all results for ""

Feature Overview

Ace your exams with our all-in-one platform for creating and sharing quizzes and tests.

Quizzes

Create quizzes and tests automatically from your content using AI.

Flashcards

Automatically turn your notes into digital flashcards.

Share, Export & Embed

Share with classmates or export to Excel and your learning management system.

Stats & Reporting

Auto-grading quizzes and tests with detailed stats and reports.

Mobile Apps

The smarter way to study – wherever you are.

Pricing

Search...

3 Questions

1 Views

MS Access LCase() Function Quiz

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;

MS Access LCase() Function Quiz

Choose a study mode

Podcast

Questions and Answers

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

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

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

More Like This

Mastering MS Access

MS Access Relationships and Database Tables Quiz

MS Access Database Design Basics

MS Access Database Management

Upgrade to continue