Question

Which properties in an Access database table would you use to limit a user's entry to two characters and automatically convert the entry to uppercase?

A. Input Mask and Required
B. Field Size, Validation Rule, Validation Text, and Required
C. Field Size and Format
D. Validation Rule and Field Size
E. None of the above

Answer 1

To limit user entry to two characters and ensure uppercase in an Access database, use 'Field Size' set to 2 and 'Format' with the value ">>", which converts text to uppercase.

Step-by-step explanation:

To limit a user's entry to two characters and automatically convert the entry to uppercase in an Access database table, you would use the Field Size and Format properties.

The Field Size property sets the maximum number of characters that can be entered in the field, so you would set this to 2. The Format property can be set to ">>", which converts all letters to uppercase.

Therefore, the correct answer to the question would be option C: Field Size and Format.