Access Day 1

Microsoft Office Access 2016 provides a powerful set of tools that help you to quickly start tracking, reporting, and sharing information. You can rapidly create attractive and functional tracking applications by customizing one of several predefined templates, converting an existing database, or creating a new database, and you can do so without deep database knowledge.

 

Intro

This little intro will help you get an idea of what to present with the PowerPoint that goes along with Day 1.

Congratulations! You are now learning the best software for database management. Almost all companies use Microsoft Access to store most of their data that they accumulate everyday. It is so powerful it can store and hold millions and millions of information for easy access and manipulation.

Computer Database is a Program that lets you store, organize and manipulate large amounts of data. I mean millions of data. In the olden days (before the age of computers) people used paper ledgers or index cards to store information. It was the best and effective way to store data at the time but it had many disadvantages. Things such as redundant information being stored.

Access’ greatest strength is recognizing and creating relationships. Without relationships you would have to look up an account of a person and pull up another file to see what they have purchased. You can relate these together in Access. This is the best video I’ve found for understanding relationships. It is critical that you understand the what, why and how we use relationships in the Database world so you can clearly teach the students. Don’t worry if you don’t get it right away. As you keep learning and practicing you will understand it.

 

General Outcomes:

  1. Learn to create tables and enter data.

Learning Outcomes:

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

  1. Create a table in multiple views.
  2. Differentiate from different data types and know when to use them.
  3.  Enter data in the database

Things you (teacher) need to learn:

You will learn more about Microsoft Access than you will have to teach

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 students what they know about Access and what its used for
  • Ask them why they are taking the class
  • PowerPoint Presentation
  • *Ask check for understanding questions or clarifications throughout the class.
  • Tables
    • What are tables?
    • Create a table in datasheet view and design view
      • teach the difference between the two and when to use them
    • Data Types
      • Short Text
      • Long Text
      • numbers
      • Currency
      • Yes/No
      • Autonumber
      • OLE Object
      • Attachment
      • Hyperlink
      • Calculated
      • Lookup Wizard
    • Entering Data
    • Edit Table structures in Design View
      • Input Masks
      • Setting Default value
      • Build validation rules
      • Validation Text
      • Create Lookup Fields
    • Additional Field Properties
  • Challenge Activity: Have the students build a table 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: Relationships and Queries
    • invite students to other classes
    • Tell them about our contact info: email, phone, office location, Facebook

Questions you can ask:

  • What are some disadvantages you think you will have if you used a paper ledger or index cards to store information?
  • Why is it important that we make data fields specific?