In this short guide, I’ll show you the steps to create columns in Access.
In particular, I’ll show you how to create 3 columns:
- The first column would contain the First Names of 5 individuals
- The second column would contain their Last Names
- The third column would contain the Age of those individuals
Steps to Create Columns in Access
To start with a simple example, let’s say that you created an empty table in Access called ‘Names.’
You can open your table in Access by double-clicking on the table’s name under the All Access Objects menu:
At this point, the table would be empty. The goal is to add 3 columns to that table.
To add the first column, press on ‘Click to Add‘ as follows:
You’ll now see a drop-down menu, where you can select the format for your column:
For example, let’s say that you want to store the first names of the individuals under your first column. In that case, choose the Short Text format.
The ‘Short Text’ format seems to be suitable, considering that names are usually short in nature.
Next, type a name for your newly created column. In our example, type ‘First Name‘ for the first column:
You can now create a second column to represent the ‘Last Name‘ (with a Short Text format):
Finally, create the third column to represent the age of the individuals. For this column, select the ‘Number’ format:
Then, name that column as ‘Age‘:
You should now have your 3 columns ready.
Now it’s time to add some information under those columns.
To add information under a specific column, simply type your desired values under that column.
For illustration purposes, I typed the following values:
Your table, with the 3 columns, should now be completed.
Changing the Order of the Columns
Another feature offered by Access is the ability to change the order in which columns are displayed.
Let’s say that you want to place the ‘Age’ column prior to the ‘First Name’ column. In that case, simply drag the ‘Age’ column to the left, and then drop it before the ‘First Name’ column:
Deleting Columns in Access
To delete a column in Access (for example, the ‘Age’ column), right-click on the column that you want to delete, and then select Delete Field:
Once you are ready, click Yes and your column will be deleted: