07/10/2010 The Information & Communication Technologies for IGCSE Exams are coming!!!

Ivan y Antonio are working hard for these international exams that will take place on October 14th and 21st.
Good effort and Good Luck!!!
And Good Luck to Camila, María Victoria, Rodrigo y Martín Alejo too!!!

Next class SQL work

Here is your homework for next class.

http://www.4shared.com/document/XGYPjyU9/sql_work.html

Next class activities

https://docs.google.com/Doc?docid=0Ab4BbyC37KqPZGdtdDY3ajdfODlnbWp3dndmbg&hl=es

We are going to start with SQL language.
Something to read before starting
http://www.1keydata.com/sql/sql.html

http://www.techbookreport.com/sql-tut1.html

Database revision

Today´s work

Let´s remember how to use Access to solve a problem.
“John has been travelling around the word , he wants to create a database to store information about the different paintings he saw along his voyage”
So…
Create a database, it must have two tables (One Paint and other AuthorPaint).
The table Paint must have a special type of field called Objeto Ole. There, you must store a picture of the painting.
Also, it must have an extra field called Author Paint that must be numerical type.

Worksheet
To generate the worksheet use the following functions:
to generate data at random
Count.If Contar.Si
Sum.If Sumar.Si
Vlookup
Frecuency Frecuencia
Sum Suma /autosuma
If Si (condicional)

Welcome again

Diagnosis period
Diagnosis activity

Remember you must save this document in your folder.

Welcome back to ITDept VDS!!!