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

Text

To enter text, phone numbers, or zip codes.

Memo

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

Number

To add numbers and decimals.

Currency

To display numbers as currencies.

AutoNumber

To have Access automatically number each record.

Date/Time

To include date or time in a cell.

OLE Object

To embed other objects such as graphics, or documents.

Hyperlink

To link to websites or link to intranet sites.

Yes/No

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

Attachment

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

Calculated

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.

Comments

  1. Lyndon says

    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 says

      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 says

        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!

    • LAURA says

      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.