1 / 27

Microsoft Access 2010- Illustrated

Microsoft Access 2010- Illustrated. Unit C: Using Forms. Objectives. Use the Form Wizard Create a split form Use Form Layout View Add fields to a form (continued). Objectives (continued). Modify form controls Create calculations Modify tab order Insert an image.

mignon
Download Presentation

Microsoft Access 2010- Illustrated

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. Microsoft Access 2010- Illustrated Unit C: Using Forms

  2. Objectives • Use the Form Wizard • Create a split form • Use Form Layout View • Add fields to a form (continued) Microsoft Office 2010-Illustrated

  3. Objectives (continued) • Modify form controls • Create calculations • Modify tab order • Insert an image Microsoft Office 2010-Illustrated

  4. Using the Form Wizard • A form is an Access database object that allows you to arrange the fields of a record in any layout so you can enter, edit, and delete records • One way to create a form is by using the Form Wizard • The Wizard asks you questions to determine the information you want Microsoft Office 2010-Illustrated

  5. Form Views Microsoft Office 2010-Illustrated

  6. Creating a Split Form • The benefit of a split form is that the upper pane allows you to display the fields of one record in any arrangement, and the lower pane maintains a datasheet view of the first few records, which you can navigate very quickly Microsoft Office 2010-Illustrated

  7. Form Creation Tools Microsoft Office 2010-Illustrated

  8. Example of a table in a split form Microsoft Office 2010-Illustrated

  9. Using Form Layout View • Allows some design changes to the form • You can add and delete fields • You can change formatting such as fonts and colors Microsoft Office 2010-Illustrated

  10. Using Form Layout View Microsoft Office 2010-Illustrated

  11. Mouse Pointer Shapes in Form Layout View Microsoft Office 2010-Illustrated

  12. Adding Fields to a Form • Can be done in Layout View or Design View using Field List window • To add a field: drag it from the Field List to the location you want • When you add a new field, 2 controls are created: label and text box • To delete a field: click to select the field, then press [Delete] Microsoft Office 2010-Illustrated

  13. Field List in Form Layout View Microsoft Office 2010-Illustrated

  14. Bound vs. Unbound Controls • Every item on a form is a control, such as text boxes and labels • Bound controls display data • Unbound controls do not display data Microsoft Office 2010-Illustrated

  15. Modifying Form Controls • Many common properties can be modified in Form View or Layout View • Some properties (such as Control Source) can only be viewed and changed on the Property Sheet Microsoft Office 2010-Illustrated

  16. Using the Property Sheet Microsoft Office 2010-Illustrated

  17. Common Form Controls Microsoft Office 2010-Illustrated

  18. Creating Calculations • Calculations are used to add items such as subtotals and counts to a form • Expressions are needed to create a calculation Microsoft Office 2010-Illustrated

  19. Creating Calculations • Expression: an equal sign and a combination of symbols • Square brackets must surround a field name in an expression • Field name must be typed exactly as it was in Table Design View (except for capitalization) Microsoft Office 2010-Illustrated

  20. Adding a Text Box to Calculate a Value Microsoft Office 2010-Illustrated

  21. Sample Expressions Microsoft Office 2010-Illustrated

  22. Modifying Tab Order • Tab Stop: determines whether the field accepts the focus and therefore determines where the focus moves as you press [Tab] • Tab Order: the order the focus moves as you press [Tab] • All text boxes and combo boxes have a tab stop and are included in the tab order Microsoft Office 2010-Illustrated

  23. Tab Order Dialog Box Microsoft Office 2010-Illustrated

  24. Inserting an Image • Examples are pictures, logos, clip art • The form section you place it in determines where it will appear on the form • For example, determine whether you want the image at the top of the form or next to each record Microsoft Office 2010-Illustrated

  25. Form Sections Microsoft Office 2010-Illustrated

  26. Adding an Image to the Form Header Section Microsoft Office 2010-Illustrated

  27. Summary • Using the Form Wizard • Creating a split form • Using Form Layout View • Adding fields to a form • Modifying form controls • Creating calculations • Modifying tab order • Inserting an image Microsoft Office 2010-Illustrated

More Related