Tuesday, January 31, 2012
Dear Class:
Rules
Class itself
Database
Bloodshed C++
Day One:
What is a database?
Watch the tutorial for database (17 minutes)
Why use a database—information about customers, information about inventories, any type of information a business would need. You can design, manipulate, sort, and print.
Who has a database—schools, libraries, government, stores, banks, business on inventory and employees
Internet Search:
Who won the Heisman trophy 2 years in a row?? (1974 1975 Archie Griffen
Who Was David Douglas named after??
Who are some notable alumni from David Douglas??
Record?
Field?
Requirements: contain a unique name, describe the field, <= 64 characters, cannot begin with a space, can’t use . , ! [ ]
Fields have data types—text, number, currency, date/time, yes/no, OLE Object (picture), hyperlink (address), lookup wizard (giving options)
Field size—usually default works but you can assign different sizes
Who has a long name that always gets cut off???
Go to the spreadsheet that is shared an editable and enter in the following data after one of the students puts in the Record type
Icebreaker—creating a database about our class
What do we want to find out about each other:
First Name
Last Name
Age
Smart? (yes/no)
How much do you have?
Favorite Food
Favorite Color
Gender
Eye Color
Birth Month
Job
Database Exp
Programming Exp
Grade
Hobbies
Siblings
Middle School
Sports
Enter the information onto the spreadsheet that has been shared.
Let’s put our class in a database. . .
Create a database
Different programs: MS ACCESS, Oracle, Dbase
We use ACCESS
Determine fields and data types
Enter your own data on the first line and SAVE it.
Open WORD document and create a “Database Notes” file
Vocabulary: database, field, record, data types
Sites that can help: Access 2003 tutorial
Access 2003
