Access lesson two terms

Data type: In Access, a field property that determine 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.

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 access database.

Input Mask: in access, a field property that determines display format and limits the type of data that can be entered.

Junction Table: in access, a table that provides a link between two tables that have a many-to-many relationship.

Link: the connection between a source file and a destination file, or between two tables.

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.

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 Relationships: in access, a relationship between two tables in which only one table can have many related records in the other table.

One-to-One Relationships: 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 related 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 of more fields in a table whose values uniquely identify each record.

Primary Table: in access, the table on the "one" side of a one-to-many relationships.

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.

Related Table: in access, the table on the "many" side of a one-to-many relationship.

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.

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.