Basic Vocabulary Terms Flashcards
(22 cards)
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
Record
A row in a table or spreadsheet
Related Table
A table with a common field that uses values stored in a primary table
Relational Database
A database that is useful for maintaining and analyzing complex information stored in a number of tables
Relationship
The direct or indirect association between any two tables in a database
Report
A formatted collection of information organized to provide printed data on a specific subject
Select Query
A query that answers a question about one or more tables by limiting the number of records and fields displayed
Table
An arrangement of related information stored in columns and rows
