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.
While this post focuses on Access 2016, the same principles apply to previous versions of MS Access.
By the end of this tutorial, you’ll be able to create the following simple table in Access:
|Client First Name||Client Last Name|
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:
(2) Then, click on the Table icon:
(3) A new table would be created with a default name of ‘Table1:’
(4) To save your table with a different name, right-click on the tab that displays the default name of ‘Table1.’
(5) Then, from the drop-down menu, choose Save:
(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 chose to save my table as ‘Clients’
(7) 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:
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’:
(2) You’ll now see a drop-down list, where you can select the desired format for your column:
(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.
(4) Type the title name for your newly created column. In our example, type ‘Client First Name’:
(5) Repeat step#4, only this time create the column ‘Client Last Name’:
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 tutorial:
|ID||Client First Name||Client Last Name|
To get this 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) 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 that 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:
(2) Then, press on the Delete button as follows:
(3) Finally, select ‘Yes’ to delete the table:
(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):
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 to previous versions of Access.
You may also want to check the following source for additional tutorials on MS Access 2016.