Please enable JavaScript.
Coggle requires JavaScript to display documents.
Revision 2 :black_flag: :recycle: (Spreadsheet (Examples (Calculating…
Revision 2 :black_flag: :recycle:
Databases
Databases are use to represents large amounts of data into one area
Examples
Police use criminal databases to see who committed the crime
Songs that will play at a disco
Football player ratings for a football team
Parts of a database
Record
The answer to the field
Field
The type of information you will be giving them
Table
The whole thing : : : :!!: :smiley:
Queries
They are used to orginise data
They help find data easier
How to use:
Select query design
Select the information you want to process then add
Select which field you want to find things with
Then type in the record you want for each one using = < > <= >= AND BETWEEN OR NOT.
1 more item...
Spreadsheet
Property wise- Spreadsheets are the same as a Database.
They have co-ordinates instead of fields.
It goes.....
ABCDEFGHIJK.....
AND 123456789....
Each co-ordinated area is known as a cell
Examples
Calculating prices / Income
Battleships : : :smiley:
Formulas
Spreadsheets can also work as calculators.As if you put in a number in say F9 then put one in C4. If you press another cell you can select these other two cells and add them up it puts the answer into the selected box.
You can enter any mathematical symbol but because you don't have a divide or times on the keyboard you use these:
Divide=/
Times=* (Shift+8)
Filtering
Filtering data in a spreadsheet means to set conditions so that only certain data is displayed.
