Form and Its Component In Database

Download PDF
Advertisement

Form and Its Component In Database

Form And Its Component In Database: A form consists of different GUI components or controls that are designed on the form for various purposes. The major components of the form are described below.

Drop-Down List Boxes

A drop-down list box present a list of items from which a user can select an appropriate item. The user can also add new item into the drop-down list box, but it depend on the property of the list box.

There are the several advantages of the list box. The main advantages are

  • It is easier and correct way to choose an item from the list rather than to enter an item into a text box.
  • It provide a suitable way to enter valid data values into the database.
  • It provides a quick way for data entry.


Option Button

The option button is used to display a set of choices or option form which the user can select only one. An option button is also referred to as Radio button. This button appears on the form as small circle with a caption. When it is selected, a dot appears in the circle. If another option is selected from the set of options then the already selected button is automatically de-selected. Therefore, the option button are manually exclusively.

The radio button must be connected with the table column, so that application program can access the data of the selected option to and from the database.

Advertisement

Groups

The Group control is also referred to as Frame Control. The frame control is typically used to group related controls together on a from. Usually, the multi-valued attributes are grouped together in the frame control.

Check Boxes

The checkbox control is used to display multiple choices or options from which the users can select one or more. When an option is selected by clicking it, usually a tick mark (√) symbol is appeared in the checkbox. An empty or blank box indicates that option is not selected. When a selected check box is clicked, it is de-selected and the tick mark is disappears.

The checkbox control returns a Boolean value such as 1 or 0, representing Yes or No. The application program uses these values for making decisions and to access data to and from the table columns if the user selects the option.

Command Button

The command button is also known as Push Button. It is the most common element of the GUI used to perform an action when it is clicked with mouse. It is used as push button in the application.

 

Database Security

Advertisement