iCheck™ Series Microsoft® Office 2007 Real World Applications

Lesson 2: Structure a Database

Self Checks

Self Checks provide you with multiple choice questions you can use to review the main ideas of the lesson.

1
A database ____ comes with predefined tables, fields, and so forth to make it easier for you keep track of a specific type of information.
A)query
B)filter
C)relationship
D)template
2
Which field is the primary key?
<a onClick="window.open('/olcweb/cgi/pluginpop.cgi?it=jpg::::/sites/dl/free/0078786051/574826/U3L2Q2.jpg','popWin', 'width=NaN,height=NaN,resizable,scrollbars');" href="#"><img valign="absmiddle" height="16" width="16" border="0" src="/olcweb/styles/shared/linkicons/image.gif"> (167.0K)</a>
A)A
B)B
C)C
D)D
3
If you want to see the data types for a table's fields, go to ____.
A)Table View
B)Database View
C)Datasheet View
D)Design View
4
Which of the following could you use to determine the average of the values in a column of numbers?
A)Home>Records>Totals
B)Home>Views>Design View
C)Home>Views>Datasheet View
D)Home>Sort & Filter>Filter
5
If you want to make certain that a specific field can never be empty, set its ____ property to "Yes."
A)Field Size
B)Format
C)Input Mask
D)Required
6
The ____ will eliminate any redundant listings.
A)Navigation pane
B)Lookup field
C)Table Analyzer Wizard
D)Relationships window
7
The input mask for Phone Number specifies that ____.
<a onClick="window.open('/olcweb/cgi/pluginpop.cgi?it=jpg::::/sites/dl/free/0078786051/574826/U3L2Q7.jpg','popWin', 'width=NaN,height=NaN,resizable,scrollbars');" href="#"><img valign="absmiddle" height="16" width="16" border="0" src="/olcweb/styles/shared/linkicons/image.gif"> (141.0K)</a>
A)the user must enter only numerals
B)the user must enter only letters
C)the user can enter either numerals or letters
D)the phone number can have between 4 and 10 characters
8
Which of the following is true about the relationship in this database?
<a onClick="window.open('/olcweb/cgi/pluginpop.cgi?it=jpg::::/sites/dl/free/0078786051/574826/U3L2Q8.jpg','popWin', 'width=NaN,height=NaN,resizable,scrollbars');" href="#"><img valign="absmiddle" height="16" width="16" border="0" src="/olcweb/styles/shared/linkicons/image.gif"> (89.0K)</a>
A)For every record in the Customer table, there is exactly one record in the Order table.
B)For every record in the Order table, there can be many records in the Customer table.
C)For every record in the Customer table, there can be many records in the Order table.
D)There is no relationship between the Customer table and the order table.
9
A(n) ____ field contains all possible data choices for that field.
A)attachment
B)Lookup
C)Primary key
D)crosstab
10
A(n) ____ query provides summary data for data that is grouped by two fields.
A)duplicate
B)unmatched
C)filter
D)crosstab
Glencoe Online Learning CenterComputer Education HomeProduct InfoSite MapContact Us

The McGraw-Hill CompaniesGlencoe

Please read our Terms of Use and Privacy Notice before you explore our Web site. To report a technical problem with this Web site, please contact the Web Producer.