Lesson 11: Staff!
Finally, a simple exercise to clarify a little bit the use of Microsoft Access.
First a bit of theory: in order to build a good database must follow the following steps:
1) Think about what we want to save and how to organize data in tables
2) create the tables
3) Create the Data Entry MASKS
4) Create queries (or query)
5) create reports
remember that the point 1 is the basis for all other points, while the sequence of operations from 2 to 4 can also be "personalized."
The book has been created in a satisfactory manner by all: good!
Tuesday, November 27, 2007
Pokemon Shiny Gold Cheats For Mac
Lesson 10: Access or no access?
This is the problem!
The lesson of today reiterated some basic concepts about databases and especially on Access.
We redid the exercise of the shoe store, trying to fix some inconsistencies found last time.
Everything was successful!
course, the lesson has also had his moment "fun" exercise proposed by PinCristal met with interest and was also an opportunity to review some Excel! In fact the solution (10,990 arts!) Is easily calculated with a simple Excel spreadsheet. Until next
class, where we will build an address book in Access!
This is the problem!
The lesson of today reiterated some basic concepts about databases and especially on Access.
We redid the exercise of the shoe store, trying to fix some inconsistencies found last time.
Everything was successful!
course, the lesson has also had his moment "fun" exercise proposed by PinCristal met with interest and was also an opportunity to review some Excel! In fact the solution (10,990 arts!) Is easily calculated with a simple Excel spreadsheet. Until next
class, where we will build an address book in Access!
Friday, November 16, 2007
Transport Cupcakes Loaf
play
Pincristal (aka Ilia) asked me to put this play nice in the blog.
I ask you, if you want, to solve it in 5 minutes with excel.
(The proof of the resolution give it to you next time ...)
If the link does not work, copy it to a new browser window.
http://maips21.altervista.org/testedosgatos.xls
Pincristal (aka Ilia) asked me to put this play nice in the blog.
I ask you, if you want, to solve it in 5 minutes with excel.
(The proof of the resolution give it to you next time ...)
There is a bus with 7 girls Each girl has 7 backpacks
In each backpack there are 7 big cats Each big cat has 7
cats How many small
legs are there on the bus?
I know, those cats are called legs, and legs, but it does not matter.
The result is the password to open this file . (Excel)
If the link does not work, copy it to a new browser window.
http://maips21.altervista.org/testedosgatos.xls
Best Wall Paint For Red Flooring
Lesson 9: Create a database
The lesson number 9 (and already you advance, the number 10) has as its main theme the creation of a database in Access format.
Access, remember, is the fourth program we see the Office suite (there is also a free version, OpenOffice Base) and allows you to create and manage precisely that particular world that are database.
What is a database? We can imagine as an archive of data: a great feature (most important) is that at any time, that database is able to give us answers to specific questions (questions).
The process of creating a database is summarized in five main steps:
The attempt failed at 90%, because the developer (the shoemaker) has not provided accurate information to developers.
;-)
soon!
The lesson number 9 (and already you advance, the number 10) has as its main theme the creation of a database in Access format.
Access, remember, is the fourth program we see the Office suite (there is also a free version, OpenOffice Base) and allows you to create and manage precisely that particular world that are database.
What is a database? We can imagine as an archive of data: a great feature (most important) is that at any time, that database is able to give us answers to specific questions (questions).
The process of creating a database is summarized in five main steps:
- Thinking about what to put in the database
- organize the table structure
- Organizing Question
- Create convenient interface for entering data
- Display report (maybe even print them)
The attempt failed at 90%, because the developer (the shoemaker) has not provided accurate information to developers.
;-)
soon!
Tuesday, November 13, 2007
Friday, November 9, 2007
Tuesday, November 6, 2007
93 Mustang Subwoofer Enclosure
Lesson 8: Discover the Web
The purpose of today's lesson (actually just ended) is to continue what you did last time: that is to take the list of sites proposed by the Magisterium, pick one, explore, use, understand and present the class with a "slideshow" done with Powerpoint.
Just for the record, here are the sites visited during the lesson:
Charles and Ilia: http://www.google.com/maps
Tiberius and Rosanna: http://www.duepuntozero.it
and Andrea Silvano http://www.hotornot.com
Gabriel and Daniel, http://www.duespaghi.it
Roberta and Paul http://www.duepuntozero.it
The Magister gave the example by analyzing the site for you: http://www.diino.com
I was very pleased with the work, I am pleased that the interest is always high and active participation, although often "pull at 11.30 am ..."
Good!
The purpose of today's lesson (actually just ended) is to continue what you did last time: that is to take the list of sites proposed by the Magisterium, pick one, explore, use, understand and present the class with a "slideshow" done with Powerpoint.
Just for the record, here are the sites visited during the lesson:
Charles and Ilia: http://www.google.com/maps
Tiberius and Rosanna: http://www.duepuntozero.it
and Andrea Silvano http://www.hotornot.com
Gabriel and Daniel, http://www.duespaghi.it
Roberta and Paul http://www.duepuntozero.it
The Magister gave the example by analyzing the site for you: http://www.diino.com
I was very pleased with the work, I am pleased that the interest is always high and active participation, although often "pull at 11.30 am ..."
Good!
Friday, November 2, 2007
Lower Back Pain And Cloudy
phobias PIU 'STRANGE
BY FEAR
-in-law than those who STINKS
. ARITHMOFOBIA: fear of numbers
. ATHAZAGORAFOBIA: fear of being forgotten or ignored
. AULOFOBIA: fear of flutes
. AUTODYSOMOFOBIA: fear of those who smell
. AUTOMATONOFOBIA: fear of statues, dolls, puppets
. CHRONOFOBIA: fear of time
. CYBERFOBIA: fear of computers
. GAMOFOBIA: fear of marriage
. HADEFOBIA: fear of bells
. LACHANOFOBIA: fear of vegetables
. OENOFOBIA: fear of wines
. PENTHERAFOBIA: fear of mother-in-law
. PONOFOBIA: too afraid to work
. ZELOFOBIA: fear of school
BY FEAR
-in-law than those who STINKS
. ARITHMOFOBIA: fear of numbers
. ATHAZAGORAFOBIA: fear of being forgotten or ignored
. AULOFOBIA: fear of flutes
. AUTODYSOMOFOBIA: fear of those who smell
. AUTOMATONOFOBIA: fear of statues, dolls, puppets
. CHRONOFOBIA: fear of time
. CYBERFOBIA: fear of computers
. GAMOFOBIA: fear of marriage
. HADEFOBIA: fear of bells
. LACHANOFOBIA: fear of vegetables
. OENOFOBIA: fear of wines
. PENTHERAFOBIA: fear of mother-in-law
. PONOFOBIA: too afraid to work
. ZELOFOBIA: fear of school
Subscribe to:
Posts (Atom)