|
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 indentified 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
Exam 77-885: Microsoft Access 2010
2. Building Tables
2.4. Set relationships: Define
Primary Keys
|
|
| |
