When you use a name containing a space in Access SQL,you must ____.
A)enclose it in square brackets
B)enclose it in quotation marks
C)precede it by an asterisk
D)precede it by a question mark

Question

Quizplus · Accepted Answer

When using a name containing a space in Access SQL, you must enclose it in square brackets. This is because the space character in a name can cause confusion in the SQL syntax, so the square brackets indicate to Access that the name should be treated as a single entity.

When You Use a Name Containing a Space in Access