BusIM - Unit 3, Lesson 2, Part 1 Question Preview (ID: 9489)
MS Access.
TEACHERS: click here for quick copy question ID numbers.
A relationship between two tables in which only one table (the primary table) can have many related records in the other table (the related table) is called a
a) One-to-One Relationship
b) Subdatasheet
c) One-to-Many Relationship
d) Many-to-Many Relationship
A relationship between two tables in which each table has only one related record in the other table is called a
a) One-to-One Relationship
b) Subdatasheeet
c) One-to-Many Relationship
d) Many-to-Many Relationship
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.
a) Orphan
b) Relationshp
c) Related Table
d) Primary Table
Records in a related table (on the “many” side) that are left unrelated if their related record in the primary table is deleted or changed so that the relationship is broken.
a) Primary Table
b) Related Table
c) Relationship
d) Orphan
The table on the “one” side of a one-to-many relationship.
a) Primary Table
b) Primary Key
c) Referential Integrity
d) Related Table
A relationship between two tables in which each table can have many related records in the other table is called a (?)
a) Referential Integrity
b) One-to-One Relationship
c) One-to-Many Relationshp
d) Many-to-Many Relationship
A datasheet that is nested within another datasheet and contains records related to the records in the datasheet in which it is nested.
a) Orphan
b) Relationship
c) Subdatasheet
d) Primary Table
One or more fields in a table whose values uniquely identify each record.
a) Primary Table
b) Primary Key
c) Subdatasheet
d) Related Table
The table on the “many” side of a one-to-many relationship.
a) Related Table
b) Primary Table
c) Primary Key
d) Referential Integrity
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.
a) Relationship
b) Refenential Integrity
c) Primary Key
d) Subdatasheet
Play Games with the Questions above at ReviewGameZone.com
To play games using the questions from above, visit ReviewGameZone.com and enter game ID number: 9489 in the upper right hand corner or click here.
To play games using the questions from above, visit ReviewGameZone.com and enter game ID number: 9489 in the upper right hand corner or click here.
TEACHERS / EDUCATORS
Log In | Sign Up / Register
Log In | Sign Up / Register