How to Set Not Null in MS Access

Quick summary

Setting a field to Not Null in MS Access ensures that a database column always contains a value, preventing incomplete records. You can enforce this constraint through the Design View by toggling the Required property to Yes in the Field Properties panel.

Steps

1. Open your database in MS Access.
2. Go to the Navigation Pane, right-click the table you want to modify, and select Design View.
3. Click the field you want to set as NOT NULL.
4. In the Field Properties section at the bottom, locate the Required property.
5. Click the drop-down arrow and set the Required property to Yes.
6. Click the save icon to save your changes.