a CHECK constraint can be used to confirm that the value in the OrderDate column is less than the value in the InvoiceDate column. However, a CHECK constraint cannot be created to enforce a rule that requires a column value from another row in the table or column value from another table. Answer A is incorrect. A foreign key is a column or combination of columns used to establish and enforce a relationship between the data in two tables. This relationship is created by adding a column(s) in one of the tables to refer to the other table's column(s) protected by a PRIMARY KEY or UNIQUE constraint. This column becomes a foreign key in the first table. A foreign key can be created by defining a FOREIGN KEY constraint when creating or altering a table. 97
QUESTION: 134 James works as an Access Developer for AccessSoft Inc. The company has a Windows Vista computer on which Microsoft Office 2007 is installed. The computer contains a database named Sales created in Access 2007. The database contains a table named Orders. James has to create a form which will display the data from the table one at a time. He wants to access the controls programmatically so that he can connect them to the table. Which of the following properties will he use to access the controls? A. Name B. ControlSource C. Can Grow D. TextFormat Answer: A Explanation: The name property refers to the name given to a control in a form or a report. The default name of the control is the control name plus 1, 2, 3, etc. The name of the control should be meaningful so that it can be easily used during programming. The value of this property cannot be changed programmatically. It can be changed only in design view. Answer B is incorrect. The ControlSource property bounds a control to a field of a table. If a control is bound to a field by using this property, the control is known as a bound control. If the value of this property is blank, the control is known as an unbound control. If the ControlSource property contains an expression, the control is known as a calculated control. Answer D is incorrect. The TextFormat property of a control helps to change a text to rich text format. This helps to apply multiple formatting options for the text in a control. A user can change the format of the text to bold, italics, etc., The user can also change the font of the selected text and can apply other types of formatting. Answer C is incorrect. The Can Grow property allows a control to adjust its dimensions according to the contents present in the control. A control grows vertically to adjust its contents so that all the contents can be displayed. The default value of the Can Grow property is false. 98
For More exams visit http s ://killexams.com /vendors-exam-list Kill your exam at First Attempt .... Guaranteed!
You've reached the end of your free preview.
Want to read all 13 pages?
- Fall '20
- Foreign key, Microsoft Office 2007