Database elements
What is the other name for the table rows?
Record (Tuple)
This mode allows us to change the structure of a table, form, query, and report
Design View (Режим конструктора)
What is the name of a table that has a Primary key when tables are related?
Parent table
What data type tracks date and time?
Data/time
What is the other name for the table columns?
Field (attribute)
This mode allows to us quickly and easily create tables, forms, queries, and reports
Wizard (Режим мастер)
The table that contains the foreign key is considered the ...
Child table
What data type includes decimal or real numbers?
Floating-Point
What determines the type of data that the user can enter in the field?
Field type
This mode allows to us easily enter data into the Form
Database Form
It requires the child table Primary Key to be associated via a Foreign Key with the parent table Primary Key column
one to one
What data type includes a string of characters?
Text
It has three types and it is impossible to create the correct query without it
Relationship
This mode allows me to view the results of a query or table in a text editor program
Libreoffice Writer
It is the most common relationship, and it associates a row from a parent table to multiple rows in a child table
one to many
What data type is include a whole number?
Integer
It has two types and the table doesn't function without it
Key (Primary & Foreign)
In this window we can edit the report structure
Report Builder
It requires a link table containing two Foreign Key columns that reference the two different parent tables
many to many
Name three different types of DATA/TIME that you can see in LibreOffice Base
DATE, TIME, TIMESTAMP or DATETIME