Basic Concepts
structure of rows and columns that integrate a collection of data.
Table
Similar to a spreadsheet, this view allows you to view, edit, and add data directly to table or query. Data are displayed in rows and columns.
Datasheet View
Is created from the database, shoing records of the table.
Form
These allow
relationships to be
established between
tables, which allows
information to be
structured differently
Foreign
the rows of the table, where each file have a name and a set of data.
Record
Allow s you to modify the internal structure of database objects, such as tables, forms, reports or queries. You can define fields, datas types and establish relationships between tables.
Design View
Presention of data in clear and concise way.
Report
Field or set of fields
that uniquely identifies
each record within a
table. It´s crucial, as it
ensures no duplicate
records in a table.
Primary
the columns of the table, where each field has a name and a type of data.
Field
Enter or display data in a more accesible and personalized format. Are designed to facilitate data entering in a more intuitive way.
Form view
Filters data from one or multiple
tables.
Extracts and saves relevant data.
Query
Made up of two or
more fields that, when
combined, guarantee
the uniqueness of
each record in a table.
Compound
It is used to display data in a
more accesible and
personalized format. Forms are
designed to facilitate data
entering in a more intuitive
way.
Report view
It is the key to organizing
and managing information
in databases.
Text
Allows the user to see how a
report will look before printing
it.
Preview
They are used to perform
arithmetic operations or
functions like sum or average.
Number