you are, the only exception

weeeeeeeeeeeeeell, hasn't it been awhile.
tomorrow, basically we are just going to present our 'mini projects'.

and i've decided that i shall do some tasks, well task 5 in particular.
&& let's create a form :)


weeeeeeeeell, first you open up the database window then go to forms which is under objects. click new. then a window will open and you chose one of the autoforms or wizards. I chose to use the form 'wizard'.
&& in the drop down thing (sorry, i don't know what it's called) you then choose which table or query you want the information to come from and click okay, then another screen will open and you double click which fields you want to be shown and click next.
you then have to chose which format you want it to be shown in and click next. you then get to choose which background you want and click next. finally you name the form and click finish.
you are able to go through all the records with only the selected fields showing or go to the first or last record in the file.

here is my wonderful example :)


seriously, i can't upload ! i am going to go home and try it from there, because i need to upload my work to prove that i don't just sit around and do nothing all lesson.

passing by you, light up my darkest skies

spam spam spam spam spam spam spam spam spam spam :)

just so you know, this is a mini project, not an assignment :)
ummm, i'm working with ariadne in this just like old times.. and there are six dot points we have to complete, so ariadne is going to do numbers;1,3,5 and i shall complete;2,4,6 and next lesson we are going to converge and create a powerpoint?

2. How are databass involved in this topic? they store your email address so they can send you pointless emails to try and scam you. they find your email by say lets 'google search' they just scan through emails, and store it on their databases.

4. Describe some of the ways in which this data can be misused. This type of data can be misused due to that people give their information away believing that they will get something in return, when in reality they only just get pestered with annoying emails, and in some cases, lose their identity.

6. What are the legal responsibilities. Well, spammers don't really have legal responsibilioties

so i can lose my memory

well as of right now i shall be creating a database as stated in activity 4.0 :)
upload next lesson :)

weeeeell, this is a sample database that i created.

you've got a riot on your hands

you've got yourself a wild card ;)

a wild card query is one that shows all records matching the same letter or information provided. and it doesn't even require to be a full name or number. it can be as simple as the first letter of the name/surname you are looking for and have an asterics before/after that.
eg. *X (this wild card will show all records that end in the letter X.)
if it was X* (this would show all records that start with the letter X)

i won't give up, i won't let you down.

queries can be an "and" query or an "or" query.

"and" - both conditions must be true

"or" - at least one condition must be true

here are some answers to some questions about some query.. and wasn't that vague

Question 11. What sort of information has the query selected? all information that matched the query, for example in the picture above shows all the people who's postcode is 2010 in my database.

Question 12. We can alter any query as follows... What sort of information has this second query selected? It goes into further detail, basically meaning that the people in the database will have more specific details in common.

how can this be, it was all so simple then

task 3.1, ah boo-ya :)
creating a basic database... ... the address book
well, i can't exactly show you that i'm watching a tutorial, but i am..
and probably next lesson (which you won't really know, because i'll use this post ;) i shall create a database titled 'address book'.

welcome to the wonderful world of narnia :)

&& there are different types of databases, the 'and' query or an 'or' query.

for an 'and' query both conditions must be true opposed to an 'or' query where at least one must be true. for example, they live in sydney or they are born in 1990.

&& this is how i made the address book :)
so as the address book was saved as a table. I was now to click on the query tab, then new. I was then to drag all the fields into the field coloumn in my query table. then I was to type in one of the poscodes from my address book into the credits coloumn. then save the query.

:)

welcome to hogwarts :)

wassup russia ;)

this is going to be on database definitions :)

Question Uno.

Provide a basic definition for each of the following terms;
well, actually a picture :)

and here are the definitions..

file is a collection of information that is used, which is always in a particular format.

query is a users request for information from a collection of data such as records in a database.

database is an organized body of related information, which can be easily accessed, managed and updated

report a written document describing the findings of a particular topic.

DBMS (database management system) a software system that facilitates the creation and maintenance and use of an electronic database

database dictionary is a collection of descriptions of the data objects or items in a data movel for the denefit of programmers and others who need to refer to them

data type is a data storage format that can comtain a specific type or range of values

doneeeeeeeeeeeee, wow, i just flew through that :)

iss never happen before

database activity: the yellow pages :)

now, you may been asking now, what exactly is a database ?
and now, i shall tell you :)
(just to tell you now, I've started using LOTS of smiley faces, because they're really nice and happy)

A database is a collection of information that is organized so that it can easily be accessed, managed, and updated. Very useful :)

now, you may be wondering, what are some examples of databases..well, you know when you go to a library, and they scan the book you want to borrow, i think it's called a catalogue, that's a database.

now here are some questions :) (see i told you i really like smiley faces)

Question One; I know there is a computer shop in the main street of Katoomba (Katoomba St.), but I don’t know its name. See if you can find the number for me.
well, i don't think i'm meant to give you the address, so i'll tell you how to find it on yellowpages.com. First, you would type 'computer shops' in the business type section, then tell yellowpages (not verbally) that it is located in katoomba street, then it'll direct you to all the computer shops in katoomba. easy, simple and efficient :)

Question Two; Is the yellow pages a database? of course it is silly :) because as stated above, it is a collection of data thaat is organised, and can be used easily and efficiently.

Question Three; Advantages of the electronic internet yellow pages? it's more economic as you don't have to print millions of copies to hand out to every house hold which means it's better for the environment because we're not cutting down as many trees, they can actually show you where the store is, because there is a map, which you can print out, and of course, the address/phone number :)

Question Four; Disadvantages/dangers. wow, that just makes it seem evil now doesn't it. Some of these are, not everyone has internet, hence no yellowpages.com. also that we realised that it is quite easy to stalk someone because all you need to know is their last name, and type it into the search, and bam; you have their address :/

doneeeeeeeeeeeeeeeeeeee :)