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

Viewing and Creating Relationships

In Chapter 2, “Database Design,” you developed tables and fields for the Classic TV database. In Chapter 3, you identified the existing relationships between tables and developed the final field list shown in Table 4.1. (If you haven't read these two chapters, I strongly encourage you to do so before proceeding.)

Table 4.1. Classic TV Database Final Field List
ProgramsBroadcastsGenresNetworksActorsRoles
ProgramID PKProgramID CPK/FKGenreID PKNetworkID PKActorID PKProgramID CPK/FK
ProgNameNetworkID CPK/FKGenreNameNetwOfficial NameActorFirst NameActorID CPK/FK
GenreID FKBrdYearStartGenreDescrNetwPopular NameActorLast NameRoleFirst Name
ProgLocationBrdYearEnd NetwFounderActorGenderRoleLast Name
ProgSynopsis  NetwNotes ...

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