6

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.

0
Shares
Adeline Gear
 

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 android-resources.net.

Click Here to Leave a Comment Below 6 comments