The App Times

Access 2010: How to Add a Field to a Table

Data that you enter in Access is stored in tables. Tables contain tiny bits of information within cells. This information is also called as fields. Fields can be of various types such as numbers, text, hyperlinks, alphanumeric information and more. Depending on the type of data you wish you enter in the table, you can select a data type. In this post, I will explain how to add a field to a table and also explain which data type supports the information you enter in a cell.

Data Types in Access 2010

Data Type

When to Use


To enter text, phone numbers, or zip codes.


To enter large amount of text; up to 65,536.


To add numbers and decimals.


To display numbers as currencies.


To have Access automatically number each record.


To include date or time in a cell.

OLE Object

To embed other objects such as graphics, or documents.


To link to websites or link to intranet sites.


To store one of two values such as a Yes or No, Correct or Incorrect.


To attach files to a record such as spreadsheets, graphics, documents and more.


To enter a formula and display the results of the calculations.


How to Add a Field to a Table

1. Create a table.

2. On the Table Tools Fields contextual tab, in the Add & Delete section, select a data type. for instance select Date & Time.

How to Add a Field to a Table

3. Enter a field name and press tab.

access 2010-add fields-1

4. The Click to Add drop-down list is automatically displayed with the available data types.Select the data type for the next field and press Tab.

5. Continue to add the data types as required for the fields until your table header is created.

(Visited 5 times, 1 visits today)

Get the latest update in your inbox.

Subscribe to our mailing list and get tips, tutorials, and app reviews in your email inbox.

Adeline is a tech enthusiast who loves exploring the latest tools and applications in the marketplace. She also loves her Android and spends time reviewing apps and games on

View all contributions by

    Comments on this entry are closed.

    • Lyndon November 30, 2010, 11:30 pm

      Here’s a silly question to which I should know the answer: How does one add a new field to an existing table, other than by creating a whole new table? When I open an existing table (created under a previous version of Access), NO “FIELDS” TAB SHOWS UP.

      • Eddie Gear December 3, 2010, 5:20 pm

        That’s odd ! I tried the same myself and did not have any difficulies. Please check if the table is displayed in datasheet view. (On the Views group, click View and select Datasheet.)That’s when you can view the table tools contextual tab and the FIELDS tab.

        • yasmin Cardona August 14, 2011, 10:11 pm

          I’m having the same problem as Lyndon I even added a field in the design view, but it just makes it” unbound”- and when I switch back to the datasheet view, I cannot see any table tools, or change the default field name of Text 451. Please HELP!

          • Eddie Gear August 17, 2011, 6:55 pm

            Hey Yasmin. Is this a linked table?

    • Sen Mack September 6, 2011, 2:25 pm

      I am having exactlythe same problems. I just want to add a field in an existing table.

      • LAURA November 16, 2011, 5:05 am

        I have a different issue with my Access 2010 table but ran across your posts, in researching my problem. In navigating around, I believe I found what you’re looking for. You will want to click on table, go to view in “Design”. along menu bar you should see “Form Design tools” now. the “design” tab has “add existing fields”. If you’re not running 2010, may not be same format.