Access 2016 Intermediate

Access 2010

Lesson 2 – Modifying Tables

Steps

Practice Data

1. Double-click the heading of the column you want to rename. The column heading is selected . 2. Type the desired column name. The text appears in the column heading .

Double-click the Field1 column heading

Type Vendor

3. Press [Enter] .

Press [Enter]

Both the column and its corresponding fields are renamed .

D ELETING A C OLUMN



Discussion

You can delete a column from a table. When a column is deleted, the columns to the right of it automatically adjust.

In addition, if other database objects (such as lookup tables) contain references to a deleted field, the appropriate error messages will be generated.

NOTE Delete a column by right-clicking its heading and selecting Delete Column . You cannot delete a field that has a relationship to another table unless you first delete the relationship. All data contained in a deleted column is permanently deleted as well, and you cannot undo the deletion.



Procedures

1. Open the desired table in Datasheet view. 2. Click in the column you want to delete. 3. In the Table Tools contextual section, select the Fields tab.

4. Select the Delete button

in the Add & Delete group.

OFFICEPRO, Inc.

Page 39