A | B |
database | A tool for collecting and organizing information |
table | The most basic database object; stores data in categories |
datasheet | A visual representation of the data contained in a table or of the results returned by a query |
data type | The kind of information a field contains—whether text, number, date/time, or some other type |
field | A column in a database table |
form | A database object that simplifies the process of entering, editing, and displaying data |
groups | Collections of records separated visually and displayed with its introductory or summary information |
normal forms | The standards and guidelines of database design that can be used to determine if a database is structured correctly |
normalization | The process of applying rules to a database design to ensure that information is divided into the appropriate tables |
objects | Database elements, such as tables, queries, forms, and reports |
primary key | The column in a database that uniquely identifies each row |
query | A database object that enables stored data to be searched and retrieved |
record | A row in a database table |
redundant data | Duplicate information in a database |
relational database | A group of database tables that is connected or linked by a defined relationship that ties the information together |
report | A database object that presents information in a format that is easy to read and print |
database management system (DBMS) | A system for managing data that allows the user to store, retrieve, and analyze information |