Archive for July 2017
Understanding Databases – Glossary Of Terms
AND A logical operator that is used in queries to state that values must satisfy all of the set criteria. Autovalue A feature that can be attributed to data under a certain field (often the primary key) of a table that will automatically create a unique number for each entry. Best used with ‘integer’ data…
Read MoreWorking with Databases
Open a database application To start LibreOffice Base, search from the ‘Start’ menu or find the LibreOffice folder and click the LibreOffice Base icon. Open an existing database To open an existing database, choose the option ‘open an existing database file’ from the wizard, which is the first screen you see. Choose a file from…
Read MoreUnderstanding Databases
Key Concepts A database is a collection of data stored in tables to be easily accessed, managed, and updated. Examples might be a shop’s stock inventory or airline booking system. Tables are split up into records (rows) and fields (columns) A database offers more complex ways of using data than spreadsheets and data can be…
Read More