Database Vocabulary - Definition on Front

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

• Record

• Field

• Table

• Entry

The name of Microsoft's DBMS.

• Access

• MySQL

• Oracle

• PostgreSQL

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

• Database Management System (DBMS)

• Data Analysis Tool

• Spreadsheet Software

• Data Warehouse System

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

• Table

• List

• Array

• Record

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.

• Field

• Record

• Table

• Attribute

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

• Primary Key

• Foreign Key

• Unique Key

• Composite Key

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

• Table View

• Grid View

• Datasheet View

• Record View

A formatted way to look at data retrieved from a query.

• Report

• Summary

• Analysis

• Overview

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

• Database

• Spreadsheet

• Data Warehouse

• File System

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

• Data

• Information

• Content

• Metadata