Access 2016 Intermediate

Lesson 2 – Modifying Tables

Access 2010

I NSERTING A C OLUMN INTO A T ABLE



Discussion

You may find it necessary to add fields to a table. One way of doing this is to insert one or more columns into the table. Inserting a column automatically adds a new field to the table.

There are different methods for inserting a new column/field. Access 2016 uses the contextual tab – Fields. Add or delete fields as needed. The Fields tab allows for inserting a field type which is already defined as Text, Number, or Currency.

Inserting a Text field

Insert a column by right-clicking any column heading and selecting Insert Field . After adding a column, change the default field name to one that clearly identifies its contents.

Page 36

OFFICEPRO, Inc.