You have field ‘Sex’ of type Byte Number. How to limit its value to 0 and 1 only?

Related MCQs

• Which field type will you select when creating a new table if you require to enter long text in that field?
• The common field linking the two datasheets is the _______________ key field in the main datasheet and the _______________ key field in the linked datasheet.
• In Access to Refresh the contents of a Lookup field (Lookup field: A field, used on a form or report in an Access database, that either displays a list of values retrieved from a table or query, or stores a static set of values.) list box or combo box
• How can you define a field so that when entering data for that field it will display ****** instead of actual typed text
• While creating relationship, when you drag a field of a field to drop into another table the mouse pointer changes into
• After right click the field selector button, which do you choose to delete a field in design view?
• This form displays the field name labels down the left side of the column, with the data for each field just to the right of its corresponding label.
• The quickest way to add a field to the selected fields list is to double-click its field name in this list.
• To create a new table, in which method you don’t need to specify the field type and size?
• After entering all fields required for a table, if you realize that the third field is not needed, how will you remove?