In Microsoft® Access, you can make changes to the table design after it has been implemented. In many cases, Access does not modify existing tables. Instead, it creates new tables according to your specifications, and then moves data into it. SQL Server makes changes to tables in the same way; however, in some cases you must guide it through the steps.
Creating and Modifying a Table