Adding and Deleting Fields - Exercise

Objective

Use Design view in Microsoft Access to add two Yes/No fields to the Projects table, then switch to Datasheet view to enter sample values.

What you will do

In this exercise you will add two new Yes/No fields: Completed and Paid. After the fields exist, you will populate the first few rows to confirm you understand how Yes/No fields behave (checkbox / True/False).

Instructions

1. Open the Projects table.
2. Switch to Design View and add two new fields:
   • Completed (Data Type: Yes/No)
   • Paid (Data Type: Yes/No)

   Place them near the end of the table (after the existing fields) to keep the design readable.

3. Save the table design changes.
4. Switch to Datasheet View and enter values:
   • For the first five projects, set Completed to Yes/True (checked).
   • For the first three projects, set Paid to Yes/True (checked).
5. When finished, click Submit. (The workflow continues on the exercise result page.)

Completion notes

This exercise is auto-scored. You receive full credit by completing the task and submitting the form. If your instructor or workflow requires notes, you may briefly describe what you changed below.