---
title: "Create Table in MS Access"  
description: "Create Table in MS Access"  
author: "AVADHESH PATEL"  
published: 2013-04-01  
updated: 2019-09-07  
canonical: https://www.mindstick.com/articles/1180/create-table-in-ms-access  
category: "ms access"  
tags: ["ms access"]  
reading_time: 2 minutes  

---

# Create Table in MS Access

A [database table](https://www.mindstick.com/forum/159366/how-to-test-regular-expressions-in-sql-without-using-database-table) is similar in look as [spreadsheet](https://answers.mindstick.com/qa/31730/explain-spreadsheet-and-its-basics), in that data is stored in [rows and columns](https://answers.mindstick.com/qa/109503/how-to-freeze-rows-and-columns-in-excel). The main [difference](https://www.mindstick.com/articles/157114/good-news-or-bad-news-and-the-difference-is) between storing your data in a spreadsheet and storing it in a database is in how the data is organized.\

Each row in a table is [referred to as](https://answers.mindstick.com/qa/97098/which-layers-are-referred-to-as-network-support-layers) a record. Records are where the individual pieces of information are stored. Each record consists of one or more fields. Fields correspond to the columns in the table. Fields must be [designated as](https://answers.mindstick.com/qa/38228/what-is-the-name-of-national-park-of-sikkim-which-has-been-designated-as-india-s-first-mixed-site-on-the-unesco-world-heritage-list-by-fulfilling-the-criteria-under-both-natural-and-cultural-heritage) a certain data type, whether it's text, date or time, number, or some other type.

##### Figure 1:

![Create Table in MS Access](https://www.mindstick.com/mindstickarticle/63eda682-e9e3-47fb-9559-40e6be80746b/images/fbed733a-ab51-497e-a6dd-db4160e84975.png)

1. A record

2. A field

3. A field value

Now, I’m going to describe, how to create access table. Steps are given below

Step 1: First open Microsoft Access and give database name. Table is created under database.

Step 2: Select “Table Design” option from “Create” menu as given image

##### Figure 2:

![Create Table in MS Access](https://www.mindstick.com/mindstickarticle/63eda682-e9e3-47fb-9559-40e6be80746b/images/d9e6253c-f194-49e1-96e0-5b396125d412.png)

Step 3: After selecting “Table Design” option where you set [column name](https://www.mindstick.com/forum/529/rename-table-name-and-column-name-using-sql-query), data type etc., my [table structure](https://answers.mindstick.com/qa/113649/what-is-the-database-table-structure-of-url-analyzer-details-to-store) display as below image

##### Figure 3:

![Create Table in MS Access](https://www.mindstick.com/mindstickarticle/63eda682-e9e3-47fb-9559-40e6be80746b/images/1d6bea7a-c82d-4682-b1fa-fe250a745df2.png)

Note: Design your table with a primary key. Here I have set “Emp ID” column as primary key.

You can set property of column according your required into “Field Properties” as below image.

##### Figure 4:

![Create Table in MS Access](https://www.mindstick.com/mindstickarticle/63eda682-e9e3-47fb-9559-40e6be80746b/images/26f4f381-267b-42c7-a60a-438855bb6316.png)

After design table [structured](https://yourviews.mindstick.com/view/88498/underbust-corset-styling-guide-for-structured-everyday-looks), save it with a unique name. Here I have given my table name is “Emp_Details” see in figure 3.

Step 4: Now open your table and fill some record as below image. Created table are visible in left hand side of your access sheet.

##### Figure 5:

![Create Table in MS Access](https://www.mindstick.com/mindstickarticle/63eda682-e9e3-47fb-9559-40e6be80746b/images/80f06775-16dd-4698-be61-3e7886094476.png)

---

Original Source: https://www.mindstick.com/articles/1180/create-table-in-ms-access

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.