I see it is just Access being Access.
No, that's you using a word that is reserved and expecting to get away with. It is also a commandment of experienced db developers that "Thou shalt not use spaces or special characters, save perhaps for underscore, in any database object names". If you violate these guidelines, most database types will balk, thus it has little to do with Access specifically. You can ensure that you never use a reserved word by adopting one of the common naming conventions.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.