Module 5 Databases - Forms OpenOffice and Access
Create a Form in OpenOffice 3.2 March 2010 - Using the Wizard
Creating a form using the Form Wizard
If possible, use the Form Wizard to create your forms. It is easy to use and effective. You can modify the design later if you wish. The process of creating a form with the wizard - below
End of Openoffice Forms
Microsoft Access - Create a Form
Create a simple form.
To create a form using the AutoForm Wizard · In the Database
Window click on the Table or Query icon.· Click on a Table or
Query to select it. Click the AutoForm button on the Standard toolbar.
You can now use this form to enter the information into the table or
query.
Creating a form using the Form Wizard If possible, use the Form Wizard to create your forms. It is easy to use and effective. You can modify the design later if you wish.
To create a form using Form Wizard - In the Database
Window click on the Forms icon. Choose the New button, which will display
the New Form dialog box. - Select the Form Wizard.- Choose the table
or query where the objects data will come from.
Click on the OK button to display the next page of the Form Wizard.
- Click on the field that you wish to add to the form, and then click
on the right printing arrow button to add it to the Selected Fields
section of the dialog box.· Repeat this procedure so that all
the required fields are added. Remember that you can use the down arrow
in the Tables/Queries section of the dialog box to select a different
data source that will contain other fields. When you have added the
required fields click on the Next button.
The next page of the dialog allows you to define the layout of the form.
Choose the desired option and then click on the Next button.
The next page of the Form Wizard allows you to choose a pre-defined
style. Select the required option and click on the Next button to continue.
This next page of the Form Wizard allows you to name the form and set
final options for using the form. Click on the Finish button to create
the form.
If you choose to "Open the form to view or enter information",
then the form will be displayed as illustrated.
Enter data into the database using simple forms.
To enter data into a form · Open the form you wish to use by clicking on the Forms tab in the Database Window and double clicking on the name of the form. The Form Window will be displayed.· Entering data into a form is much like entering data into a table. Type your data into the form field, once finished press the Tab key to move to the next field. Pressing Tab in the last field will take you to the next record. · To create a new record, click on the New (Blank) record icon at the bottom of the Form Window.
Modify Form Layout
Design View · To see the form in Design View, click on the View
icon in the toolbar, and then select Design View.
Form View · To see the form in Form View, click on the View icon
in the toolbar, and then select Form View.
Manipulating form design After you have created a form using Forms Wizard, you might want to move some of the fields around, or add or delete fields. The same basic principles of Select then Manipulate! apply here as in all other Microsoft applications.The controls that Access adds to forms you create using Form Wizard are called bound controls. This means that they are bound to the fields in the underlying table or query. Bound controls consist of a Label and a Text box. The label holds the field name, or caption from the field’s properties. The text box holds the table data.
To select a control with the mouse Click somewhere in the control. If you click on the label, you will notice eight sizing handles at the corner and sides of the label box; you will also see a move handle at the top left of both the label and the text box. If you click in the text box, you will see that the eight sizing handles now appear around the corner and sides of the text box and that the move handles still appear at the top left-hand corners of both the label box and text box. This lets you move label and text boxes together or independently.You can move from control to control using the Tab key but you must click in one of the controls first!
To select adjacent controls · Click on
a point outside the group and drag the pointer through the controls.
As you move the pointer, it draws a rectangle around the selected group.
To select non-adjacent controls · Hold down the SHIFT key as you select each of the controls.
To save a form · Choose Save from the File menu.· Type in a name for the form.· Press Enter or click on OK.
To change the size of a section After adding and moving controls you might want to change the size of a section.· Move the mouse pointer over the bottom edge of the section. The pointer will change to a double-headed vertical arrow across a solid horizontal bar.· Drag the edge of the section until it is the required size.
To change the width of the form · Move the mouse pointer over the right edge of any section on the form. It will change to a double-headed horizontal arrow across a solid vertical bar.· Drag the edge of the section until it is the required size.
To change the width of the form and size of a section simultaneously · Move the pointer over the right-hand corner of the section. It will change to two intersecting double-headed arrows. · Drag the corner of the section and form until it is the required size.