Site MapHelpFeedbackMultiple Choice Quiz
Multiple Choice Quiz
(See related pages)

1
Which of the following finds data in your database by allowing you to ask a question?
A)calculated field
B)compound criteria
C)query
D)parameter
E)filter
2
To see the results of a query, you need to click:
A)Seek.
B)Go.
C)View.
D)Run.
E)Solve.
3
In Access, the most common way to create queries is with:
A)Datasheet view.
B)Query Design.
C)Field Layout.
D)Query Setup.
E)Form Design.
4
Which of the following tabs do you use to create a query?
A)File
B)Home
C)Create
D)Database Tools
E)Layout
5
In Access, the most common type of query is a:
A)Select query.
B)Custom query.
C)Basic query.
D)Object query.
E)Form query.
6
When you want to add fields to a query that you have created, put the fields into the:
A)Form Wizard.
B)Design grid.
C)Field Guide.
D)Query window.
E)Table.
7
When used in an expression, the asterisk (*) represents any string of characters and is also called:
A)A generic symbol.
B)A placeholder.
C)A wildcard character.
D)A star 8.
E)A universal locator.
8
Which of the following symbols must you use when defining a parameter query?
A)( )
B)[ ]
C){ }
D)/ /
E)" "
9
Which of these should be used to write criterion for a query?
A)Criterion composer
B)Like comparison
C)Wildcard symbols
D)Expression
E)Formula
10
This operator can help you find records containing data that is similar to the criterion value:
A)Like comparison
B)Parameter value
C)Dialog box
D)Custom Filter
E)Expression
11
When entering a criterion expression, which of the following tools helps suggest a list of possible values?
A)Query Design Wizard
B)Parameter query
C)Aggregate function
D)Expression match
E)IntelliSense
12
Which of the following requires you to enter the specific criteria value when you run the query?
A)Simple query
B)Summary query
C)Parameter query
D)Expression Builder
E)Exact query
13
The formula expression for a calculated field is in which of the following formats:
A)FieldName:Expression
B)FieldName:Constant
C)FieldName:Generic
D)FieldName:Default
E)FieldName:Calculation
14
Access provides a variety predefined formulas that perform specific tasks and are called:
A)Database formulas.
B)Functions.
C)Expressions.
D)Filters.
E)Criteria.
15
Set the following property in order to have Access evaluate the fields in the query and avoid including duplicated values:
A)Parameter
B)Filter
C)Unique Values
D)Match=Null
E)Exact Return





To learn more about the book this website supports, please visit its Information Center.
Copyright (c)2014 McGraw-Hill Education .
Any use is subject to the Terms of Use and Privacy Notice | Report Piracy


Nordell, 1eOnline Learning Center

Home > Access > Chapter 3 > Ch 3: Multiple Choice Quiz