Edit the Fields

2. Try it: Edit the Fields

Enter the following, please:

 

Field Name: MovieSearchID

Data Type: AutoNumber

 

Field Name: Rating

Data Type: Text

 

Field Name: Genre

Data Type: Text

 

Try This, Too: Create a Primary Key

Select a Field: MovieSearchID

Go to Table Tools ->Design->Tools.

Click on Primary Key.

 

What Do You See? The MovieSearchID Field has the symbol for the Key. In the Field Properties, the values are Indexed (yes), so that there will be no duplicates.

 

Keep going...!

Table Tools ->Design->Tools->Primary Key

Exam 77-885: Microsoft Access 2010

2. Building Tables

2.1.1. Create tables in Design View