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.