Database Vocabulary

Query

• A command to execute a program

• A search or question to retrieve specific information (or data) from a database.

• A type of database management system

• A method for storing data in a file

Field

• A type of database query

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

• A method for sorting data in a table

• A graphical representation of data

Design View

• A view that allows you to add, delete, and rearrange fields, and change how fields store data.

• A view that only displays data without any editing capabilities.

• A view that is used for printing reports and summaries.

• A view that provides a graphical representation of data relationships.

Primary Key

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

• A field that can contain duplicate values in a table.

• A field that is used to store images in a database.

• A field that is automatically generated by the database.

Data

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

• A collection of unrelated facts and figures.

• A type of software used for data analysis.

• A method of storing information in physical form.

Database

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

• A type of software used for data analysis.

• A physical location where data is stored on a hard drive.

• A method for encrypting sensitive information.

Report

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

• A type of database management system.

• A method for data encryption.

• A visual representation of data trends.

Datasheet View

• A view that displays data as Fields and Records.

• A graphical representation of data in charts.

• A view that allows editing of data in a spreadsheet format.

• A view that shows data in a hierarchical structure.

Database Management System (DBMS)

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

• A type of hardware used for data storage.

• A programming language for web development.

• An operating system for managing computer resources.

Form

• A user-friendly way to enter, view, and edit data into a table.

• A method for organizing data in a spreadsheet.

• A type of database management system.

• A programming language for web development.