# How to Use Yes/No Datatype MS Access

> To use the Yes/No datatype in MS Access, open the database and navigate to the table in Design View. Type the field name, select Yes/No in the Data Type column, and save the changes. The field will appear as a checkbox.

Canonical: https://livedemo.ai/tutorials/how-to-use-yes-no-datatype-ms-access/
Updated: 2026-10-05
Interactive demo: https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a5289ab56e05a00fffbfc/preview?step=1

## Steps

1. Open the database.
2. Navigate to the table where you want to add the Yes/No field. Click on the 'Design View' for the table.
3. In the 'Field Name' column, type the name for the field.
4. In the 'Data Type' column, select 'Yes/No'.
5. Save the changes to your table by clicking the save icon.
6. The Yes/No field can appear as a checkbox.