Edit the Field Name

The first Field in tblMovies is the Primary Key. The Data Type for the Primary Key is AutoNumber, which means that it is an Integer (a Whole Number) and that it increments automatically. It is indexed so that there are no duplicate numbers.

 

7. Try it: Rename the ID Field

Select the Field: ID

Type a New Name: MovieID 
 

Do This: Save the Table

Go to File->Save.

 

And Do This: Change the View

Go to Table Tools-> Design->Views.

Select a View: Datasheet View.

 

Done and done.

Exam 77-885: Microsoft Access 2010

2. Building Tables

2.2. Create and Modify Fields: Rename a Field

Table Tools ->Design