If you want spaces in your column names (why on earth would you want that????) then you have to surround the name of the column with square brackets e.g.
[Guest Name] varchar(250)
Same is true if you are trying to use reserved words like 'Name' by themselves e.g.
[Name] varchar(250)
works but e.g.
Name varchar(250)
will fail