A form is a type of a database object that is primarily used to enter or display data in a database. You can also use a form as a switchboard that opens other forms and reports in the database, or as a custom dialog box that accepts user input and carries out an action based on the input.

To Create Form.

• Click on Form Object
  
• Click on New Button
  
• Select Design view and choose Table or Query on the dropdownlist .
  
• then open form in desing view with Table
  
• Select Table field and drag on the details form section

Creating form using Wizard:

Double click on Create form using wizard

Selec Table or Queryt from the Table/Queries box, this will be the form source.

Select the fields to include in the form by clicking on the field and then the Next button or simply double click on the field.

Click on the Next> button

Select the data distribution layout within the form. By selecting a format it will appear on the left side the way it will be seen in the form.

Click Next

select the forms style, we can select between the various defined styles.

Click on the Next button .

Type the title of the form, this title will also be the name assigned to the form.

Clicking on the Finish button we can choose between:

The Detail section, here the source records of the form appear, either various records or one per screen, depending on the type of form. Even though various records are visualized on one screen, we need to indicate the design corresponding to just one record in the Detail section.

The Footer section, here we need to put what we want to appear at the end of the form.

Using the View menu, and then the option Form header/Footer option we can close or open the header and footer.

The mark to the left of the option indicates to us whether the sections are open or closed, if we remove the sections we lose all the controls associated with them.

To open them we just need to select the option again.

If the Toolbox does not appear, click on the button on the toolbar.

Label: Fixed text, text that we write directly into its control or Caption property.

Text box is usually used to present data stored in a source field of the form. This type of text box is called an dependant text box because it is dependant of the data in one specific field, and if we edit data in the Form view we will be changing the data at the source. Text boxes can also be independant,

Option Group is used to present a limited group of alternatives. A group of options makes it easier to select a value as the user only needs then to click on the value he requires. There should only be a few options, otherwise it would be better to use a list box or a combo box instead of an option group.

Toggle button is usually used to add a new option to an existing Option Group, it can be used to present a Yes/No field; if the field contains a Yes value the button will appear depressed.

Option button is usually used to add a new option to an existing Option Group, it can be used to present a Yes/No field

Check box is usually used to add a new option to an existing Option Group, it can be used to present a Yes/No field

Combo box . In many cases it will be easier to select a value from a list than to remember it in order to type it. A list of possibilities also helps to assure that the value introduced is correct. If we do not have sufficient space to show the list at all times the combo box is used as it shows only one value (that which is associated with the control), and if we want to see the list we can drop it down with the arrow to the right. When we add a combo box to the design area the wizard will open to help us to define the control.

List box The difference between the combo box and the list box is the list appears visible at all times in a list box. Like a combo box, a list box can also contain one or more columns, that can appear with or without headers. When we add a list box to the design area the wizard will open to help us to define the control.

Command permits the execution of an action with simply a click, e.g to open another form, to delete a record, to run a macro, etc... On clicking the button it does not only execute the corresponding action, but the button also appears depressed and then released. It also has an associated wizard that permits us to create buttons to perform more than 30 different predefined actions.

Image is used to insert images into the form, this image does not vary on changing the record.

Unbound object frame is used to insert controls, e.g a sound, a Word document, a graphic, etc... These controls will not vary when we change the record.

Bound object frame is used to insert an image or other object that will change from one record to another.

Page break does not have any effect on the Form view, but rather on the preview and at the moment of printing.

Control tab is used when we want to present many fields for each source record but they do not fit on one screen and we want to organize them in various tabs.