How to Create a Microsoft Access Field for Notes and Text

An Access text field can contain both numbers and text (as you might find in a street address or a zip code). MS Access will not perform calculations on the numbers in a text field. These instructions are for Microsoft Access 97.

Instructions

Difficulty: Moderately Easy

Things You’ll Need:

• Microsoft Access

1. Open your table in Design view.
2. Click in the row directly below the field where you want to position your new field.
3. Click on the Insert Row icon from the toolbar, or use Insert Row from the Insert menu. A new row appears.
4. Click in Field Name in your new field.
5. Name your field.
6. Click in the DataType column immediately to the right. An arrow appears.
7. Click on the arrow. A menu or datatypes appears. Select Text.
8. Save your table.

Tips & Warnings

• Use the Field Properties box to set the field size (the number of characters that can appear in the field).

Who Can Help:

• Find Computer, Electrical and Telephone Services Here. Compare Up to 4 Quotes, Free Service & No Obligation.
• Find Electrical Services Here. Compare Up to 4 Quotes, Free Service & No Obligation.