How to Use Yes/No Datatype MS Access

Quick summary

The Yes/No datatype in Microsoft Access lets you store boolean values as a checkbox field in any database table. This tutorial walks you through opening a database, switching to Design View, and configuring the field so it appears as a checkbox for quick true/false data entry.

Steps

1. Open the database in Microsoft Access.
2. Navigate to the table where you want to add the Yes/No field, then click Design View.
3. In the Field Name column, type the name for the new field.
4. In the Data Type column, select Yes/No from the dropdown.
5. Save the changes to your table by clicking the save icon.
6. Confirm that the Yes/No field now appears as a checkbox in your table.