graphic2
graphic1

Exam 77-424: Microsoft Access 2013
2.0 Build Tables
2.4 Create and Modify Field: Add Fields to Tables

Edit the Fields

2. Try it: Edit the Fields

Enter the following, please:

 

Field Name: MovieSearchID

Data Type: AutoNumber

 

Field Name: Rating

Data Type: Short Text

 

Field Name: Genre

Data Type: Short 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