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!

Microsoft Access 2010: Example of Form that looks up data from a separate Table
 

Exam 77-885: Microsoft Access 2010

2. Building Tables

2.1.1. Create tables in Design View: Create Tables that do not have repeating groups