Multiple Choice Quiz

Click on the correct response for each question below.

1		In the table area of the query design window, which style of line shows a right outer join between tables?
			A)	a line with no arrows
			B)	a line with crows feet on the end
			C)	a line with an arrow on the left end pointing to the parent table
			D)	a line with an arrow on the right end pointing to the child table
2		A top values query allows you to select records based on:
			A)	an absolute number of records
			B)	a percentage of the total number of records
			C)	both a and b
			D)	neither a nor b
3		To locate records with missing or Null values, enter _____ into the criteria row for the field you want to search.
			A)	=Null
			B)	“Null”
			C)	Is Null
			D)	= “Is Null”
4		Which of the following is not a query property:
			A)	Unique values
			B)	Caption
			C)	Top values
			D)	Order by
5		The “Find Unmatched Query Wizard” creates a query with what type of join?
			A)	inner join
			B)	table join
			C)	field join
			D)	outer join