Exam 24: Managing and Reporting Database Information

An Access template with a globe icon will create traditional desktop databases.

Juan is working with a large database and trying to locate information in it. Juan wants to locate all records that contain a certain postal code, one at a time. He uses the ____ command.

When you create a ____, you can locate multiple records that match specified criteria.

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

The accompanying figure shows an example of a ____.

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

A(n) ____________________ provides a convenient way to enter and edit data.

Press ____+F4 to locate the next instance using the search criteria from the previous search without opening the Find and Replace dialog box.

Which of the following is NOT true about reports?

You must be in _____ mode to encrypt a database file.

Alaina is creating a large database for the non-profit organization where she works. Alaina wants to print selected data from the database so she can distribute it to donors. She creates a ____.

Descending order sorts numerically from the highest to lowest number.

The Form ____________________ prompts you to select the fields and the form layout for the new form.

The Find option can be activated using the _____ shortcut keys.

When you work with a form, ____ view is used for adding, editing, and viewing data.

The Sort & Filter group is located on the ____ tab.

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

Explain the purpose of a form and what it is used for. Define a form, a report, and a query, and explain how each is used. Give an example of a database, and then describe a form, a query, and a report that you might create in this database.

When you work with a form, you can work in all of the following views EXCEPT: ____.

Creating a form adds a new object to the database.