Add New Fields to the
Table
The Movie
Table needs a Field that indicates a Record should be archived and
marked as no longer part of the daily rentals. The Archived Field
can be as simple as Yes/No.
Before
You Begin: Open the Table
Go to
All Access Objects->Tables.
Select a
Table: tblMovies.
Go to
Home ->Views->View->Design View.
The Table Tools should be
available.
4. Try
This: Add a New Field
Field Name:
Archived
Data Type:
Yes/No
What Do You See? By
default Microsoft Access uses a check box for this Control. A "Yes"
answer means True or On. A "No" answer means False or Off.
Keep going...