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.

The table designer

Table Design View

Options For The Table Designer

 

  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

Adding Fields To A Table
Field Data Types
How To Increment A Text ID Field
How To Set A Primary Key
Indexes

As always, a site wouldn't be anything without its users so please feel free to comment! We welcome any comments you have on the material and any suggestions you may have for future content.


In our humble opinion, it is worth commenting just so you can play with Fun Captcha below!

Leave a Reply

Your email address will not be published. Required fields are marked *