Basic Vocabulary Terms Flashcards
Database
A collection of information related to a particular topic or purpose
Database Management System (DBMS)
A program such as Microsoft Access that stores, retrieves, arranges, and formats information contained in a database
Database modeling
The process of strategically planning where to store each piece of information you wish to include in your database
Data sheet
A format of columns and rows displaying information
Field
Appears as columns in a table and cells in a form
Field data types
A characteristic of a field that determines what kind of data it can store (Text, Number, Date, etc.)
Form
A structured document with specific areas for viewing or entering data one record at a time
Join Line
The line between two tables identifying the common field between them
Nonrelational database
Flat file database; Stores information in one table
Object
A component of a database, such as a table, query, form, or report
One-to-Many relationship
A relationship in which a record in the primary table can be related to one or more records in the related table
One-to-One relationship
A relationship between two tables in which for each record in the first table, there is only one corresponding record in the related table
Primary Key
A field in a table whose value uniquely identifies each record in the table
Query
A request for a particular collection of data in a database
Query By Example (QBE) grid
The portion of the Query Design window used for selecting fields, setting criteria, and setting sort order in a select query
