Access Day 3

General Outcomes:

  1. Understand creating and the usefulness of Forms

Learning Outcomes:

Tell the students that they will be able to do these things after the class:

  1. Know how to create Forms

Things you (teacher) need to learn:

Lesson Outline:

***This is not an outline you HAVE to follow. Feel free to customize it so it fits your teaching style!

  • Prayer
  • Have students introduce themselves and introduce yourself
  • *Ask check for understanding questions or clarifications throughout the class.
  • Forms
    • Explain the purpose of Forms
  • Create simple Forms
    • Quick Form button
      • sub form explanation
    • Layout View
      • Reorganize Data
    • Form Wizard
      • lets you choose the Data you want
      • Linked forms
    • Form Design
      • Text box and other elements
      • How to adjust size of boxes and moving them around
      • Property Sheet explanation
        • explain: Format tab, Data Tab, Event tab, Other tab
  • Create from Scratch: Make a New customer Form
    • Form Design
      • connect it to a data source
      • Create a Form from Queries rather than Tables
  • Form Controls
    • Go over some of the control options
    • Add header
    • Change Color
    • Add image logo
    • Different between Text box and Label box
    • Add Label box
    • Add line/anchoring
    • Delete Record Selector
    • Add combo box
    • Add buttons
  • Challenge Activity: Have the students build a form on their own!
  • Wrap up
    • Recap or summarize what they have learned.
    • Ask if they have any questions or things they want to go over again
    • Tell them what they will be learning for the next class: Reports
    • invite students to other classes
    • Tell them about our contact info: email, phone, office location, Facebook

Questions you can ask:

  • What is your favorite part of a form?
  • How can this be useful?