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

Review the Movie Table 4. Try This: Review the Movie Table Go to All Access Objects->Tables. Select a Table: tblMovies. Go to Home->Views->View->Design View.   What Do You See? The Movie Table does not have a Field that indicates the rental price. There are Fields for the Movie, Year, Rating, Genre, and even the Stars. No money. No Rental Price.   Sooooo, since most businesses are in business to make money, we should probably do a little more programming in the Front Row Video database, hmmm?   Tables can work together when they share a common Field. The best Field to create a relationship between two Tables is the Primary Key. It is an AutoNumber (each number is unique) and it is Indexed so it is very fast.   Home->Views->View->Design View.