Create a Table in Access 2010

Do you need to create a table in Access in order to store and manage your data? In this post, I’ll show you how to create a table in Access 2010.

 

To illustrate how to create a table in Access, we will review a simple example, where:

(1) you are the owner of a store that sells office supplies; and

(2) you’d like to store information about your products across the following 3 categories:

• Product ID;

• Product Name; and

• Product Price

 

To achieve this goal, you decide to create a table in Access that would look as follows:

 

Table in Access 2010

 

In the upcoming sections, I will show you the steps needed to create the above table in Access.

Steps to create a table in Access 2010

(1) To start, press the ‘Create’ tab

(2) Then, press the ‘Table’ icon

 

Create a Table in Access 2010

 

(3) You’ll now see that a new table is created with a default name of “Table1”

This default table currently contains no information.

 

New Table in MS Access

 

(4) In order to add a new column (i.e., field) into your table, you’ll first need to click the small arrow next to the Click to Add

(5) A drop-down menu will now appear on the screen, where you will be able to choose the format of your field.

In our example, the first field that we would like to add is ‘Product ID.’ Since the IDs are numbers, you’ll need to select the ‘Number’ format from the drop-down menu:

 

Number format in Access 2010

 

(6) Now you will be given the opportunity to type your column/field name. For our first column, type the name ‘Product ID’

 

Field in MS Access

 

(7) This is how your new column would look like:

 

Type field name in MS Access

Adding more columns to your table

In this section, we will add more columns to our table:

• Product Name; and

• Product Price

 

(1) To start, click the small arrow next to the Click to Add

(2) From the drop-down menu, select the ‘Text’ format to represent the ‘Product Name’ field

 

Text format in Access 2010

 

 

(3) Now, type ‘Product Name’ to reflect the name of your second column. This is how your Access screen would look like:

 

Adding columns to your Access table

 

(4) Finally, to add the last column of ‘Product Price’ to your Access table, first click the small arrow next to Click to Add

(5) Then, select the ‘Currency’ format to represent your ‘Product Price’ field

 

Currency format in Access 2010

 

(6) Lastly, type the name ‘Product Price’ to reflect the name of your third column:

 

Field name in Access

Add information into your table

So far we have seen how to create a table in Access, and added 3 columns into it.

Now you are ready to add information into your table.

Under each of the columns, simply click on each cell and type the following information:

 

Add information into your Access table

 

You just filled the first row (i.e., record) for your table. To fill additional rows, simply click on each cell, under each of the 3 columns, and type the following information:

 

Type inside your MS Access table

 

Congratulation! You just created a table in Access with 5 rows/records as above. Do not forget to save your table:

Save your table in Access

(1) To save your table in Access, right click on the tab that contains the default name of your table (i.e., ‘Table1’)

(2) Select ‘Save’ from the drop-down menu

 

Save a table in Access 2010

 

(3) A new ‘Save As’ box will be populated on the screen, where you can type your desired table name. Here, type ‘Products’ to represent your table that contains information about your products

(4) Press ‘OK’ and you’re done!

 

Save table in Access

 

(5) To access your newly saved ‘Products’ table at any time, simply double-click on the name of your table (i.e., Products) that is located under the All Access Objects menu on the left-hand-side of your screen:

 

Open table in MS Access