Microsoft Access Proctored Exam 2 Study Guide

What happens when you apply a theme to a form?

The formatting changes in all forms and reports.

Besides changing the width of a report, what else can you do if a report is too wide for an 8.5-x-11-inch page in Report Layout view?

You can change the orientation of the report to Landscape.

How can you display "Product Description" in a table datasheet for a field named "ProdDesc" without renaming the field?

Enter "Product Description" in the Caption property for the field.

In Form Design view, you can make design changes while displaying the data.

False

In Report Layout view, you use the Format Painter to change the theme of a report.

False

The Alternate Background Color command changes the background color of alternate records in a selected section.

False

The only way to create a Crosstab query is to use the Crosstab Query Wizard.

False

To add a heading to the Detail section of a form, you use a text box control.

False

Use a Size option when you want to specify the exact height and width of two selected controls.

False

When you add a new field to a form, two controls are usually created: a(n) caption and a text box.

False

You switch to Report Layout view to display the entire report as it will appear when printed.

False

Conditional formatting can change the appearance of a report control based on criteria you specify.

TRue

A combo box is a combination of a text box and command button.

True

A parameter query displays a dialog box that prompts you for field criteria.

True

A typical report in landscape orientation is 11 inches wide and 8.5 inches tall.

True

Entering an expression such as =[Price]*[Quantity] in a text box creates a calculated control.

True

If you do not enter a Caption property for a field, Access uses the field name to label the field.

True

The Allow Value List Edits property determines whether users can change the items in a lookup list.

True

To add a subform to a form in Form Design view, you use the Subform/Subreport control.

True

To create a multivalued field in Table Design view, enter Yes in the Allow Multiple Values Lookup property.

True

To perform calculations on field values in Table Datasheet view, you click the Totals button in the Records group on the Home tab.

True

Use a Long Text field when you need to store more than 256 characters in a field, such as for comments, reviews, or notes.

True

Use a Number field to store values that represent money.

True

You use conditional formatting to highlight important data in a report.

True

You use the Find Unmatched Query Wizard to find records in one table that do not have related records in another table.

True

Deleting a text box in Form Layout view _____.

removes the text box from the form

To close a form in Form Design view and keep Access running, you _____.

right-click the form tab, and then click Close on the shortcut menu.

When you click the first value in a column in Report Layout view, what are you actually selecting?

the control containing the value

Create a Top Values query to find the highest values in set of unsorted records.

False

If you want users to enter a positive Currency value in a Price field, enter _____ as the validation rule expression.

"Positive"

Which of the following statements apply to Long Text fields? Select all the options that apply.

- set the Append Only property to let users add but not change data in a Long Text field. -Use Long Text fields when you need to store more than 256 characters in a field. -Fields that store comments, reviews, or notes are good candidates for Long Text fields.

Which of the following are common report enhancements?

-Font colors -HEaders -Footers

In a calculated control, expressions must start with what character?

=

What could you use to display the amount of a 25% discount on a form?

A calculated control

An aggregate function is _____.

A function that calculates a statistic such as a subtotal or average.

To change the background color of a form control in Form Design view, you use the _____ button.

Background Color

A _____ query in a real estate database could list property types as row headings, number of bedrooms as column headings, and the count of each property type as values.

Crosstab

What data type is most appropriate for a field named PaymentAmt?

Currency

A check box control usually displays a "yes" or "no" answer for a field.

False

Alternate colors are a set of coordinated colors to apply to reports and other database objects.

False

To align the edges of multiple controls in Form Design view, you use the Align button on the _____ tab.

Form Design Tools Arrange

In a SaleDate field, you can display dates as 03-Jan-21, for example, by selecting Medium Date as the _____ property.

Format

In Report Design view, you set the sort order of records in a report using the _____.

Group & Sort

What is the advantage of grouping controls on a form?

Grouping related form controls makes forms more understandable for all users, as related controls are easier to identify

Where does a background image appear in a report?

In the background.

Which of the following controls would you use to describe another control on a report?

Label

In _____ view, you can make some design changes to a report while you are displaying the data.

Layout

The _____ property indicates which field serves the link between the main form and subform.

Link Master Fields

You can retain a history of changes to a _____ field.

Long TExt

_____ fields allow you to make more than one choice from a field's lookup list.

Lookup

If you move a text box in Form Design view, you _____.

MOVE LABEL ASSOCIATED WITH TEXT BOX

To change the fonts in all the forms and reports in the database, you can change the _____.

Orientation

In which one of the following views can you edit the text in a label?

Report Layout View

Which of the following buttons on the Arrange tab do you use to increase the horizontal space between form controls?

Size/Space

To create a _____, you add the Total row to the query design grid to specify how to group and perform calculations on the records.

Summary Query

If you select a(n) _____ control on a form in Form view, it means "yes" or "true".

button

Which of the following controls would you use to display a Yes/No field on a form?

check box

To center the text in a selected form control in Form Layout view, you _____.

click the Center button on the Home tab

To set a validation rule for an entire table, you _____.

open the property sheet for the table

To have form users select one of three options, add a(n) _____ to the form.

option group

If you select 25 in the Top Values list, Access displays _____ in the query results.

the top 25 records