You have created a database named Sales. The database consists of a table named Employees. You want to ensure that all names of the employees should be displayed while filling a form. Which of the following controls will you use to accomplish the task?
You will use the listbox and combobox controls. When these controls are bound to a column of a table, all data of that column is displayed in these controls. You cannot edit or delete the data from these controls. You can only view the data.
Answer option B is incorrect. The textbox control is bound to a column but it displays only one record at a time. According to the scenario, you want to ensure that all names of the employees should be displayed and the textbox control will not accomplish this task.
Answer option A is incorrect. The label control does not have the ControlSource property so it cannot be bound to any column of any table. A label is used to provide a name to a bound control. Reference: ECDL/ICDL Exam Course Manual, Contents: 'Form'
Chapter: DATABASE, ADVANCED-LEVEL
Objective: Form Design