*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
Assignments
Table on the different types of data
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
Exporting Information from a Database Table to Microsoft Outlook
Table of Contents
Notes
Assignments
Files, records and fields
Homework
Notes
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
Assignments
Table on the different types of dataDATA TYPES
POSTER PLANNING
Files, records and fields
Exporting Information from a Database Table to Microsoft Outlook
Homework
POSTER