Access 2016 Intermediate

Lesson 2 – Modifying Tables

Access 2010

5. Select

to confirm the deletion.



Step-by-Step

Delete a column in a table.

If necessary, open the Items table in Datasheet view.

Steps

Practice Data

1. Click in the column you want to delete. The insertion point appears in the column. 2. Select the Fields tab in the Table Tools contextual tab The Fields ribbon appears. 3. In the Fields & Columns group, select the Delete icon. A Microsoft Office Access warning box asks you to confirm the deletion . 4. Select Yes to confirm the deletion. The Microsoft Office Access warning box closes, and the column is deleted.

Click anywhere in the Vendor column

Click

Click

Click

Close the Items table.

I NSERTING A L OOKUP C OLUMN



Discussion

A lookup column looks up data stored in another data source, thereby eliminating the need to search for information when you add a record. In addition, a lookup column saves time because it reduces the amount of information you type and increases accuracy because a list of available data values is provided.

The Lookup Wizard can assist you in creating a lookup column. The values in a lookup column can come from another table or a query, or you can create your own list. For

Page 40

OFFICEPRO, Inc.