Lesson 24 - Managing and Reporting Database Information

True/False
Indicate whether the statement is true or false.

____	1.	Creating a form adds a new object to the database.

____	2.	When you create a form using the Form Wizard, all the fields from the table or query are automatically included on the form.

____	3.	When you apply a theme to a form, the table style is also updated.

____	4.	Entering data in a form is similar to entering data in a table in Datasheet view.

____	5.	Descending order sorts numerically from the highest to lowest number.

____	6.	After you sort table data, you cannot use the Undo command.

____	7.	You should use the Replace All command only when you are confident about making all the replacements without reviewing them first.

____	8.	When you print a database in Datasheet view, all of the data in the database is printed.

____	9.	When you finish the Report Wizard, the report is displayed in Design view.

____	10.	In Design view, you can change the appearance of a report by applying a different theme and/or colors and fonts.

Multiple Choice
Identify the choice that best completes the statement or answers the question.

____	1.	Which of the following is NOT true about creating a form?
a.	When you create a form using the Form button, it is predesigned.	c.	The Form button is located on the Insert tab.	
b.	You can modify the form using Layout view.	d.	You can modify the form using Design  view.	

____	2.	The above figure shows an example of a(n) ____.
a.	form 	c.	report	
b.	query	d.	datasheet	

____	3.	When you work with a form, you can work in all of the following views, EXCEPT: ____.
a.	Form	c.	Layout	
b.	Datasheet	d.	Design	

____	4.	When you work with a form,  ____ view is used for adding, editing, and viewing data.
a.	Form	c.	Layout	
b.	Datasheet	d.	Design	

____	5.	When you work with a form,  ____ view is used to change the properties and add new fields.
a.	Form	c.	Layout	
b.	Datasheet	d.	Design	

____	6.	When you work with a form,  ____ view enables you to make changes to the font styles and colors.
a.	Form	c.	Layout	
b.	Datasheet	d.	Design	

____	7.	Which of the following is true about entering and editing data in a form?
a.	You can use the Tab and arrow keys to move the insertion point among fields.	c.	When entering text, the Edit Record icon is displayed in the upper-left corner of the form.	
b.	When you enter or edit a record in Form view, Access automatically updates the records in the table.	d.	All of the above are true.	

____	8.	The Sort & Filter group is located on the ____ tab.
a.	Layout	c.	Layout	
b.	Home	d.	Design	

____	9.	The Find button is located on the ____ tab.
a.	Home	c.	Table Tools Layout	
b.	Database Tools	d.	Fields	

____	10.	When the ____ command is turned off, Access ignores capitalization in a search.
a.	Any Part of Field	c.	Search Fields	
b.	Match Case	d.	All Caps	

____	11.	Press ____+F4 to locate the next instance using the search criteria from the previous search without opening the Find and Replace dialog box.
a.	Ctrl	c.	Shift	
b.	Alt	d.	Tab	

____	12.	When you create a(n) ____ you can locate multiple records that match specified criteria.
a.	datasheet	c.	form	
b.	report	d.	query	

____	13.	A(n) ____ provides a way for you to ask a question about the information stored in one or more database tables.
a.	query	c.	form	
b.	report	d.	search	

____	14.	The above figure shows a query in ____ view.
a.	Query	c.	Layout	
b.	Design	d.	Wizard	

____	15.	Which of the following is NOT true about reports?
a.	The Report Wizard prompts you to specify the data to include.	c.	The Report Wizard button is located on the Create tab.	
b.	Landscape orientation formats the report with the long edge of the page at the top.	d.	You can only create a report based on a table.	

____	16.	When selecting fields for the Label Wizard, ____ to include it in the label.
a.	double-click it	c.	right-click it	
b.	click the Select Single Field button	d.	Either A or B.	

Alaina is working on creating a large database for a non-profit organization she works for.

____	17.	Alaina has a lot of data to enter, and wants to make it easy to enter. She creates a(n) ____.
a.	form	c.	query	
b.	report	d.	table	

____	18.	Alaina wants to print selected data from the database so she can distribute it to donors. She creates a  ____.
a.	form	c.	query	
b.	report	d.	table	

Juan is working with a large database and trying to locate information in it.

____	19.	Juan wants to locate all records that contain a certain postal code, one at a time. He uses the ____ command.
a.	Query	c.	Find	
b.	Replace	d.	Search	

____	20.	Juan wants to locate all records that contain a certain postal code, and display them all at once. He creates a ____.
a.	table	c.	form	
b.	report	d.	query	

Lesson 24 - Managing and Reporting Database Information
Answer Section

TRUE/FALSE

	1.	ANS:	T	PTS:	1	REF:	Mod 2-428

	2.	ANS:	T	PTS:	1	REF:	Mod 2-428

	3.	ANS:	F	PTS:	1	REF:	Mod 2-429

	4.	ANS:	T	PTS:	1	REF:	Mod 2-432

	5.	ANS:	T	PTS:	1	REF:	Mod 2-433

	6.	ANS:	F	PTS:	1	REF:	Mod 2-434

	7.	ANS:	T	PTS:	1	REF:	Mod 2-437

	8.	ANS:	T	PTS:	1	REF:	Mod 2-442

	9.	ANS:	F	PTS:	1	REF:	Mod 2-444

	10.	ANS:	T	PTS:	1	REF:	Mod 2-445

MULTIPLE CHOICE

	1.	ANS:	C	PTS:	1	REF:	Mod 2-428

	2.	ANS:	A	PTS:	1	REF:	Mod 2-429

	3.	ANS:	B	PTS:	1	REF:	Mod 2-430

	4.	ANS:	A	PTS:	1	REF:	Mod 2-430

	5.	ANS:	D	PTS:	1	REF:	Mod 2-430

	6.	ANS:	C	PTS:	1	REF:	Mod 2-430

	7.	ANS:	D	PTS:	1	REF:	Mod 2-432, Mod 2-433

	8.	ANS:	B	PTS:	1	REF:	Mod 2-434

	9.	ANS:	A	PTS:	1	REF:	Mod 2-435

	10.	ANS:	B	PTS:	1	REF:	Mod 2-436

	11.	ANS:	C	PTS:	1	REF:	Mod 2-436

	12.	ANS:	D	PTS:	1	REF:	Mod 2-438

	13.	ANS:	A	PTS:	1	REF:	Mod 2-438

	14.	ANS:	B	PTS:	1	REF:	Mod 2-441

	15.	ANS:	D	PTS:	1	REF:	Mod 2-442

	16.	ANS:	D	PTS:	1	REF:	Mod 2-447

	17.	ANS:	A	PTS:	1	REF:	Mod 2-428	TOP:	Critical Thinking

	18.	ANS:	B	PTS:	1	REF:	Mod 2-442	TOP:	Critical Thinking

	19.	ANS:	C	PTS:	1	REF:	Mod 2-435	TOP:	Critical Thinking

	20.	ANS:	D	PTS:	1	REF:	Mod 2-438	TOP:	Critical Thinking