How to Create a Table in MS Access 2016

In this guide, 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.

By the end of this guide, you’ll be able to create the following table in Access:

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

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

Steps to Create a Table in MS Access 2016

(1) To start, 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 of ‘Table1.’

How to Create a Table in MS Access 2016

(5) Then, from the drop-down list, choose Save:

Save Table in MS Access(6) 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 saved my table as ‘Clients’

How to Create a Table in MS Access 2016

The new table name (i.e., ‘Clients’) will now get reflected under the All Access Objects menu (you can access your table at anytime by double-clicking on the table’s name):

Open a table in MS Access

You may have noticed that the ‘Clients’ table is currently empty.

You can easily start adding some columns to that table. For our example, let’s add two columns:

  • Client First Name
  • Client Last Name

Steps to Add Columns to the Table Created

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

How to Create Columns in Access(2) You’ll 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 the above steps, only this time create the ‘Client Last Name’ column:

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 was introduced at the beginning of this guide:

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

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

And this is how your Access table would look like:

Create table in MS Access

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

This ID column contains 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, you’ll see how to delete a table in Access.

How to Delete a Table in MS Access

Say that you no longer need a table. In this case, you may choose to delete that 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 on the Delete button as follows:

Delete button in MS Access

(3) Finally, select ‘Yes‘ to delete the 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 just use the keyboard shortcut of CTRL+Z):

undo delete of MS Access table

Conclusion

You just saw how to create a table in MS Access 2016, as well as delete a table that is no longer needed.

The same principles would also apply in previous versions of Access.

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