Site MapHelpFeedbackLesson 09 Quiz
Lesson 09 Quiz
(See related pages)

1
What is a common field?
A)A field that refers to the primary key field in the related table.
B)A field whose unique value identifies each record in a table.
C)A field property that displays a pattern for entering data.
D)A field linked to a field in another table that shares the same information.
2
What type of relationship is created when you do not select a primary key in either table?
A)One-To-One
B)Indeterminate
C)One-To-Many
D)Many-To-Many
3
Double-clicking the sloping portion of the join line that links two related tables opens the _______________ dialog box.
A)Edit Relationships
B)Indexes
C)Option
D)Show Table
4
A One-To-One relationship can be created when the common field is:
A)The primary key field in the first table but not in the second table.
B)The foreign key field in the first table but not in the second table.
C)The foreign key field in the first table and in the second table.
D)The primary key field in the first table and in the second table.
5
Which of the following options is NOT a valid type of join?
A)Inner
B)Left outer
C)Right inner
D)Right outer
6
A(n) _______________ product is the combination of all possible ordered pairs from two components.
A)Cartesian
B)Cesarean
C)Inclusive
D)Select
7
A ________ join is available only for the query in which it is created.
A)local
B)global
C)outer
D)inner
8
You created a query with two tables that did NOT have a join line. The first table has 12 records and the second has 5. The resulting recordset would have how many records?
A)7
B)17
C)60
D)Not enough information to tell
9
A(n) _______________ helps accelerate the searching and sorting of data in a table.
A)index
B)join
C)query
D)relationship
10
What is an index?
A)A wizard that creates a functional database structure based on the user's selections.
B)A widely recognized naming convention for database objects.
C)A sort order for records, which is identified in the table design.
D)A set of relationship rules that enforce defined database relationships.





To learn more about the book this website supports, please visit its Information Center.
(c)2011 McGraw-Hill Higher Education
Any use is subject to the Terms of Use and Privacy Notice.
McGraw-Hill Higher Education is one of the many fine businesses of The McGraw-Hill Companies.


Hinkle, Microsoft2010 CompleteOnline Learning Center

Home > Access > Lesson 09 Quiz