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

Organizing Fields into Tables

Let's get back to developing the Classic TV database. Table 2.6 shows the current list of fields. The list has been modified from that in Table 2.2 to reflect our bad experience with multiple actor fields in the “one-table-fits-all” solution. Thus, instead of fields for Actor Name #1, Actor Name #2, and so on there is just one Actor Name field. The same is true for Actor Gender, Actor Biography, and Character Name/Occupation.

Table 2.6. Classic TV Database

Revised Field List
Field	Field Description	Sample Value
Program Name	Official title of show	Bewitched
Network Official Name	Official name of network	American Broadcasting Company
Network Popular Name	Abbreviation of official name	ABC
Network Founder	Leading organizer	Leonard Goldenson ...