Which of the following is a technique for increasing the speed of Access queries?

	a.	Include fields considered optional for the query.
	b.	Delete field lists that are not needed for the query.
	c.	Type field names directly into the query design grid.
	d.	Use Query Design View to join tables.

How are aggregate functions different from other types of functions?

	a.	Aggregate functions work only with numeric data.
	b.	Aggregate functions do not work with date values.
	c.	Aggregate functions make calculations on groups of records.
	d.	Aggregate functions return yes/no or true/false values.

If you want to select records containing the text Consulting in the ProjectType field, how does Access save the criterion in the query grid of Query Design View?

	a.	#Consulting#
	b.	(Consulting)
	c.	[Consulting]
	d.	"Consulting"

When you can determine the value of a field using information from existing fields in a record in a query, you should create a(n) _____.

	a.	grouping field
	b.	computed field
	c.	compound condition
	d.	argument

What is the difference between the records that are selected when AND criteria versus OR criteria in a query?