Friday, Nov 8- 8th Grade- Databases- Practicing with Lookup Wizards

Bell Ringer:
1. @  OPEN ACCESS (Purple A) in Zenworks   
    Save to your lunch number as Names
     Hit the Create button
     The First Name and Last Name fields should be TEXT
     The Age field should be NUMBER. 
     See Page 426,  
     Add the records Bill, Tashia, until Sue.
2. If your name is on the board, finish any missing work

What are we learning? .Understand the basics of databases. 
How is database information used, organized, and managed in business? 
What formatting options are available when creating databases?

Guided Practice:
@ Students will open the Data Type and Field Properties PowerPoint
@Lookup Wizard Access 2010   http://www.youtube.com/watch?v=-r6pmWYboYY
@ 1st period students:
     Students will work through an example with the teacher
     using a Lookup Wizard with a new database called
     Inns file to create a Discount field.
@ Everyone will add a bed size and view look up wizard. 

Independent Exercise:
@Students will learn about Field Properties
@Students will watch Access 2010 Field Properties http://www.youtube.com/watch?v=BPDs_55USOY (first 5 minutes).
@Candy challenge "Is it a data type or a field property?"

If there is time:
@Working in pairs and using the Data Type and Field Properties PowerPoint
    match the definition to the correct term on the worksheet.
    These are future test questions!
@  Input Masks in Web Forms  http://www.youtube.com/watch?v=BMaTiGKykl8
@ The Wonderful Wizards of Access - Part 2 - Using the Input Mask A         http://www.youtube.com/watch?v=fBlT1KrQUsY

Exit Activities: Database Vocabulary Review: http://www.quia.com/mc/483616.html