Create a table from scratch in Design view

1. If you haven't already done so, switch to the Database window. You can press F11 to switch to the Database window from any other window.
   
   
2. Click Tables under Objects, and then click New on the Database window toolbar.
   
   
3. Double-click Design View.
   
   
4. Define each of the fields in your table.

   How?

5. Define a primary key field before saving your table.

   How?

   Note   You don't have to define a primary key, but it's usually a good idea. If you don't define a primary key, Microsoft Access asks if you want it to create one for you when you save the table. For more information on primary keys, click .

6. When you are ready to save your table, click Save on the toolbar, and then type a name for the table following Microsoft Access object-naming rules.

Note   For information on properties you can use to customize fields in a table, click .