Microsoft Access 2013 Inside Out

Chapter 11. Modifying your table design

Before You Get Started

Deleting tables

Renaming tables

Changing field names

Moving fields

Inserting fields

Copying fields

Deleting fields

Changing data attributes

Reversing changes

Taking a look at Lookup properties

Working with Multi-Value Lookup Fields

Compacting your database

NO matter how carefully you design your desktop database, you can be sure that you’ll need to change it at some later date. Here are some of the reasons you might need to change your database:

• You no longer need some of the tables.

• You need to perform some new tasks that require not only creating new tables but also inserting some linking fields in existing tables.

• You need to perform some new tasks that require not only creating new tables but ...