You work as a Database Designer for Tech Perfect Inc. The company has a Windows-Vista based
computer with Microsoft Office 2010 installed on it. The company uses a Microsoft Office 2010
database named HumanResource. The database contains a table named Employees. You want to
define a set of rules for table’s column so that the no one can enter invalid data in the table. Which
of the following table properties will you use to accomplish the task?
A.
Input mask
B.
Caption
C.
IME mode
D.
Validation rule
Explanation:
In order to accomplish the task, you should use the validation rule property. A validation rule is a set
of rules associated with a column so that a user is restricted from entering invalid data. A user can be
restricted from entering data through the following options:
Datatypes: When a field is assigned to a datatype, data of another type cannot be inserted in the
field.
Field size: The field size restricts the amount of data to be inserted in a table.
Table Properties: Certain table properties such as Required forces a user to enter data or the Format
property forces a user to enter data in a defined format.
A validation rule can be applied by using the Validation Rule property. A user can be intimated about
the invalid data through the Validation Text property.
Answer B is incorrect. The value of the Caption property is displayed as text on a Label control in a Form.
Answer A is incorrect. The Input Mask property is used to change the format of a field having the
Text or Date/Time datatype. This property provides the formats for different types of data such as
zip-code, phone, date, time, password etc. When the Input Mask property is set for a field, a user
should fill the data in the same format. Any other format is either converted to the given format or
remains as it is.
Answer C is incorrect. The IME Mode property is related to East Asian languages.