Site MapHelpFeedbackLesson 06 - Designing Queries
Lesson 06 - Designing Queries
(See related pages)

1
Which of the following views is used to graphically summarize and analyze data in a recordset?
A)Datasheet
B)Form
C)PivotChart
D)PivotTable
2
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.
3
Which of the following statements does NOT hold true for the Top Values property?
A)The Top Values property displays only the highest values from the query.
B)The Top Values property requires the fields to have a defined sort order.
C)The Top Values property finds a specified number of records.
D)The Top Values property finds a specified percentage of records.
4
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.
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
What is the process of eliminating redundant fields by separating data into tables called?
A)Renormalizations
B)Filtering
C)Normalization
D)Sorting
7
Which of the following statements about PivotChart View is NOT true?
A)It is used to graphically summarize and analyze data in a table, query, or form.
B)It can be used to view different levels of detail or to specify custom layout.
C)It displays field values that can be switched for different views of data.
D)It displays the same information as a crosstab query, except for the counts and sums of numeric fields.
8
Which of the following search criteria is invalid?
A)$45*
B)*cal*
C)D*m??
D)AS150*
9
In a query, using the keyword _______________ will return records in which the field value is between two numbers.
A)Between
B)Is Null
C)Like
D)Not
10
Which of the following database objects extracts information from one or more tables or queries?
A)Forms
B)Queries
C)Reports
D)Tables





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