Multiple Choice

Click on the correct response for each question below.

1		In order to display the aggregate totals for an entire year of data simultaneously, you must create a new field using the _________ function and a date expression.
			A)	Format
			B)	Order date
			C)	Sort
			D)	Query
2		Functions such as Sum, Avg, and Count are called ____________ functions.
			A)	calculation
			B)	aggregate
			C)	criteria
			D)	negations
3		___________ queries enable you to select the required records and set up instructions.
			A)	To date
			B)	Make-Table
			C)	Update
			D)	Action
4		The simplest type of action query is a ______________ query
			A)	current
			B)	select
			C)	update
			D)	make-table
5		____________ queries use the same fields but different criteria each time the query is run.
			A)	Update
			B)	Make-table
			C)	Parameter
			D)	Select
6		You use ______ in an expression to locate records that match part of the value in a field.
			A)	Example
			B)	Like
			C)	Order
			D)	Query
7		___________ queries can be used to delete records.
			A)	Action
			B)	Management
			C)	Look up
			D)	Record
8		You can include a ________ at the beginning or the end of the input mask to enter the field correctly.
			A)	#
			B)	!
			C)	*
			D)	&&
9		To create other custom input masks, you can use the ____________ characters.
			A)	text
			B)	literal
			C)	abstract
			D)	placeholder
10		The simplest type of action query is a ________________ query.
			A)	parameter
			B)	literal
			C)	make-table
			D)	placeholder