Key Terms in Database Software

Front

Mail Merge

Back

A process that allows users to create personalised letters and documents by combining a template with a data source.

Front

Macro

Back

A set of instructions that automate repetitive tasks in software applications.

Front

Database

Back

An organised collection of structured information, typically stored electronically.

Front

Export

Back

The process of transferring data from one application (like Access) to another (like Word).

Front

Field

Back

A single piece of data or category within a database (e.g., name, address).

Front

Primary Key

Back

A unique identifier for a record in a database table, ensuring that each record can be uniquely identified.

Front

Query

Back

A request for data or information from a database, often used to retrieve specific data by filtering certain criteria.

Front

Form

Back

A user-friendly interface for entering, modifying, and viewing data in a database.

Front

Table

Back

A collection of related data held in a structured format within a database, consisting of rows and columns.

Front

Relationship

Back

An association between tables in a database, typically established through foreign keys, to ensure data integrity.