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

Chapter 5. Building Tables

Chapters 1, “Getting Started,” 2, “Database Design,” and 3, “Understanding Relationships,” explained in general terms how to conceive and construct tables in a relational database, as well as how to develop relationships among them. Chapter 4, “Establishing Relationships,” pivoted the discussion toward Access explicitly and described how to formally establish relationships in the program.

Building on these basics, Chapter 5 focuses on the specifics of creating tables in Access. The process includes topics I have mentioned in a general context, such as designating primary keys, assigning data types, and naming fields. But much of the discussion is on new subjects, notably field properties such as Field Size and Validation ...

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