QUESTION: 129 James works as a Database Designer for AccessSoft Inc. The company has a Windows Vista-based computer with Microsoft Office 2007 installed on it. The company uses Microsoft Office Access 2007 database named HumanResource. The database contains several forms, tables and queries. James has to manually create a report that will display records from EmpDept query, which contains the names of 93
employees in the EmpName column and their concerning departments in the DeptName column. James creates a TextBox control. He has to bind the TextBox to the EmpName property. Which of the following properties will he use to accomplish the task? A. RowSource B. ControlSource C. TableSource D. RecordSource Answer: B Explanation: In order to accomplish the task, James will use the ControlSource property. 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 RecordSource property belongs to the form and report controls. This property is used to connect a form or report to a table or query. After setting the RecordSource property, a user can use the ControlSource property to bind the controls of a form or report. The RecordSource property belongs to the form and report objects. This property binds the object to a source from which data is to be retrieved. This source can be a table or a query. When a form or a report is bound to a table or a query, the controls can be bound to a column of the table through the ControlSource property. Answer A is incorrect. RowSource property belongs to the combo box and list box controls. When these controls are bound to a column by the RowSource property, all the data of the column is displayed in the list box or the combo box. Answer C is incorrect. There is no such property as TableSource. QUESTION: 130 James works as a Database Designer for AccessSoft Inc. He has to create a query that will count the number of employees in the company. Which of the following query wizards should he use to accomplish the task? A. Crosstab Query B. Simple Query C. Find Duplicates Query D. Find Unmatched Query 94
Answer: A Explanation: In order to accomplish the task, James should use the Crosstab Query Wizard. Thiswizard helps to create a query in which a user can use functions such as Count, Min, Max, etc. Answer B is incorrect. The Simple Query Wizard helps to create simple queries that are used to display specific or all data. Answer C is incorrect. The Find Duplicates Query Wizard is used to create queriesthat display duplicate records.
You've reached the end of your free preview.
Want to read all 13 pages?
- Fall '20
- Foreign key, Microsoft Office 2007