Advanced Database – Set data entry for a field/column: required, not required
Open the ‘Jobs’ table in design mode.
If we want to ensure that data is always entered for a certain field, click on the relevant field.
In the Field Properties box at the bottom of the screen, select ‘Yes’ from the drop-down menu next to ‘Entry required’.
To make it so entry for that field is not required, then make sure ‘No’ is selected from the drop-down menu.