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

Front

Database

Back

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

Front

Query

Back

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.