• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 4. Working with Fields > Inserting, Deleting, and Reordering Fields

Inserting, Deleting, and Reordering Fields

You can insert, delete, and edit fields in your database tables in Design view. In Design view for tables, each row corresponds to a field. You can add a field by inserting a new row that contains the field name, data type, and other properties. You can delete a field by removing a row. You can also change field order by re-ordering the rows to better suit your data entry needs. Using Design view for tables makes these tasks easy.

Insert a New Field

In the Database window, click Tables on the Objects bar, click the table in which you want to insert a new field, and then click the Design button.

Click the row selector for the field that will be below the new field you want to insert.

Click the Insert Rows button on the Table Design toolbar.

A new blank row appears above the row you selected.

Click the Field Name cell for the row you inserted, type the name of the new field (up to 64 characters), and then press Tab.

Click the list arrow in the Data Type column, click the data type you want to assign to the field, and then press Tab.

Type a brief description of the new field (up to 255 characters).

Set additional field properties in the property sheet, if appropriate.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint