Administrator: Rave Reviews Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 More

Modify the Table

This database needs a field to indicate whether a movie is available or archived. A Yes/No field offers a simple choice.

 

Try it: Add a Yes/No field

Open tblMovieTitles

Go to the Design View.

 

Enter a new field: Archive.

Data Type: Yes/No.

 

By default, Microsoft Access uses a check box for this control. "Yes" means True or On. "No" mean False, or Off.

Home -> View->Design View
 

 

  Microsoft Access 2007 Exam 77-605 Topic: 2. Creating and Formatting Database Elements 

  2.4. Create fields and modify field properties: Yes/No fields