Adding and Deleting Fields - Exercise Result

Completion Confirmation

Thank you. You have been credited with completing this exercise.

This exercise asked you to use Design View to add two Yes/No fields to the Projects table, then switch to Datasheet View to enter sample values.

Expected outcome

The Projects table contains two new fields: Completed and Paid (both data type Yes/No).
In Datasheet view, the first five projects are marked Completed = Yes.
In Datasheet view, the first three projects are marked Paid = Yes.

Design View reference

Projects table in Design View showing fields including Completed and Paid with Yes/No data types. — Design View: the new fields **Completed** and **Paid** appear in the field list and both are set to the **Yes/No** data type. Field Properties display settings for the selected Yes/No field.

Datasheet View reference

Projects table in Datasheet View showing Completed and Paid checkbox fields with sample values selected. — Datasheet View: **Yes/No** fields display as checkboxes. In the sample result, the first five projects are marked **Completed**, and the first three are marked **Paid**.

How the Yes/No fields behave

To define new Yes/No fields, you must create them in Design View and choose Yes/No from the Data Type drop-down list. After saving the table design, you can enter values in Datasheet View.

Click a checkbox to toggle between Yes (checked) and No (unchecked).
You can also press the Spacebar to toggle the value when the checkbox cell is selected.

Return to Exercise