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

Create the Genre Table In the beginning of this book we created a Rating Table to add Rating data to the Movie Table. In this lesson, we will create the Genre Table and use it to filter data in the Movie Table.   1. Try it: Create a New Table The Database is open. Go to Create ->Tables->Table Design. Enter a Field Name: GenreID. Data Type: AutoNumber.   GenreID is still selected. Go to Table Tools->Design->Tools. Click on Primary Key.   Enter a Field Name: Genre. Data Type: Short Text.   Do This, Now: Save the Table Go to File->Save. Enter a Table Name: tblGenre Click OK. So far, so good. Keep going... Create ->Tables->Table Design