Access 2016 Intermediate

Access 2010

Lesson 2 – Modifying Tables



Procedures

1. Open the desired table in Datasheet

view.

2. Click the down-arrow in the last visible column. 3. Choose the desired field type.



Step-by-Step

From the Student Data directory, open MODTAB1.ACCDB . Insert a column into a table.

Open the Items table in Datasheet view.

Steps

Practice Data

1. Click the button on the last visible column. A short list of field types appears.

Click

2. Click the Text field.

Click

A new column is inserted into the table.

C HANGING A C OLUMN N AME



Discussion

A column name should clearly indicate the information contained in the column to make working with data easier. When you rename a column, you are also changing the corresponding field name; keep in mind that you cannot create duplicate field names.

Column names can be up to 64 characters long, but shorter names are recommended.

OFFICEPRO, Inc.

Page 37