Revision 2 :black_flag: :recycle: (Spreadsheet (Examples (Calculating…
Revision 2 :black_flag: :recycle:
Databases are use to represents large amounts of data into one area
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
The answer to the field
The type of information you will be giving them
The whole thing : : : :!!: :smiley:
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...
Property wise- Spreadsheets are the same as a Database.
They have co-ordinates instead of fields.
Each co-ordinated area is known as a cell
Calculating prices / Income
Battleships : : :smiley:
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:
Filtering data in a spreadsheet means to set conditions so that only certain data is displayed.