How to Create Columns in Access (example included)

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:

Empty table

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:

How to Create Columns in Access You’ll now see a drop-down menu, where you can select the format for your column:

Short Text

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.

How to Create Columns in Access

Next, type a name for your newly created column. In our example, type ‘First Name‘ for the first column:

Naming a column in Access

You can now create a second column to represent the ‘Last Name‘ (with a Short Text format):

Column Name

Finally, create the third column to represent the age of the individuals. For this column, select the ‘Number’ format:

Number Format

Then, name that column as ‘Age‘:

Create Columns in Access

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:

Table with data

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:

How to Create Columns in Access

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:

Delete column in Access

Once you are ready, click Yes and your column will be deleted:

Message Box