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

Get Hands-On Microsoft Access: A Practical Guide to Improving Your Access Skills 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.