1 / 21

Access Forms

This guide covers essential components of forms in Microsoft Access, including header, footer, and detail sections. It explains both bound and unbound forms, detailing the record source property and providing examples of using form properties for data formatting and validation. Learn how to use the Form Wizard, design views, and the Toolbox for custom controls. It also delves into creating reports, adding subtotal features, and managing switchboard forms for streamlined navigation. Master these techniques to enhance your database applications.

jela
Download Presentation

Access 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. Access Forms ISYS 562

  2. Components of a Form • Form Header, Form Footer • Page Header, Page Footer • Detail Section • Controls

  3. Bound and Unbound Forms • A bound form is a form that is tied to either a table or query. • Form’s Record Source property • Unbound form: • Example: Switchboard

  4. Form Properties • Format • Data • Event • Other

  5. Creating a Form • Form/New • Design View • Form Wizard • Auto Forms • Customize the Generated Form using the Design View

  6. Add Additional Controls • Examples: • Toolbox • Textbox with expression • =Count(SID) • =IIF(GPA < 2.0,”Bad”,”Good”)

  7. Data Validation • Table design view • Form • Textbox Data tab

  8. Conditional Formatting • At form design view: • Format/Conditional formatting

  9. ReadOnly Form • Form properties: • Form/Data: • Set no to: Allow Edit, Allow delete, Allow Deletion, Data Entry

  10. Main/Sub Form • 1. Create a join query and use the join query to create a form. • 2. Using Form Wizard: • Add two tables

  11. Main/SubForm with Total • Create a textbox in subform’s form footer: =Count(sid) • Create a textbox in main form’s footer: = [subform name],[Form]!TextBoxName

  12. Form Design View • ToolBox and Wizards

  13. ToolBox: View/Toolbar/ToolBox

  14. Command Button Wizard

  15. Option Group Wizard

  16. ComboBox Wizard

  17. ListBox Wizard

  18. Creating Reports

  19. Report Sections • Report Header/Footer • View/Report Header, Footer • Page Header/Footer • View/Page Header, Footer • Group Header/Footer • View/Sorting and grouping • Detail section

  20. Creating Reports • Design view • Format/Condition formatting • Group subtotal • Adding textbox • Report Wizard

  21. SwitchBoard Manager • Tools/Database Utilities/SwitchBoard Manager • SwitchBoard window: • Main form • New: Add a new switchboard form • Edit: Edit items on a switchboard form • Edit switchboard window: • New: Add a new item on a form • Edit

More Related