Forms

1. Forms

2. Access Forms • A form is based on the information within a table. • Forms differ from tables because the data is arranged in a format that is easier to read.

3. Forms Views There are 3 ways to view a form: • Form View: Appears when you open a form. Here you enter and edit data and find records. • Design View: Allows you to create or modify the layout of the form. You see controls not records which may include a textbox or a label. The textbox holds the information from a field. • Datasheet View: Displays the record in the default table style.

4. Form Wizard Form Wizard provides step-by-step help in creating a form. Select the Table Select the fields in the Table

5. Subforms and Form Style Subform is a form within A form Select the layout of a Subform or form

6. Select Style and Title for Forms Select the way you want a Form/subform to appear Name your form/subform Using the naming conventions for forms (frm)

7. Form View This is a form in Form View. This View is convenient for data entry. This is the subform, it was created first by a table (a form inside a form).

8. Design View This is where you can actually design or edit the look of your form.

9. Detail Section Form Header Form Footer Page Header Page Footer Sections to a Form

10. Form Header Section The Details Section • Form header: The heading section of a form appears at the top of the form • and usually consists of the title of the form. Other data that you may want in • a heading section might be the date, company name picture or logo. Form Footer Section Form footer: The section of a form that appears at the bottom of the form; consists of creator’s title, date and similar information. The details section displays each record in a separate form and includes the following elements • Combo box: a drop down list of options that a user can select from • Detail: The detail section of a form contains one record. It should consist • of any labels and fields that you want to display on the form. • Textbox: A text box is an area on a form or report where data fields • Can be shown or changed • Label: A label is any area on a form or report where titles or descriptions are shown. The label can stand alone or be attached to a control. If a label is attached to a control, it often contains the name of the field represented by the control.

11. Form Controls • A form control does 3 things: • displays data • performs an action • adds a design element. • A control can be: • Bound: linked to a table or query; it has a data source and is used to change data in a table. The data in a bound control changes from record to record • Unbound: displays labels, titles, lines, rectangles, or other design elements. It has no data source. • Calculated: uses an expression as its source of data. It might contain field names, arithmetic operators, constant numbers, or functions. It is not a field in a table.

12. Property Sheet Each control, object, and section on a form has its own property. A property sheet lists all the characteristics or attributes for that object. • Label properties: font size/name/color. • Textbox properties: format setting, data source, visible or invisible data • Picture: size mode, position • Bound Control: These properties are taken or inherited from the table