Click on the correct response for each question below.

1		This type of field would allow the user to store a phone number by entering any character from the keyboard, but would not force the user to enter the area code.
			A)	DataType
			B)	Text
			C)	Value
			D)	Numeric
2		Each of the following is a conditional operator that allows a specific group of match values to be stated for a table field except
			A)	Like
			B)	Lookup
			C)	Between
			D)	In
3		Wildcards are designed to be used with this type of field.
			A)	Number
			B)	Text
			C)	Relational
			D)	Fixed
4		When using logical operators, conditions can be joined with
			A)	If
			B)	If Then
			C)	Or
			D)	Not
5		This is a logical operator that is used to join two or more conditions when any of the conditions can be true to retrieve the record.
			A)	Or
			B)	If
			C)	If Then
			D)	And
6		This logical operator negates a conditions to select nonmatching values.
			A)	And
			B)	Not
			C)	Or
			D)	If
7		This type of query performs calculations like sum, average, or count, and then groups them down the left side of the datasheet or across the top.
			A)	Select
			B)	Field
			C)	Value
			D)	Crosstab
8		When a necessary piece of data has not been stored, this must be added to an existing table.
			A)	Column
			B)	Row
			C)	Record
			D)	Field
9		To insert a row in the design grid, select the row for the new field and then use this menu command.
			A)	Insert/Rows
			B)	Format/Rows
			C)	Tools/Rows
			D)	View/Rows
10		Which of the following is not a correct statement?
			A)	You can remove any existing table relationship based on the lookup fields.
			B)	When creating a lookup field, open the child table and change the Data Type for the foreign key field to Lookup Wizard.
			C)	A lookup field can ease data entry.
			D)	The most likely relationship is a one-to-many, where the parent table will look up the key value of the child table.