Is it possible to set a column to no duplicates values like you can in Access?
You bet! This is done by adding a unique index on that column. How to do this varies slightly by database vendor, but something like this should work:
ALTER TABLE mytable ADD UNIQUE INDEX (mycolumn)
Hope this helps,