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

Get Microsoft Access 2013 Inside Out now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial