Adding Fields To A Table

In this post, we show you how to add fields to a table.

Open up an MS Access table in design view.

We add fields to our table by entering field names in the Field Name column.  Each field must have a unique name within the table environment and it should be easily discernible from the name of the field what type of data is stored. Field names shouldn’t contain spaces and should be in capitalised Camel Case form (CustomerName not customername).  You have the ability to add hundreds of fields to one table but, if that is necessary, there may be an issue with the data modelling.

After you have entered a Field Name, you will need to choose a Data Type. Follow the example below and use the Text Data Type for all your fields except ID where you can use the AutoNumber Data Type.


                   Table in design view

 Saving the Table

Then, right-click on the tab and choose save.

Saving A Table Saving the Table Name

You will then get the following warning. Clicking yes will allow Access to add the primary key.

Setting Primary Keys

You can set the primary key yourself by right-clicking in the appropriate field and choosing Primary Key.

Adding fields to a table is a simple procedure. Just remember to set the right data type.

Related Posts

Field Data Types
How To Create A New Table In Access
How To Increment A Text ID Field
How To Set A Primary Key

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!