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 More

Working 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 More

Understanding 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