Database Vocabulary - Word on Front

Front

Data

Back

Information entered into a database that consists of text, numbers, sounds, and images.

Front

Database

Back

A stored collection of data that can be easily organized and retrieved.

Front

Database Management System (DBMS)

Back

Software used to create a database and analyze the data it stores.

Front

Access

Back

The name of Microsoft's DBMS.

Front

Table

Back

A set of RECORDS (rows) and FIELDS (columns) used to store and organize data in a database.

Front

Field

Back

A category of data in a table that describes a specific characteristic of a record (e.g., Customer Name, License Plate #). Columns in the table.

Front

Primary Key

Back

The first field in a table that uniquely identifies each record (e.g., Customer Number, Order Number).

Front

Record

Back

A complete set of data fields for a specific object, person, or event in a database. Rows in the table.

Front

Datasheet View

Back

The "normal" view of a table that displays data as Fields and Records.

Front

Design View

Back

The view of a table that lets you add, delete, and rearrange fields. You can also change the way fields store data.