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…

Question

Options

• AInput mask
• BCaption
• CIME mode
• DValidation rule

• A
  3% (1)
• B
  7% (2)
• C
  10% (3)
• D
  79% (23)

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 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 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.

No community discussion yet for this question.