O'Reilly logo

Hands-On Microsoft Access: A Practical Guide to Improving Your Access Skills by Bob Schneider

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

Making Changes to Tables and Fields

As with most other things in life, tables sometimes need to change. You might have to modify field names, change data types, adjust field sizes, or add fields. Before you make any significant or extensive changes, be sure to back up your original tables.

TIP Access 2003 makes it easy to back up your database. In the Database window, choose File, Backup Database. In the Save Backup As dialog box, navigate to a convenient folder and save the file.

Modifying Field Names

In earlier versions of Access, the surest way to wreak havoc on your database was to change a field name. For example, you might have edited the name of a field that was in one or more queries. Access would then be baffled about where to retrieve ...

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