Reading...
Play button
Play button
Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
19 Cards in this Set
- Front
- Back
|
A field property that determines what type of data the field can contain.
|
Data Type
|
|
|
The process of copying data from an Access table of query to another database or to another type of file such as an Excel worksheet.
|
Export
|
|
|
The name by which Access recognizes a data field.
|
Field Name
|
|
|
A specific attribute of an Access field such as name caption field size or imput mask
|
Field Property
|
|
|
The processs of copying data from another source such as a database or spreadsheet into an open Access database.
|
Import
|
|
|
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.
|
Input Mask
|
|
|
A table that provides a link between two tables that have many-to-many relatioinship the juntion table has one-to-many relationship with each of the two tables it links.
|
Junction Table
|
|
|
The connection between a source file and a destination file or between two tables any changes made later to the source file are reflested in the destination file.
|
Link
|
|
|
A field that looks up a list of values in another table or in a statistic list and presents the list of values for data entry selection.
|
Lookup Field
|
|
|
A relationship between two tables in which each table can have many related records in the other table.
|
Many-to-many Relationship
|
|
|
A relationship between two tables in which only one table can have many related records in the other table.
|
One-to-many Relationship
|
|
|
A relationship between two tables in which each table has only one related record in the other table.
|
One-to-one Relationship
|
|
|
Records ina related table that are left unrelated if their related record in the primary table is deleted or changed so that the relationship is broked.
|
Orphan
|
|
|
One or more fields in a table whose values uniquely identify each record.
|
Primary Key
|
|
|
The table on the "one" side of one-to-many relationship.
|
Primary Table
|
|
|
A system of rules that Access uses to ensure that relationships between records in related tables are valid.
|
Referential Integrity
|
|
|
The table on the "many" side of a one-to-many relationship.
|
Related Table
|
|
|
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 selected data from both tables.
|
Relationship
|
|
|
A datasheet that is nested within another datasheet and contains records related to the records in the datasheet in which it is nested.
|
Subdatasheet
|
