Lesson 2 key terms

1. Data type: In Access, a field property that determine what type of data the field can contain.
2. Export: The process of copying data from an access table or query to another database or to another type of file.
3. Field Name: The name by which access recognizes a data field.
4. Field Property: A specific attribute of an access data field, such as name, caption, field size or input mask.
5. Import: The process of copying data from another source, such as a database or spreadsheet, into an access database.
6. Input Mask: in access, a field property that determines display format and limits the type of data that can be entered.
7. Junction Table: in access, a table that provides a link between two tables that have a many-to-many relationship.
8. Link: the connection between a source file and a destination file, or between two tables.
9. Look up Field: in access, a field that looks up a list of values in another table or in a static list and presents the list of values for data entry selection.
10. Many-to-Many Relationships: in access, a relationship between two tables in which each table can have many related records in the other table.
11. One-to-Many Relationships: in access, a relationship between two tables in which only one table can have many related records in the other table.
12. One-to-One Relationships: in access, a relationship between two tables in which each table has only one related record in the other table.
13. Orphan: in access records in a related table that are left unrelated if their related record in the primary table is deleted or changed so that the relationship is broken.
14. Primary Key: in access, one of more fields in a table whose values uniquely identify each record.
15. Primary Table: in access, the table on the "one" side of a one-to-many relationships.
16. Referential Integrity: a system of rules that access uses to ensure that relationships between records in related tables are valid, and that you done accidentally delete or change related data.
17. Related Table: in access, the table on the "many" side of a one-to-many relationship.
18. Relationships: in access, the association between two tables that share a field with matching values; the matching fields allow the tables to be joined, so that a query can select data from both tables.
19. Subdatasheet: in access, a data sheet that is nested within another data sheet and contains records related to the records in the data sheet in which it is nested.