Lesson 10 - Designing Advanced Queries


1	In a query, what symbol is used to surround a parameter's user prompt?
	A)	[ ]
	B)	{ }
	C)	" "
	D)	( )



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



3	Which function extracts the name of the month from a date/time value?
	A)	Month
	B)	MonthName
	C)	MonthLabel
	D)	MonthValue



4	Which of the following queries prompts users for input data by displaying dialog boxes?
	A)	Append
	B)	Delete
	C)	Parameter
	D)	Update



5	A(n) _______________ query makes changes to or moves records in a dynaset, in a single operation.
	A)	select
	B)	summary
	C)	parameter
	D)	action



6	Which of the following queries modifies fields not records?
	A)	Append
	B)	Delete
	C)	Make-Table
	D)	Update



7	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



8	Which of the following functions is used to all the values in a numeric field?
	A)	Num
	B)	Count
	C)	Sum
	D)	Total



9	Which of the following queries can create a table?
	A)	Append
	B)	Delete
	C)	Make-Table
	D)	Update



10	In a query, which row do you need to place wildcards to affect a parameter?
	A)	Arguments
	B)	Criteria
	C)	Fields
	D)	Tables

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