Exam 1: Microsoft Access Basics

When you open a query object, you ____ the query.

Each function can perform only one action.

When you use the Report tool to create a report, the report opens initially in Design view.

A validation message appears when data entered into the field meets the validation rule.

The use of navigation forms in a database is similar to navigating a Web site.

Case Access 8-2 Betty is an assistant at the local pet shelter. She uses an Access database to store information about people who have adopted a pet, dropped off pets, or those who have contributed money and supplies to the shelter. While preparing for a fundraising event for the shelter, she recalls a donor whom she would like to contact but cannot recall the donor's name. However, she is certain it ends in the letters "son". If Betty searches for a person by typing ____ in the last name field of her query, she will narrow down output to donors with a last name ending "son".

Defining a function in a module makes it ____.

Case AC 3-1 Danielle is a Sales Manager and is troubleshooting why profits are down. Danielle wants to see which items are the least profitable. She chooses the Profitability field of her product datasheet and clicks the ____ button.

A(n) ____________________ welcomes the user to the database.

Sum is an example of a function that may be used in a(n) chart .

Selecting the ____ on a main menu navigation form lets you instantly view the objects.

Case AC 9-2 The Phantastic Photo Human Resources department requested an easier, consistent way to enter new employee data. The AAA Database Design consulting firm was hired to provide a new system based on Access database forms. The AAA team provided a prototype of the system, and then handed it back to Phantastic Photo to finish themselves. A consistent place for the logo still needs to be determined. A ____ border appearing next to the logo is preventing it from being resized.

If the preview of the address block in the mail merge is correct, click OK. If it is incorrect, click ____ to make adjustments.

When you record a macro, you can include multiple actions in it.

A placeholder identifies that an input mask is assigned to the field in a table.

The main navigation form is created first .

A query can contain ____ of the fields in the table.

Case AC 5-2 Eddie is working on a report, and when he switched to Print Preview he received an error message saying that his report contained blank pages. Eddie realizes he needs to change the width of the report. When resizing a control in ____ view, Eddie uses the outline of the control and drags it with the pointer to see the actual width of the control.

You create a calculated field using the ____.