Access: Now Playing Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24

Table Tools -> Design -> View-> -> Datasheet View

Test the Required Field

Go back to the Datasheet View

Go to Table Tools-> Design

Click on View

Select the Datasheet View

 

Try it: Add a new record

Type the following information:

Year: 2007

Rating: R

Genre: Comedy

Star: Johnny Depp

 

When you try to save the record—by clicking the pencil on the record selector or by going to Save—you will get an error message demanding that you enter a value in this field.

Click on OK

 

Enter the movie title: At World's End Now you can save the record.