Dear Class:
We will be doing queries. Examples for query criteria at this link.
I have a handout for you as the exit project and then we are done with Database. Page 1
We will be importing the MyTunes Excel Spreadsheet into Access. I have had difficulties with the non-Office2013 Excel files. I have a exl instead of a exlx file for the 2003 version here.
You will have to open it up and may have to copy and paste in but we will see. First period had major problems with this on the older machines and, as a consequence, I had them double up. When it is saved doubled up, both names must appear.
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.
MyTunes Worksheet MyTunes Excel Spreadsheet href="http://www.gcflearnfree.org/access2003">Access 2003
Sincerely,
Mr. Green-Hite
Friday, September 27, 2013
Wednesday, September 25, 2013
Wednesday, September 25, 2013
Dear Class:
We will be importing the MyTunes Excel Spreadsheet into Access. I have had difficulties with the non-Office2013 Excel files. I have a exl instead of a exlx file for the 2003 version here.
You will have to open it up and may have to copy and paste in but we will see. First period had major problems with this on the older machines and, as a consequence, I had them double up. When it is saved doubled up, both names must appear.
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.
MyTunes Worksheet MyTunes Excel Spreadsheet href="http://www.gcflearnfree.org/access2003">Access 2003
Sincerely, Mr. Green-Hite
We will be importing the MyTunes Excel Spreadsheet into Access. I have had difficulties with the non-Office2013 Excel files. I have a exl instead of a exlx file for the 2003 version here.
You will have to open it up and may have to copy and paste in but we will see. First period had major problems with this on the older machines and, as a consequence, I had them double up. When it is saved doubled up, both names must appear.
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.
MyTunes Worksheet MyTunes Excel Spreadsheet href="http://www.gcflearnfree.org/access2003">Access 2003
Sincerely, Mr. Green-Hite
Monday, September 23, 2013
Monday, September 23, 2013
Monday, September23, 2013
Dear Class:
Worked on and more or less finished Excel. They should be cleaned up!!!! Period 5 did not turn in their sheets analyzing MyTunes spreadsheet/database. You were to have made queries using the right tools. That is due today! What is a database?
Watch the Tutorial on Access. (approx. 24 minutes) The teacher will go to the site and play "Access 2010/2013", Beginner, "Introduction" 2013 and "Database Terminology" and perhaps "Planning Your Database". You will be taking notes in a google doc entitled "Database Notes" that will then be put into your shared folder so that I can see it.
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
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???
Last class I had you go to to a spreadsheet, however, because a few of the students made changes that made it apparent that some could not take this task seriously, you will have to open a google spreadsheet and enter in each category in the first row of cells and then answer the questions below. This means more work and less time for GameMaker at the end of the semester. Period 7 Period 7 (?) Period 5
Mrs. Ekroth was here last Friday. She had you take some notes and we will add to those. I also was given to understand that you started a "preliminary" database and we will continue with that.
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
MyTunes Worksheet MyTunes Excel Spreadsheet href="http://www.gcflearnfree.org/access2003">Access 2003
Dear Class:
Worked on and more or less finished Excel. They should be cleaned up!!!! Period 5 did not turn in their sheets analyzing MyTunes spreadsheet/database. You were to have made queries using the right tools. That is due today! What is a database?
Watch the Tutorial on Access. (approx. 24 minutes) The teacher will go to the site and play "Access 2010/2013", Beginner, "Introduction" 2013 and "Database Terminology" and perhaps "Planning Your Database". You will be taking notes in a google doc entitled "Database Notes" that will then be put into your shared folder so that I can see it.
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
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???
Last class I had you go to to a spreadsheet, however, because a few of the students made changes that made it apparent that some could not take this task seriously, you will have to open a google spreadsheet and enter in each category in the first row of cells and then answer the questions below. This means more work and less time for GameMaker at the end of the semester. Period 7 Period 7 (?) Period 5
Mrs. Ekroth was here last Friday. She had you take some notes and we will add to those. I also was given to understand that you started a "preliminary" database and we will continue with that.
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
MyTunes Worksheet MyTunes Excel Spreadsheet href="http://www.gcflearnfree.org/access2003">Access 2003
Thursday, September 19, 2013
Thursday, September 19, 2013
Thursday, September 19, 2013
Dear Class:
EXCEL to start...then videos on Database...the boring ones!!!! What is a database?
Watch the Tutorial on Access. (approx. 24 minutes) The teacher will go to the site and play "Access 2010/2013", Beginner, "Introduction" 2013 and "Database Terminology" and perhaps "Planning Your Database". You will be taking notes in a google doc entitled "Database Notes" that will then be put into your shared folder so that I can see it.
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
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???
Last class I had you go to to a spreadsheet, however, because a few of the students made changes that made it apparent that some could not take this task seriously, you will have to open a google spreadsheet and enter in each category in the first row of cells and then answer the questions below. This means more work and less time for GameMaker at the end of the semester. Period 7 Period 7 (?) Period 5
Mrs. Ekroth was here last Friday. She had you take some notes and we will add to those. I also was given to understand that you started a "preliminary" database and we will continue with that.
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
MyTunes Worksheet MyTunes Excel Spreadsheet href="http://www.gcflearnfree.org/access2003">Access 2003
Dear Class:
EXCEL to start...then videos on Database...the boring ones!!!! What is a database?
Watch the Tutorial on Access. (approx. 24 minutes) The teacher will go to the site and play "Access 2010/2013", Beginner, "Introduction" 2013 and "Database Terminology" and perhaps "Planning Your Database". You will be taking notes in a google doc entitled "Database Notes" that will then be put into your shared folder so that I can see it.
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
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???
Last class I had you go to to a spreadsheet, however, because a few of the students made changes that made it apparent that some could not take this task seriously, you will have to open a google spreadsheet and enter in each category in the first row of cells and then answer the questions below. This means more work and less time for GameMaker at the end of the semester. Period 7 Period 7 (?) Period 5
Mrs. Ekroth was here last Friday. She had you take some notes and we will add to those. I also was given to understand that you started a "preliminary" database and we will continue with that.
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
MyTunes Worksheet MyTunes Excel Spreadsheet href="http://www.gcflearnfree.org/access2003">Access 2003
Monday, September 16, 2013
Tuesday, September 17, 2013
Friday, September 17, 2013
Dear Class:
What is a database?
Watch the Tutorial on Access. (approx. 24 minutes) The teacher will go to the site and play "Access 2010/2013", Beginner, "Introduction" 2013 and "Database Terminology" and perhaps "Planning Your Database". You will be taking notes in a google doc entitled "Database Notes" that will then be put into your shared folder so that I can see it.
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
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???
Last class I had you go to to a spreadsheet, however, because a few of the students made changes that made it apparent that some could not take this task seriously, you will have to open a google spreadsheet and enter in each category in the first row of cells and then answer the questions below. This means more work and less time for GameMaker at the end of the semester. Period 7 Period 7 (?) Period 5
Mrs. Ekroth was here last Friday. She had you take some notes and we will add to those. I also was given to understand that you started a "preliminary" database and we will continue with that.
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
MyTunes Worksheet MyTunes Excel Spreadsheet href="http://www.gcflearnfree.org/access2003">Access 2003
Dear Class:
What is a database?
Watch the Tutorial on Access. (approx. 24 minutes) The teacher will go to the site and play "Access 2010/2013", Beginner, "Introduction" 2013 and "Database Terminology" and perhaps "Planning Your Database". You will be taking notes in a google doc entitled "Database Notes" that will then be put into your shared folder so that I can see it.
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
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???
Last class I had you go to to a spreadsheet, however, because a few of the students made changes that made it apparent that some could not take this task seriously, you will have to open a google spreadsheet and enter in each category in the first row of cells and then answer the questions below. This means more work and less time for GameMaker at the end of the semester. Period 7 Period 7 (?) Period 5
Mrs. Ekroth was here last Friday. She had you take some notes and we will add to those. I also was given to understand that you started a "preliminary" database and we will continue with that.
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
MyTunes Worksheet MyTunes Excel Spreadsheet href="http://www.gcflearnfree.org/access2003">Access 2003
Thursday, September 12, 2013
Friday, September 13, 2013
Friday, September 13, 2013
Dear Class:
What is a database?
Watch the Tutorial on Access. (approx. 24 minutes) The teacher will go to the site and play "Access 2010/2013", Beginner, "Introduction" 2013 and "Database Terminology" and perhaps "Planning Your Database". You will be taking notes in a google doc entitled "Database Notes" that will then be put into your shared folder so that I can see it.
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???
Last class I had you go to to a spreadsheet, however, because a few of the students made changes that made it apparent that some could not take this task seriously, you will have to open a google spreadsheet and enter in each category in the first row of cells and then answer the questions below. This means more work and less time for GameMaker at the end of the semester.
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
Dear Class:
What is a database?
Watch the Tutorial on Access. (approx. 24 minutes) The teacher will go to the site and play "Access 2010/2013", Beginner, "Introduction" 2013 and "Database Terminology" and perhaps "Planning Your Database". You will be taking notes in a google doc entitled "Database Notes" that will then be put into your shared folder so that I can see it.
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???
Last class I had you go to to a spreadsheet, however, because a few of the students made changes that made it apparent that some could not take this task seriously, you will have to open a google spreadsheet and enter in each category in the first row of cells and then answer the questions below. This means more work and less time for GameMaker at the end of the semester.
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
Wednesday, September 4, 2013
Wednesday, September 11, 2013
Wednesday, September 11, 2013
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???
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
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???
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
Subscribe to:
Posts (Atom)