Lesson 10 Quiz


1	A(n) _______________ query locates data from one or more tables.
	A)	select
	B)	summary
	C)	parameter
	D)	action



2	Which of the following functions CANNOT be performed by queries?
	A)	Combining data.
	B)	Calculating summaries.
	C)	Creating log files.
	D)	Creating new tables.



3	A summary query can be created by adding which row to the design grid of a select query?
	A)	Arguments
	B)	Group
	C)	Summary
	D)	Total



4	Which function extracts the numeric value of each month from a date/ time value?
	A)	Month
	B)	MonthName
	C)	MonthNum
	D)	MonthValue



5	Which of the following is the result of =MonthName([Date]), where [Date] = February 5, 2008?
	A)	Feb
	B)	February
	C)	2
	D)	02



6	Changes to parameters in a query are made through the Query ____________ dialog box.
	A)	Group By
	B)	Update To
	C)	Criteria
	D)	Parameters



7	In a query, when using wildcards, you must include what keyword?
	A)	Like
	B)	Equal
	C)	Between
	D)	Where



8	Which of the following is NOT a feature of wildcard characters?
	A)	They are used with text data type.
	B)	Used in the Table row to include more than one table.
	C)	They can be used in a parameter query.
	D)	They are used when users know a part of the criteria in a query.



9	Icons for _______________ queries display an exclamation point.
	A)	select
	B)	summary
	C)	parameter
	D)	action



10	In the Navigation Pane, every action query has what symbol in each of their icons?
	A)	!
	B)	#
	C)	$
	D)	*

Notes		(What is this?)

Add a note
1.	(optional) Enter a note here:
2.	(optional) Select some text on the page (or do this before you open the "Notes" drawer).
3.	Highlighter Color:
4.

Home > Access > Lesson 10 Quiz