Multiple Choice

Click on the correct response for each question below.

1		When creating a report with a sub-report, you link the main report to the sub-report by using a _______________.
			A)	field that the two tables have in common
			B)	index that two tables have in common
			C)	relationship that two tables have in common
			D)	query that two tables have in common
2		A cross-tab query is used to __________________.
			A)	calculate an average, sum, count or total for data that is grouped by one kind of information.
			B)	calculate an average, sum, count or total for data that is grouped by two kinds of information.
			C)	calculate an average, sum, count or total for data that is grouped by three kinds of information.
			D)	None of the above
3		You would use _________________ to create dynamic Web pages that are directly bound to data in the database.
			A)	Report Snapshot
			B)	Crosstab Queries
			C)	Page Wizard
			D)	Dynamic Web Wizard
4		_________________ are used for grouping records with numeric values such as monthly or quarterly sale totals.
			A)	Report Snapshot
			B)	Page Wizard
			C)	Total Queries
			D)	Crosstab Queries
5		If you want to delete a record in the primary table that has related records in another table ______________________ will allow you to delete the dependent records.
			A)	record update
			B)	record deletion
			C)	cascading update
			D)	cascading deletion
6		DAP are Web pages that are directly bound to information in your database. What does DAP stand for?
			A)	Data Accessible Pages
			B)	Data Access Pages
			C)	Dynamic Access Pages
			D)	Dynamic Accessible Pages
7		Although DAP display in the _______________, they are not saved within the database.
			A)	objects list
			B)	design view
			C)	external file
			D)	page wizard
8		In a table you can add a hyperlink data type field in __________________.
			A)	Datasheet View
			B)	Form Design
			C)	Design View
			D)	Report View
9		In a DAP you can use the Image Hyperlink took located in the ____________ to select a target for the hyperlink.
			A)	toolbox
			B)	toolbar
			C)	Insert Hyperlink
			D)	Image Dialog box
10		When you create a report using the default blank template, you can add report headers and footers as a pair by clicking the Report Header/Footer command on the ______ menu.
			A)	report
			B)	header/footer
			C)	view
			D)	grouping