Recent Changes

Table on the different types of data
Files, records and fields
Exporting Information from a Database Table to Microsoft Outlook
Homework
notesNotes
Files, records and fields
{database.JPG}
Exporting Information from a Database Table to Microsoft Outlook
{outlook.JPG}
homeworkHomework
POSTER

assignmentsAssignments
Table on the different types of data
{school_databases.JPG} DATA TYPES
FIELD TYPE
USES
FIELDS
Text
Text
Name, Surname,
Memo
Large amount of text
Detail of Allergies
Number
Numbers (1,2,3)
Student ID (matricula), Age
Date
Dates (11/12/09)
Date of birth, Arrival
Time
Time (16:31)
Currency
$ or €
Money you have to pay
Autonumber
It generates a number everty time a new record is created
Container or OLE object
Files (pictures, etc)
Picture of the student
Boolean or Logic
Yes/No, True/False
Allergies
Calculation
Result of a formula
How much money you have to pay each month
The key field
POSTER PLANNING
Files, records and fields
{database.JPG}
homeworkHomework
POSTER
{databases.jpg}

notesNotes
Basic information on Databases
Databases
*A database is an application software that is used to quickly search and retrieve information or data that has been collected and specially organized.
*A database may be used to keep information about a CD, in a personal computer; so it’d be a small database. A larger database would be used by public, commercial and industrial organizations to maintain their business and services. Databases can also be used to book holidays and airline tickets through to the Police National Computer.
*Advantages:
It's a faster method
It saves paper
Alternative to always backing up information
Wide range of designs
Improved data security
CRUD (Create Retrieve Update Delete)
Disadvantages:
Time-consuming
Diffiucult to use at first
It could be deleted/corrupted/stolen
assignmentsAssignments
Table on the different types of data

Table of Contents
Notes
Basic information on databases (definition, data types...)
Assignments
Table on the different types of data
Files, records and fields
Homework
notesNotes
Basic information on Databases
assignmentsAssignments
Table on the different types of data
{school_databases.JPG}
Files, records and fields
{database.JPG}
homeworkHomework

Intranets and Encryption
{IntranetsPg170.jpg}
{IntranetsPg171.JPG}
1) An intranet is a private network based on internet standards but only available within the business or other organization. It’s different to the internet in the sense that it cannot be accessed by anyone who’s not a part of the business. Also, it’s not directly connected to the internet, however, some intranets allow access. If a school has an intranet, it may use it in the following ways: to upload room changes, examination timetables, sports teams and results, revision guides and homework tasks. These can be shared between teachers and students.
2) An intranet is only available within a business or an organisation. An extranet allows authorised outsiders to access the extranets.
3) EDI: (stands for Electronic Data Interchange) allows data to be exchanged and is a special way to transfer business documents, such as orders and invoices.
e-commerce: it's the term given to the buying and selling of goods and services throught the internet and, particularly, the WWW (World Wide Web).
encryption: to put data into a special computer code to prevent other people from accessing the specific data.
assignmentsAssignments
QUESTIONS