Monday, April 21st- 8th Grade- Database Review- Creating a database and different database types

Bellringer:
1. On page 416 type the top paragraph that begins "A column or field is a..."
2. Finish any work on the board.

What are we learning? Understand the basics of databases.
How is database information used, organized, and managed in business?
 
Guided Lesson:
@ Students will open the Data Type and Field Properties PowerPoint
@ Miss W will review different data types with students.
@ Miss W will review creating a database with students
    - Remember there should be NO spaces in the field names. 
    - HistoricInn field should be the text data type.
    - No.Rooms field could be the text OR the number data type (if you using for math). 
    - Pets field should be the yes/no data type.
    - City field should be the yes/no data type.
    - Children field should be the yes/no data type.     
 
Independent Exercise:
@ Students will finish the BB Inns database.
@ It is very important to enter the data correctly or you will get the problems wrong!
@ Students are use to seeing a database in DATASHEET View.
     Datasheet View displays data in a row-and-column format.

@ Students will look at the DESIGN View to see if they used the correct database types.
     Design View lets you tell Access exactly how you want the object to look.

@ If time: Students will learn about the LOOK UP Wizard database type.
     A WIZARD asks you questions and formats the form according to your preference.

     Do NOT name the field first wait until you are asked for it.  

     Students will work through an example with the teacher
     using a Lookup Wizard with the   
     BBinns file to create a Discount field.
     The Discount field should be the Lookup & Relationship data type.
     When you get to number of columns type in the following choices:
     Senior  
     Military
     AAA
     Other  

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