Databases

Databases

1. Database: is an organised collection of related data. It is possible to add, edit, manage and retrieve data from a database

2. Functions are part of spreadsheet software. They are specialised calculations built in to the spreadsheet software.

3. Formulas perform calculations on cell contents. Must start with an =.

4. A 'conditional statement' often used within a spreadsheet. An IF statement checks to see if a statement is true or false

5. A workbook is made up of one or more 'worksheets'. A worksheet is a single tab in the spreadsheet workbook.

6. A record consists of a collection of related fields.

7. A Key fields uniquely identities each record. No two records have the same data in their key field. Also known as Primary Key.

8. Validation methods ensure reasonable and sensible data is input in to a system, but there is no certainty that the data is correct.

9. A report is a printed document that contains data from the database, organised and analysed in a certain way. A report from a student database might list the students in each class in alphabetical order

10. A file (Known as a table in Microsoft Access) is a collection of related fields.