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 question marks

Question

Quizplus · Accepted Answer

When using a name containing a space in Access SQL, the table or column name must be enclosed in square brackets. This syntax tells Access that the entire name enclosed in the brackets should be interpreted as a single identifier, rather than separate words or phrases.

When You Use a Name Containing a Space in Access