group of database tables that are connected or linked by a direct relationship that ties the information together
Network database
Relational database
Private database
Business database
Column in a database table
Field
Query
Record
Form
Elements in a database such as tables, queries, forms and reports.
Records
Objects
Datasheets
Data types
A system for managing data that allows the user to store, retrieve and analyze the information.
Query
Record
Database management system (DBMS)
Field
Row in a database table
Field
Query
Record
Form
Database object that simplifies the process of entering, editing, and displaying data
Field
Query
Record
Form
Database object that asks a table a question
Field
Query
Record
Form
Kind of information a field contains whether it is text, number, date/time, or some other type.
Field
Data type
Record
Form
Columns in a database that uniquely identify each row
Primary key
Secondary key
Foreign key
Private key
Database object that enables stored data to search and retrieve
Field
Query
Record
Form
duplicate information in a database
Secondary data
Primary data
Redundant data
Private data
A visual representation of the data contained in a table or the results returned by a query.
Database
Datasheet
Record
Query
process of applying rules to a database designed to ensure that information is divided into the appropriate tables
Form
Record
Normalization
Query
Tool for collecting and organizing information
Data type
Database
Record
Field