LibreOffice Base & Database Data Types

Vocabulary flashcards covering key terms from the lecture page on LibreOffice Base, its functions and primary data type categories.

Database Management System (DBMS)

Software that stores, organises and retrieves data while managing relationships between tables.

LibreOffice Base

The open-source DBMS within the LibreOffice suite that lets users store, organise, query data, build forms and generate reports.

Data Type

A specification that defines the nature of data in a table field and how it is stored, processed and validated.

Text Data Type

Stores combinations of letters, numbers and symbols treated as text; arithmetic operations are not performed on this data.

Numeric Data Type

Category of data types designed to store numbers on which calculations can be performed.

Date and Time Data Type

Category used to store calendar dates and clock times.

Binary Data Type

Category used to store binary objects such as images or embedded (OLE) files.

Memo (LONGVARCHAR)

A text data type intended for long blocks of text.

Query

A request that retrieves specific information from the database according to given criteria.

Form

A user-friendly interface created to enter or edit data in tables easily.

Report

A formatted output generated from database data, often used for printing or sharing results.