In a query,which of the following statements is TRUE regarding delimiters in the criterion of a field?
A) Text data types must be enclosed in pound signs.
B) Number data types that use plain digits require no delimiter.
C) Date/Time data types must be enclosed in quotations.
D) Number data types must be enclosed in single quotes.

Question

Quizplus · Accepted Answer

Delimiters are not required for number data types that use plain digits. Text data types should be enclosed in double quotes, and date/time data types should be enclosed in pound signs. Single quotes are used as delimiters in some programming languages, but not in Access queries.

In a Query,which of the Following Statements Is TRUE Regarding