Multiple Choice Quiz


1	An association between two tables in which a record in either table can connect to many records in the other table is called
		A)	A one to many relationship
		B)	A many to one relationship
		C)	An alternative relationship
		D)	A many-to-many relationship


2	A foreign key indicates
		A)	What table should provide input for the record
		B)	How the alternate records connect to the table
		C)	How the table is related
		D)	How to filter a record


3	The purpose of the junction table is to split the many-to-many relationship into
		A)	A one-to-many relationship
		B)	Two one-to-many relationships
		C)	A primary key and a foreign key
		D)	Two separate junctions


4	The Field List box displays
		A)	The fields from a query
		B)	The record source from the properties
		C)	The fields from the properties
		D)	The record source a query


5	A combo box is a form control that is a combination of a
		A)	Label and a list box
		B)	Text box and a list box
		C)	Toggle button and a tab control
		D)	List view and a text box


6	To show a repeating list of items, a subform must be added to the
		A)	Inquiry report
		B)	Make-table query
		C)	Main form
		D)	Query view


7	Action queries are used to
		A)	Change sets of data
		B)	Copy of data
		C)	Delete sets of data
		D)	All of the above


8	Make-table query creates a new table from
		A)	The data in one or more tables
		B)	The records in one or more tables
		C)	Part of the data in one or more tables
		D)	All of the above


9	To see the effect of a combo box you need to test
		A)	The query
		B)	The table
		C)	The form
		D)	All of the above


10	A foreign key is one or more table fields that refer to the primary key field or fields
		A)	In another table
		B)	On the query setup
		C)	On a new record
		D)	In the lookup properties

2002 McGraw-Hill Higher Education
Any use is subject to the Terms of Use and Privacy Policy.
McGraw-Hill Higher Education is one of the many fine businesses of The McGraw-Hill Companies.