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

1
In a query, the lower pane is also known as the _______________ grid.
A)QBE
B)QDA
C)QG
D)QTE
2
Which of the following dialog boxes opens while creating a select query in Design View?
A)New Query
B)Print Query Definition
C)Query Properties
D)Show Table
3
_______________ operators are used to combine two text values into a single text value.
A)Arithmetic
B)Comparison
C)Concatenation
D)Logical
4
Which of the following search criteria is invalid?
A)$45*
B)*cal*
C)D*m??
D)AS150*
5
Using the keyword _______________ will return records in which the field value equals a defined text.
A)Between
B)Is Null
C)Like
D)Not
6
A subdatasheet is added to the dynaset using which of the following?
A)Documenter
B)Expression Builder
C)Show Table
D)Query Properties Sheet
7
Which of the following statements about calculated fields is NOT true?
A)A calculated field does not store data in a recordset.
B)Calculated fields use an expression or formula as its data source.
C)Data contained in a calculated field is created the first time a query is run.
D)A calculated field can be created using the Expression Builder dialog box.
8
Which of the following statements about criteria in a query is NOT true?
A)Criteria can contain wildcard characters.
B)Criteria in a query selects or excludes certain records.
C)Criteria cannot be specified as an expression.
D)Multiple criteria can be specified using AND, OR, and relational operators.
9
When creating a query using a wizard, you must select the _________ source and the associated fields.
A)crosstab
B)filter
C)record
D)sort
10
Which of the following views is used to graphically summarize and analyze data in a recordset?
A)Datasheet
B)Form
C)PivotChart
D)PivotTable





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 06 Quiz