Access 2016 Intermediate

Lesson 2 – Modifying Tables

Access 2010

Renaming a column

NOTE Rename a column by right-clicking its heading and selecting Rename Column . Column names can contain spaces, numbers, and many special characters; a column name, however, cannot include a period ( . ), an exclamation point ( ! ), or square brackets ( [ ] ). The column heading is also called the field selector.



Procedures

1. Open the desired table in Datasheet view. 2. Double-click the heading of the column you want to rename. 3. Type the desired column name. 4. Press [Enter] .



Step-by-Step

Change a column name.

If necessary, open the Items table in Datasheet view.

Page 38

OFFICEPRO, Inc.