Review Game Zone
Flash Cards
(current)
Games
Teachers
Search
BusIM - Unit 3, Lesson 2, Part 1
Test Description: MS Access
Instructions: Answer all questions to get your test result.
1) 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
Many-to-Many Relationship
C
Subdatasheet
D
One-to-Many Relationship
2) A relationship between two tables in which each table has only one related record in the other table is called a
A
Many-to-Many Relationship
B
Subdatasheeet
C
One-to-One Relationship
D
One-to-Many Relationship
3) 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
Related Table
B
Relationshp
C
Primary Table
D
Orphan
4) 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
Relationship
B
Orphan
C
Related Table
D
Primary Table
5) The table on the “one” side of a one-to-many relationship.
A
Related Table
B
Primary Table
C
Primary Key
D
Referential Integrity
6) 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
Many-to-Many Relationship
C
One-to-Many Relationshp
D
One-to-One Relationship
7) A datasheet that is nested within another datasheet and contains records related to the records in the datasheet in which it is nested.
A
Relationship
B
Subdatasheet
C
Orphan
D
Primary Table
8) One or more fields in a table whose values uniquely identify each record.
A
Related Table
B
Primary Key
C
Primary Table
D
Subdatasheet
9) The table on the “many” side of a one-to-many relationship.
A
Primary Key
B
Referential Integrity
C
Primary Table
D
Related Table
10) 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
Subdatasheet
B
Relationship
C
Refenential Integrity
D
Primary Key
*select an answer for all questions
Check Results & Get Answers
Play Games with the Questions Above
Teachers: Create FREE classroom games with your questions
Click for more info!
©2007-2024
ReviewGameZone.com
|
About
|
Privacy
|
Contact
|
Terms
|
Site Map
WAIT! Find what you needed?
×
Still Looking for the Answers?
Have Another Question?
Play a Review Game with These Questions?
Want to Make Your Own Test Like This One?