O'Reilly logo

Microsoft Access 2013 Inside Out by Jeff Conrad

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required