How To Create A New Table In Access

In this post, we show you how to create a new table in MS Access and give a brief explanation of the table designer.

To begin with, we ask access to make a blank table for us.  Go to the create tab on the ribbon and then click on table design.

Table Design View

1. The Ribbon for the table designer will provide controls specific to tables.
2. In these lines we enter the fields for our table.  Each line represents a separate field.
3. This section tells us details about the field currently active in section 2.
4. This section gives us details about the table in general.

Creating a new table is the most fundamental part of utilising MS Access, so get used to it!

Related Posts