When you use a name containing a space in Access SQL, what must you do to specify the table or column name?
A)Enclose it in "quotation marks".
B)Enclose it in [square brackets].
C)Enclose it in *asterisks*.
D)Enclose it in (parentheses).

Question

Quizplus · Accepted Answer

In Access SQL, when using a name that contains a space for a table or column, it must be enclosed in [square brackets] to be correctly recognized.

When You Use a Name Containing a Space in Access