Question 1

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

Accepted Answer

A)  : colon 
B)  [ left square bracket 
C)  ( left parenthesis 
D)  '= equal sign

Question 2

A(n) _____ is a common control to place within an option group.

Accepted Answer

A)  option button 
B)  text box 
C)  command button 
D)  toggle button

Question 3

Which control allows you to type an entry or choose an entry from a list?

Accepted Answer

A)  combo box 
B)  list box 
C)  label 
D)  text box

Question 4

One way to group objects in the Navigation Pane is by object type.

Accepted Answer

A) True 
 B)False

Question 5

The Database Documenter provides step-by-step help for using an Access database.

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

A)  a Total row 
B)  a command button 
C)  a calculated control 
D)  a logo

Question 7

Which of the following options can you set for a text box in a control layout? Select all the options that apply.

Accepted Answer

A)  Margins 
B)  Padding 
C)  Anchoring 
D)  Page numbering

Question 8

Which of the following changes can you make to a form in Form Layout view? Select all the options that apply.

Accepted Answer

A)  Edit the text in a label. 
B)  Move controls. 
C)  Change the form type. 
D)  Resize controls.

Question 9

Which of the following steps removes the Page Header and Page Footer sections from a report in Report Design view?

Accepted Answer

A)  Click the Page Header section bar, and then press DELETE. 
B)  Drag the Page Header or Page Footer section bar to the Navigation Pane. 
C)  Click the Page Header or Page Footer section bar, and then click Remove on the Design tab. 
D)  Right-click the Page Footer section, and then click Page Header/Footer on the shortcut menu.

Question 10

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

Accepted Answer

A)  the control containing the value 
B)  the label displaying the column heading 
C)  the record containing the value 
D)  the column for the underlying table

Question 11

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

Accepted Answer

A)  Home 
B)  Form Design Tools Design 
C)  Form Design Tools Format 
D)  Form Design Tools Arrange

Question 12

Which of the following are default grouping options for the Navigation Pane? Select all the options that apply.

Accepted Answer

A)  Theme 
B)  Created Date 
C)  Object Type 
D)  Tables and Related Views

Question 13

In a multicolumn report, you can set the column layout as "Across, then Down" or as _____.

Accepted Answer

A)  "Across, then Up" 
B)  "Down, then Up" 
C)  "Down, then Across" 
D)  "Left, then Right"

Question 14

Which of the following formatting changes can you make to report control text in Report Layout view? Select all the options that apply.

Accepted Answer

A)  text outline 
B)  bold 
C)  font color 
D)  italic

Question 15

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

Accepted Answer

A)  Shape Outline 
B)  Shape Fill 
C)  Row Color 
D)  Form Color

Question 16

Which of the following layouts can you use to arrange form controls?

Accepted Answer

A)  circular 
B)  stacked 
C)  horizontal 
D)  padded

Question 17

A report with _____ is a good candidate for a multicolumn report.

Accepted Answer

A)  a header and a footer 
B)  many fields 
C)  wide margins 
D)  only a few fields

Question 18

Which field property do you use to change a lookup field to a regular field?

Accepted Answer

A)  Display Control 
B)  Column Heads 
C)  Allow Multiple Values 
D)  Caption

Question 19

A _____ allows you to work with records related to the record in the main form.

Accepted Answer

A)  subform 
B)  hyperlink 
C)  background form 
D)  related form

Question 20

Clicking in the vertical ruler in Report Design view selects _____.

Accepted Answer

A)  all the controls in the report 
B)  the control on the far left 
C)  all the controls that intersect with the selection line 
D)  the entire report

Exam 6: Managing Data With Data Tools