Useful to set one of the columns as the primary key.  To make the primary key an auto generated number create the column as type 'int' then in its properties : Identity Specification = Yes Identity Increment = 1 Identity Seed = 1    

Column Types See page 134 of 'Beginning SQL Server Express 2008) Text varchar(50) For short text fields varchar(MAX) (Will eventually supercede text type) vNarchar(50) Unicode so double storage space but not limited characterset nVarchar(MAX) Unicode so double storage space but not limited characterset text Don't Use – Use varchar instead as this will be superceeded […]