Site MapHelpFeedbackLesson 03 - Finding, Filtering, Sorting, and Summarizing Data
Lesson 03 - Finding, Filtering, Sorting, and Summarizing Data
(See related pages)

1
To remove all Sorts in a table you can click the _______________ command.
A)Clear All Sorts
B)Delete All Sorts
C)Eliminate All Sorts
D)Remove All Sorts
2
A(n) _____________ is dynamic mathematical calculation that displays a single value for a specific field.
A)format row
B)criteria row
C)aggregate function
D)format layout
3
The content and application of the Search tool CANNOT be retained when you _______________.
A)format an object
B)resize a column
C)use Datasheet View
D)close an object
4
The Search tool CANNOT be used on which major Access object?
A)Forms
B)Queries
C)Reports
D)Tables
5
In a table, _______________(s) are displayed in the order in which they were entered. Most often this order is not useful.
A)formula
B)format
C)layout
D)record
6
The _______________ is a wild card that represents one or more characters.
A)question mark
B)asterisk
C)exclamation mark
D)dollar sign
7
Which is not an option for Filter on a text field?
A)Begins With
B)Between
C)Contains
D)End With
8
The Search tool is best used when searching for _______________ data.
A)simple
B)multiple
C)unique
D)formatted
9
Which of the following Find and Replace dialog box options finds records in which the beginning of a field matches the Find What entry?
A)Match Case
B)Match: Whole Field
C)Match: Start of Field
D)Match: Any Part of Field
10
Which of the following functions CANNOT be used in the Totals row?
A)Average
B)Count
C)Maximum
D)Round





To learn more about the book this website supports, please visit its Information Center.
(c)2010 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.


PAS Office 2007 BriefOnline Learning Center

Home > Access > Lesson 03 Quiz