Access Day 2

General Outcomes:

  1. Understand Relationships in Databases and Queries.

Learning Outcomes:

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

  1. Understand what relationships are.
  2. When to create relationships.
  3. What a query is
  4. How and when to use queries

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.
  • Relationship
    • *Review have them create a Credit Card Table with input masks for card number and expiration date. Add Look up value for Card Type and limit characters to 3 on CVC
  • Explain what Relationships are
    • Do a little exercise on relationships between different things
  • Create a relationship between customer and credit card
    • Explain referential integrity
    • Explain Cascade Update
    • Explain Cascade Delete
  • Create Queries
    • With Query Wizard
    • Query Design
  • Using Queries to find records
    • Criteria
    • Special Criteria
  • Advanced Queries
    • Parameter Query
    • Calculated Fields Query
  • Challenge Activity: Have the students build a query 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: Form
    • invite students to other classes
    • Tell them about our contact info: email, phone, office location, Facebook

Questions you can ask:

  • Why would it be better to use a query to filter and sort rather than straight on the table?