Dear Class:
As you work on the "Final Project", I want to work with the students that need my individual help.
While you are working on the below "Final Project", I will be calling you up one at a time and going over grades/folder information.
You will all import the data and I will go over what queries and reports are and the differences. You will then run a few reports and then save them to the desktop. In the end, you will upload these reports into your google docs in your shared folder. Create a folder entitled "Reports and Queries" if you would.
MyTunes Worksheet MyTunes Excel Spreadsheet href="http://www.gcflearnfree.org/access2003">Access 2003
Please use the following four pages as the exit project and then we are done with Database (I can provide a hard copy but I don't have enough for everyone). Page 1
Page 2 Page 3 Page 4 last page
Sincerely,
Mr. Green-Hite
Thursday, February 27, 2014
Monday, February 24, 2014
Monday, February 24, 2014
Dear Class:
We finished up cleaning up the query/report that we did. This will include "centering" data and putting in a footer with your name on it. Then it will be "Exported" and "Published" as a pdf file. We will also add just a little bit to our notes, especially about wild cards. We will be doing queries which sometimes has "wildcards". I want to look at examples for query criteria at this link.
You should be done with exporting MyTunes Excel Spreadsheet into Access. MyTunes spreadsheet.
You will have to open it up and export it into Access. We did this before with the class excel spreadsheet so this should be no problem. Download the below worksheet that asks questions regarding the MyTunes Access file
You will all import the data and I will go over what queries and reports are and the differences. You will then run a few reports and then save them to the desktop. In the end, you will upload these reports into your google docs in your shared folder. Create a folder entitled "Reports and Queries" if you would.
MyTunes Worksheet MyTunes Excel Spreadsheet href="http://www.gcflearnfree.org/access2003">Access 2003
I have a handout for you as the exit project and then we are done with Database. Page 1
Page 2 Page 3 Page 4 last page
Sincerely, Mr. Green-Hite
We finished up cleaning up the query/report that we did. This will include "centering" data and putting in a footer with your name on it. Then it will be "Exported" and "Published" as a pdf file. We will also add just a little bit to our notes, especially about wild cards. We will be doing queries which sometimes has "wildcards". I want to look at examples for query criteria at this link.
You should be done with exporting MyTunes Excel Spreadsheet into Access. MyTunes spreadsheet.
You will have to open it up and export it into Access. We did this before with the class excel spreadsheet so this should be no problem. Download the below worksheet that asks questions regarding the MyTunes Access file
You will all import the data and I will go over what queries and reports are and the differences. You will then run a few reports and then save them to the desktop. In the end, you will upload these reports into your google docs in your shared folder. Create a folder entitled "Reports and Queries" if you would.
MyTunes Worksheet MyTunes Excel Spreadsheet href="http://www.gcflearnfree.org/access2003">Access 2003
I have a handout for you as the exit project and then we are done with Database. Page 1
Page 2 Page 3 Page 4 last page
Sincerely, Mr. Green-Hite
Thursday, February 20, 2014
Thursday, February 20, 2014
Dear Class:
We will start by finishing up cleaning up the query/report that we did. This will include "centering" data and putting in a footer with your name on it. Then it will be "Exported" and "Published" as a pdf file. We will also add just a little bit to our notes, especially about wild cards. We will be importing the MyTunes Excel Spreadsheet into Access. MyTunes spreadsheet.
You will have to open it up and export it into Access. We did this before with the class excel spreadsheet so this should be no problem.
You will all import the data and I will go over what queries and reports are and the differences. You will then run a few reports and then save them to the desktop. In the end, you will upload these reports into your google docs in your shared folder. Create a folder entitled "Reports and Queries" if you would.
MyTunes Worksheet MyTunes Excel Spreadsheet href="http://www.gcflearnfree.org/access2003">Access 2003
Sincerely, Mr. Green-Hite
We will start by finishing up cleaning up the query/report that we did. This will include "centering" data and putting in a footer with your name on it. Then it will be "Exported" and "Published" as a pdf file. We will also add just a little bit to our notes, especially about wild cards. We will be importing the MyTunes Excel Spreadsheet into Access. MyTunes spreadsheet.
You will have to open it up and export it into Access. We did this before with the class excel spreadsheet so this should be no problem.
You will all import the data and I will go over what queries and reports are and the differences. You will then run a few reports and then save them to the desktop. In the end, you will upload these reports into your google docs in your shared folder. Create a folder entitled "Reports and Queries" if you would.
MyTunes Worksheet MyTunes Excel Spreadsheet href="http://www.gcflearnfree.org/access2003">Access 2003
Sincerely, Mr. Green-Hite
Tuesday, February 18, 2014
Tuesday, February 18, 2014
Tuesday, February 18, 2014
Dear Class:
Terminology: We will add "Object", "Tables", "Forms", and "Reports"
Watch the Tutorial on Access 2013 to get a better idea. We will start with lesson 1. I do want you to open up your Database notes because some of the terminology will need to be put in.
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
Field?
Requirements: contain a unique name, describe the field, <= 64 characters, cannot begin with a space, can’t use . , ! [ ]
Spreadsheet containing the information from your filling out the form. "Shared Spreadsheet"
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
Sincerely,
Mr. Green-Hite
Dear Class:
Terminology: We will add "Object", "Tables", "Forms", and "Reports"
Watch the Tutorial on Access 2013 to get a better idea. We will start with lesson 1. I do want you to open up your Database notes because some of the terminology will need to be put in.
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
Field?
Requirements: contain a unique name, describe the field, <= 64 characters, cannot begin with a space, can’t use . , ! [ ]
Spreadsheet containing the information from your filling out the form. "Shared Spreadsheet"
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
Sincerely,
Mr. Green-Hite
Wednesday, February 5, 2014
Thursday, February 7, 2014
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
Spreadsheet containing the information from your filling out the form. "Shared Spreadsheet"
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
Sincerely,
Mr. Green-Hite
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
Spreadsheet containing the information from your filling out the form. "Shared Spreadsheet"
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
Sincerely,
Mr. Green-Hite
Monday, February 3, 2014
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
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
Subscribe to:
Posts (Atom)