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.

28 Required