graphic1

Exam 77-424: Microsoft Access 2013
2.0 Build Tables
2.4 Create and Modify Fields: Add Fields to Tables

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

graphic2