click below
click below
Normal Size Small Size show me how
DBase Unit 2
Advanaced Database Vocabulary Unit 2
Question | Answer |
---|---|
Common field | a field that appears in more than one table, allowing you to connect or join the records |
Data redundancy | a condition that occurs when you store the same data in more than one place; it wastes storage space and can cause inconsistencies |
Input mask | a field property you add with a predefined format for entering and displaying data. (input mask for phone numbers, zip codes, social security numbers) and the like, so that when you are keying in the data you do not have to key in the (), - , etc |
Join | to relate tables through a common field |
Lookup field | this can be set so that the values in the field can either be brought in from another table or they can be created by the user. |
Many-to-many relationship | a relationship between two tables in which each record in the first table matches many in the second table and each record in the second table matches many records in the first table. You must create a third table to join the two tables |