Please enable JavaScript.
Coggle requires JavaScript to display documents.
Databases (Data types (Number (A collection of number), Currency…
Databases
Data types
Number
A collection of number
Currency
Money/price
Text
a collection of letters
Date and time
A date of an event
Autonumber
A number changes by one each cell
Boolean
Two choices like true or false
Data Validation
Length check
Checks the length of the data and compares the rules you set up
Length must be 11 characters
Presence check
A data must be filled in
Range check
Check the range of the data and checks it against the rules you set up
Between 1 - 10
Format check
DD/MM/YYYY
Checks the data and checks it against the rules you set up
Definitions
Database
An organised collection of data
Field
A column and all entries on one thing
Record
All things on one person or thing
Data verification
Double entry
You enter the data to check it
Proofreading
Someone checks the data to a primary source
Checks that the data is accurate