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...

Home ->Views->View->Design View

Exam 77-885: Microsoft Access 2010

2. Building Tables

2.2. Create and Modify Fields: Modify the Field Properties Yes/No