How can we help?

You can also find more resources in our Help Center.

17 terms

Database

A database is a tool that contains all your data.
STUDY
PLAY
Databases
A database is a tool that contains all your data.
Field
Where a piece of information is seperate.
Record
Where all the information is based on one thing
File
When all of the records are stored together
Alphanumeric or Text
This allows you to type in text, numbers and symbols
Number
This allows a whole number or decimal number.
Only numbers can be entered, no letters or symbols.
Currency
This automatically formats the data to have a £ or $ or Euro symbol in frot of the data and also ensures that there are two decimal places.
Date/Time
Checks that a date actually exists
Autonumber
This datatype will automatically increase by 1 as records are added to the database
Logical, boolean, yes/no
This data type is often refered to as different things, you may hear it called 'logical', 'bolean' or 'yes/no'
Flat File Database
When all of your data is stored in one table
Data Duplication
Repeating data which can cause mistakes
Relational Database
When the data is split up into sensible groups
Data
Data is something which is not useful for example: 24061999. These numbers have no meaning and are not useful.
Information
Information is when the data becomes useful for example: 24061999. These numbers have been said to be a date a birth and now the data is useful therefore the numbers 24061999 is information.
Knowledge
Knowledge is having the wisdom to link information together and understanding what to do with the information.
Data Capture Form
A form that captures all your data.