Exam 77-424: Microsoft Access 2013 1.0 Create and Manage a Database 1.2 Manage Relationships and Keys: Set Primary Key Fields

Example of First Normal Form Definition of First Normal Form: First Normal Form requires that each Table should have only one value for each Field in a Table.   The Movies Table is a good example of a Table that is in First Normal Form. Each Movie has only one Year, one Rating and one Genre.   Try it: Review the Data Go to All Access Objects ->Tables. Select a Table: tblMovies Double-click the Table to open it in Datasheet View.   What Do You See? There are 401 records in tblMovies. There is one Record for each movie. Each movie is identified by a Primary Key: MovieID.   What Don't You See? There is no information about customers or which customer rented which movie. This Table has data about movies, only movies.   Close tblMovies, please. Example of a Table from a beginning lesson in First Normal Form