How to Create a Table in MS Access 2016

Need to create a table in MS Access 2016?

If so, in this tutorial, I’ll show you the steps to create a table in MS Access 2016. I’ll also review how to delete a table that is no longer needed.

While this post focuses on Access 2016, the same principles apply to previous versions of MS Access.

By the end of this tutorial, you will be able to create the following simple table in Access:

 
IDClient First NameClient Last Name
1JonSmith
2MariaGreen
3MarkJones
4MiaLee
5BobHu

 

Let’s now jump to the steps to create a table in Access.

Steps to create a table in MS Access 2016

(1) First, go to the Create tab:

 

Create a Table in MS Access

 

(2) Then, click on the Table icon:

 

Table in MS Access

 

(3) A new table would be created with a default name of ‘Table1:’

 

Assign Table name in MS Access

 

(4) To save your table with a different name, right-click on the tab that displays the default name –  ‘Table1.’


Then, from the drop-down menu, choose Save:

 

Save Table in MS Access

 

(5) Now, type a new table name within the ‘Save As’ input box.

Once you’re done, press OK to save your new table name.

For example, I chose to save my table as ‘Clients’

 

How to Create a Table in MS Access 2016

 

(6) To access your table at any time, double-click on your table name under the All Access Objects menu.

You can find the All Access Objects menu at the left-hand-side of your screen.

In our example, I got the following result when I double-clicked on the ‘Clients’ table:

 

Open a table in MS Access

 

But wait a minute, that table is empty!

You can easily start adding some columns to that table.

For our example, we will add two columns:

  • Client First Name
  • Client Last Name

Steps to add columns to the table created

(1) Firstly, press on the ‘Click to Add’:



How to Create Columns in Access


(2) You will now see a drop-down list, where you can select the desired format for your column:

 

Choose the format of your column in MS Access

 

(3) Choose the desired format for your column. For instance, if you wish to store your client names, then you may select the format of ‘Short Text.’

This format seems to be suitable, considering that names contain text and are short in nature.

 

Short Text format in MS Access

 

 

(4) Type the title name for your newly created column. In our example, type ‘Client First Name’:

 

Rename the column in MS Access

 

(5) Repeat step#4, only this time create the column ‘Client Last Name’:

 

Table MS Access 2016

 

Ok, so are we done?

Almost… you’ll need to add the actual content underneath the columns you just created.

Recall the table that we saw at the beginning of this tutorial:

 
IDClient First NameClient Last Name
1JonSmith
2MariaGreen
3MarkJones
4MiaLee
5BobHu

 

To get that info into the ‘Clients’ table, simply type the names in the grid itself (similar to the way that you would type your data when using Excel).

And this is how your Access table would look like:

 

 

You’ll notice that an additional column (the ‘ID’ column) would automatically get created in your table.

This ID column contain numbers (in an incremental order) which represent your primary keys.

What is a primary key?

A primary key is a unique key that is used to identify each record in your table. You can use primary keys to link tables in Access.

Congratulation, you just saw how to create a table in MS Access 2016!

In the next section, we will review how to delete a table in Access.

How to delete a table in MS Access

Say that you no longer need a table. In that case, you may choose to delete your table.

Please note, that you cannot delete your table while it is still opened. Therefore, you’ll need to close the table that you want to delete, before you can execute the following steps:

(1) First, select the table that you want to delete under the All Access Objects. In our example, select the ‘Clients’ table:

 

Select the table you want to delete

 

(2) Then, press the Delete button as follows:

 

Delete button in MS Access

 

(3) Finally, confirm the deletion of your table:

 

confirm the deletion of your table in MS Access

 

(4) The following is an optional step in case you want to undo the deletion of your table.

To undo the table you just deleted, press on the undo button (or you can just use the keyboard shortcut of CTRL+Z):

 

undo delete of MS Access table

Conclusion

We just saw how to create a table in MS Access 2016. We also reviewed how to delete a table that is no longer needed.

The same principles that we just covered would also apply to previous versions of Access.

You may also want to check the following source for additional tutorials on MS Access 2016.