Get premium membership and access questions with answers, video lessons as well as revision papers.
(a) A calculated control: It is a control that uses an expression as its source of data. An expression can use data from a field in an underlying table or query of a form or report, or from another control on the form or report. For example an expression like TotalCost: ([UnitPrice]*0.75) indicates that data is derived from underlying field called UnitPrice to create a new field called TotalCost.
(b) A bound control: Is tied to a field in an underlying table or query and they get their data from the fieldnames in the given table.
(c) An unbound control: Is a control that does not have a data source but placed by the user on base form or report. You can use unbound controls to display information in a label, lines, rectangles or pictures.
maurice.mutuku answered the question on April 11, 2018 at 13:27
- What is "Control" as used in form design?(Solved)
Define the term "Control" as used in form design
Date posted: April 11, 2018. Answers (1)
- What are the major sections of a form in design view?(Solved)
Discuss the major sections of a form in a design view.
Date posted: April 11, 2018. Answers (1)
- What are the views applicable to a form?(Solved)
List the views applicable to a form.
Date posted: April 11, 2018. Answers (1)
- What is a subform?(Solved)
Define a subform.
Date posted: April 11, 2018. Answers (1)
- What are the steps of creating a new form from a database wizard?(Solved)
Explain the steps of creating a new form from a database wizard.
Date posted: April 11, 2018. Answers (1)
- How would you create a backup copy of your file from your computer to an external storage such as a flash disk in a database...(Solved)
Explain how you would create a backup copy of your file from your computer to an external storage such as a flash disk in a database called CLASS, while using MS Access.
Date posted: April 11, 2018. Answers (1)
- How would you create Command Buttons that open other forms by using a wizard?(Solved)
Clearly describe the steps you would require to create Command Buttons that open the other forms by using a wizard.
Date posted: April 11, 2018. Answers (1)
- What are the steps required in adjusting the row height and column size in the datasheet view environment?(Solved)
Discuss the steps required in adjusting the row height and column size in the datasheet view environment.
Date posted: April 11, 2018. Answers (1)
- What is the difference between Caption and Required properties of a field?(Solved)
Distinguish between Caption and Required properties of a field.
Date posted: April 11, 2018. Answers (1)
- What is the difference between Indexed and default value?(Solved)
Differentiate between Indexed and default value.
Date posted: April 11, 2018. Answers (1)
- What is the difference between Validation rule and Validation text?(Solved)
Distinguish between Validation rule and Validation text.
Date posted: April 11, 2018. Answers (1)
- What is the difference between Input mask and Format as properties of a field?(Solved)
Differentiate between Input mask and Format as properties of a field.
Date posted: April 11, 2018. Answers (1)
- What is the meaning of the term "index" as used in databases?(Solved)
Define the term "index" as used in database.
Date posted: April 11, 2018. Answers (1)
- What is the difference between a primary key and a foreign key?(Solved)
Distinguish between a primary key and a foreign key.
Date posted: April 11, 2018. Answers (1)
- What are the data types used in Ms Access?(Solved)
List and explain examples of data types used in Ms Access.
Date posted: April 11, 2018. Answers (1)
- What is a "data type" as used in databases?(Solved)
Define what a "data type" is as used in databases.
Date posted: April 11, 2018. Answers (1)
- What guidelines should a database designer consider before setting up a good database?(Solved)
Give the main guidelines that a database designer should consider before setting up a good database.
Date posted: April 11, 2018. Answers (1)
- What are the steps needed to open an existing database and entering a new record?(Solved)
Outline the steps needed to open an existing database and to enter a new record.
Date posted: April 11, 2018. Answers (1)
- What is a "Field" in relation to databases?(Solved)
Define a "Field" in relation to databases.
Date posted: April 11, 2018. Answers (1)
- What is a "File" in relation to databases?(Solved)
Define a "File" in relation to databases.
Date posted: April 11, 2018. Answers (1)