Example of Second Normal
Form
When you
study database normalization, the emphasis is on the Tables.
And rightly so: Tables are the bones of the database structure.
However, most people only see a database as the Forms they work
with.
What would
a Second Normal Form look like to a User? A Form with a Combo Box is
one good example. The Combo Box on the Movies Form looks up
the Rating in tblRating.
Try it: Review the
Relationship
Go to All Access Objects ->Form.
Select a Form: Movies.
Double-click the Form to
open it in Form View.
What Do You See? The Combo Box has a list of Ratings from tblRating.
Memo from the Computer Mama: Feel free to go
beyond this simple design and make a more appealing Form! This one is uggggggly!