Advertisement Upgrade to remove ads

A database is a tool that contains all your data.

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.

Please allow access to your computer’s microphone to use Voice Recording.

Having trouble? Click here for help.

We can’t access your microphone!

Click the icon above to update your browser permissions above and try again

Example:

Reload the page to try again!

Reload

Press Cmd-0 to reset your zoom

Press Ctrl-0 to reset your zoom

It looks like your browser might be zoomed in or out. Your browser needs to be zoomed to a normal size to record audio.

Please upgrade Flash or install Chrome
to use Voice Recording.

For more help, see our troubleshooting page.

Your microphone is muted

For help fixing this issue, see this FAQ.

Star this term

You can study starred terms together

NEW! Voice Recording

Create Set