Tuesday, February 4, 2013

Tuesday, February 4, 2014
Dear Class:

Rules
Class itself
Database
Bloodshed C++

Day One:

What is a database?

Watch the Tutorial on Access. (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???

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


New Database using a form for this class!

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

New Database using a form for this class!

Sincerely,
Mr. Green-Hite