Flashcards: Apps 1 2008 Database Vocabulary 1-18
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 |
|---|---|
 Auto Number | often used with/as a primary key to automatically assign a number to each record |
| Caption | a field property used for column naming that allows a more user-friendly and properly formatted field name than that stored in the database design |
| Complex sort | to move two appropriate fields adjacent to each other to accomplish the sort; example: Primary field: Rooms in ascending order; Secondary Field: Inn in ascending order |
| Currency | data type used to format numbers as decimal values with a dollar sign; monetary values |
| Database | an efficient means of storing and retrieving data and printing reports from the stored data |
| Database Relationship | a link between two or more tables in a database that have common fields, such as the Customer ID field in a Customer Address table and the Customer ID field in a Purchases table; eliminates the need for data duplication among tables |
| Date | data type used to arrange and sort data chronologically |
| Date format | often used with the input mask field property |
| Decimal places | field property used to format numbers for one or more decimal points |
| Entry | a single piece of data in a database table |
| Field | unique identifier for categories of information in a record |
| Filter | allows for the retrieval of information that meets specific criteria and is only used once; to the records in a table. It is a quick and temporary tool that is created for one-time use in the context of a particular table |
| Foreign key | when tables are linked by the primary key, this is the related field in the second table |
| Input Mask | a template-like field property that regulates how data is entered in a cell which prompts the user to input data in a specific format, such as (919) 555-5555 |
| Join line | a graphical representation of the link between two or more tables |
| Junction table | a table used to join primary key fields from multiple tables (a many-to-many relationship) |
| Lookup field | allows you to create a fixed set of choices for that field's entry values |
| Lookup Wizard | a data type used to define preset values for database entries which increases productivity and accuracy by reducing the amount of data entry required; example: the music store database might include this to provide a drop down list for the genres of music |