Monday, September 10, 2012

Dear Class: All of the class needs to get into their gmail account through ddhspages.net sign in. I will show you how to get there. We will first create a "collection" or folder that you will share with me. It will be titled "Last Name First Name". You will go to the drop down arrow at the side of the folder and go to "share". Put in my email address and share the folder with me. Then, please open up a "doc" and name it "Definitions". I want to look at an article regarding computer and human error for data.

Please open up your "database" we worked on last time and then open up this blog so that you know what we will be doing today. I made an excel spreadsheet that we will be using with your scores on it. I will explain it to you in class. Spreadsheet

Please open up the Database notes we did and we will be adding to them the definition of: objects, table, form, and report.

Then, open up the "Class database" file we did last time. This will reflect the following:

First Name
Last Name
Age
Favorite Food
Favorite Color
Gender
Eye Color
Birth Month
Job
Database Exp
Programming Exp
Grade
Hobbies
Siblings
Middle School
Sports

You were to type them in a shared google doc and then plug your information on the database itself.

You will be "Correcting" that raw data into the "Class Database" that we will be using. In programming, you cannot have data that is "off" or "inconsistent" or a program will not work (although there are certain internal checks).

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???

We went to the spreadsheet that is shared an editable and entered in the following data after one of the students puts in the Record type.

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

Sincerely,
Mr. Green-Hite