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

Refining Field Names

Let's do a little work to improve the field names. As in database design, naming conventions are, to some extent, a matter of personal preference. But you should be aware of some useful rules. A field name should appear only once in each database. In databases in which you have much contact information, you could have several tables—Customers, Suppliers, Shippers, and so on—that have a field named Address. In the Classic TV database, this problem is less pronounced. But in Table 3.26, you still have duplicate fields, such as First Name and Last Name in the Actors and Roles fields.

A good way to resolve this duplication is to prefix each field with the name of the table. Some database designers like to include a table prefix ...

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