1 / 12

Forms

Forms. 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. Forms Views. There are 3 ways to view a form:

katiep
Download Presentation

Forms

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  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

More Related