Access - Lesson 2 Key Terms

Data Type: In access a field property that determines what type of data the field can contain
Export: The process of copying data from an access table or query to another database or to another type of file, such as an Excel worksheet.
Field Name: The name by which Access recognizes a data field.
Field Property: A specific attribute of an Access data field, such as name, caption, field size, or input mask.
Import: The process of copying data from another source, such as a database or spreadsheet, into an open Access database.
Input mask: In access , a field property that determines display format and limits the type of data that can be entered; makes data entry faster and more precise.
Junction table: In access, a table that provides a link between two tables that have a many-to-many relationship;the junction table has a one-to-many relationshipwith each of the two tables it links
Link: The connection between a source file and a destination file, or between two tables; any changes made later to the source file are reflected in the destination file.Contrast with embed.
Lookup 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.
Many-to-Many relationships: In access, a relationship between two tables in which each table can have many related records in the other table.
One-to-many Relationship: In access a relationship between two tables in which only one table can have many related records in the other table.
One-to-one Relationship: In access, a relationship between two tables in which each table has only one related record in the other table.
Orphan: In access, records in a relationship table that are left unrelated if their related record in the primary table is deleted or changed so that the relationship is broken.
Primary Key: In access one or more fields in a table whose values uniquely identify each record.
Referential Intergrity: A system of rules that access uses to ensure that relationships between records in related tables are valid, and that you don't accidentally delete or change related data.
Related Table: In access, the table on the many side of a one-to-many relationship.
Relationship: In access, the association between two tables that share a field with amtching values; the matching values the matching fields allow the tables to be joined, so that a query can select data from both tables.
Subdatasheet: In access a datasheet that is nested within another datasheet and contains records related to the records in the datasheet in which it is nested.