Database Vocabulary

Front

What is a Database?

Back

A structured collection of data that is stored electronically. In Access, databases can be created to manage large sets of information.

Front

What is a Table?

Back

A collection of related data entries organized in rows and columns. Each table contains records (rows) and fields (columns).

Front

What is a Field?

Back

A single piece of data in a table, analogous to a column in a spreadsheet. Each field has a specific data type, such as text, number, or date.

Front

What is a Record?

Back

A single entry in a table, consisting of multiple fields. Each record represents a unique instance of the data being stored.

Front

What is a Primary Key?

Back

A unique identifier for each record in a table. It ensures that no two records can have the same primary key value.

Front

What is a Query?

Back

A request for data or information from a database. Queries can be used to filter, sort, or calculate data based on specific criteria.

Front

What is a Form?

Back

A user-friendly interface that allows users to enter, edit, and view data in the database. Forms can be customized for ease of use.

Front

What is a Report?

Back

A formatted presentation of data extracted from one or more tables or queries. Reports are often used for printing or sharing information.

Front

What is a Relationship in a database?

Back

The connection between two or more tables in a database. Relationships help maintain data integrity and allow for complex queries.

Front

What is a Data Type?

Back

The classification of data based on its nature, such as text, number, date/time, currency, or yes/no. Data types determine what kind of data can be stored in a field.