The table will have a primary key called Id by default. That is in my view an accetable name, or it could be change to TableNameId, for example CustomerId (note the singular customer as the Id will be the Id of a single customer). By default Id fields are not Auto-number To add auto-number, change the IdentitySpecification property in the Properties window from false to True.
Fields or Columns can be added in a similar way as in access, each field should have a name and a datatype. There are however many more data types in SQL Server than in access, the following are the most commonly used.
Allowing NULLS means that when a user is entering a new record, they can leave it blank or NULL (empty). NULL is different from a text field containing a space char. Allow NULLs on fields which are not essential, or could be filled in later. In this example if the Wine has no name, the record would be of no value.
Where there is a field with only a few values, and it is likely that more than half the records will have one particular value, setting a default value for that field can speed up data entry.