Flashcards: Apps 1 2008 Database Vocabulary 19-36
About these flashcards
Created by:
pam_medlin on January 7, 2009
Subjects:
Log in to favorite or report as inappropriate.All 18 terms
Terms | Definitions |
|---|---|
 Many-to-Many Relationship | when multiple records from both (or more) tables are linked |
| Memo | a data type used for lengthy entries that allows combinations of text and numbers; max of 64,000 characters |
| Number | this format is applied to a field that will be sorted chronologically |
| One-to-Many Relationship | when a record in one table is linked to more than one record in another table |
| One-to-One Relationship | when only one record is linked to a record in another table |
| Primary Key | a unique field in a database table that is of the same data type and size as a related field in a linked table |
| Query | an object that allows selection of data that meets certain criteria from one or more tables in a database to be saved and is reusable; takes a database filter to the next level |
| Raw Data Import | a useful and practical method for obtaining information from other sources and creating database tables; eliminates the need for repetitive data entry and assists in the protection of the data's integrity |
| Record | a group of related fields of information |
| Referential integrity | protects related data that is stored in multiple tables; example: this would prevent a customer in a customers table from being deleted if the customer's ID also appears in the order table |
| Report | an object that is used to organize, summarize, and print some or all of the data in an attractive format from one or more database tables or queries |
| Simple sort | sorting only one field in a database |
| Sort | allows for information to be arranged in a specific order such as alphabetical, chronological, ascending, or descending |
| Table | the building blocks of all databases; used to group and organize the information within a database and are arranged in columns and rows |
| Text | Includes words and/or numbers not used in calculations |
| Text-based data types and field properties | used for data that will be sorted in alphabetical order or listed randomly, but will not be used in mathematical calculations |
| Time | data type used to arrange and sort data chronologically; often used with input mask field property |
| Yes/No | a data type in toggle format that allows a user to select a yes or no value in a database cell; is also a true/false field |