Exam 77-424: Microsoft Access 2013 4.0 Create Forms 4.1 Create a Form: Create Forms with a Subform

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: Example of Form that looks up data from a separate Table