iCheck™ Series Microsoft® Office 2010

Lesson 4: Maximize Database Functions

Self Checks

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

1
When you ____ a table, you check it for correct structure and for any duplication of information.
A)normalize
B)export
C)link
D)join
2
If you want to get data from an Excel worksheet and insert it into a database table, choose ____.
A)Database Tools>Move Data>Access Database
B)Database Tools>Export>Excel
C)External Data>Export>Excel
D)External Data>Import & Link>Excel
3
Identify the button that will execute a query.

<a onClick="window.open('/olcweb/cgi/pluginpop.cgi?it=jpg::::/sites/dl/free/007661395x/903632/U3L4Q3.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"> (130.0K)</a>

A)A
B)B
C)C
D)D
4
____ tell Access the steps to be followed when importing data from an external source.
A)Parameters
B)Import specifications
C)Query criteria
D)Aliases
5
A query can be set up to prompt you for a value, or ____, that will be used as criteria when the query is run.
A)specification
B)aggregate
C)parameter
D)calculated field
6
This query contains a(n) ____.

<a onClick="window.open('/olcweb/cgi/pluginpop.cgi?it=jpg::::/sites/dl/free/007661395x/903632/U3L4Q6.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"> (108.0K)</a>

A)right-outer join
B)left-outer join
C)inner join
D)alias
7
To remove a filter, choose ____.
A)Home>Sort & Filter>Toggle Filter
B)Home>Sort & Filter>Filter
C)Home>Sort & Filter>Selection
D)Home>Sort & Filter>Advanced
8
Identify the calculated field.

<a onClick="window.open('/olcweb/cgi/pluginpop.cgi?it=jpg::::/sites/dl/free/007661395x/903632/U3L4Q8.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)A
B)B
C)C
D)D
9
You can give a field an alternative name, also known as a(n) ____.
A)parameter
B)alias
C)filter
D)link
10
Which of the following is NOT an example of a database object?
A)table
B)form
C)report
D)filter
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.