Term
|
Definition
| a database management system software program used to organized, store, maintain, retrieve, sort, and print all types of business data. |
|
|
Term
|
Definition
| comprised of a series of objects that you use to enter, manage, view, and print data,. |
|
|
Term
|
Definition
| holds data that uniquely identifies each record in a table and is usually an identification number |
|
|
Term
| Join lines or relationships |
|
Definition
| they represent links established between tables so that data can extracted from one or more tables |
|
|
Term
|
Definition
| a database with related tables |
|
|
Term
| Defining the table structure |
|
Definition
| process to creating a new table generally involves determining fields, assigning a data type to each field, modifying properties, designating the primary key |
|
|
Term
|
Definition
| commonly called a column, is a one piece of information about a person, place, or item |
|
|
Term
|
Definition
| all fields are one unit, such as a customer or product |
|
|
Term
|
Definition
| a collection of records; organizes data in fields and rows |
|
|
Term
|
Definition
| unique and describes the contents of the field |
|
|
Term
|
Definition
| specifies the type of data that will be entered in the field, helps to manage and maintain the data |
|
|
Term
|
Definition
| used in a table to define field names and assign data types |
|
|
Term
|
Definition
| used to enter data in fields and organizes fields into columns |
|
|
Term
|
Definition
|
|
Term
|
Definition
| the way data in a field is displayed |
|
|
