Question 1

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 logoE) A) and D)
F) None of the above

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 buttonE) None of the above
F) A) and D)

Question 3

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 reportE) B) and D)
F) All of the above

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

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.E) A) and C)
F) B) and C)

Question 6

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 formE) None of the above
F) All of the above

Question 7

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 ColorE) A) and D)
F) A) and C)

Question 8

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

Accepted Answer

A)   : colon
B)   [ left square bracket
C)   ( left parenthesis
D)   '= equal signE) A) and B)
F) All of the above

Question 9

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 ViewsE) All of the above
F) C) and D)

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

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)   CaptionE) C) and D)
F) All of the above

Question 12

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 ArrangeE) All of the above
F) A) and D)

Question 13

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)   italicE) A) and C)
F) B) and C)

Question 14

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 tableE) None of the above
F) All of the above

Question 15

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"E) A) and B)
F) A) and C)

Question 16

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

Accepted Answer

A)   circular
B)   stacked
C)   horizontal
D)   paddedE) None of the above
F) C) and D)

Question 17

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 numberingE) C) and D)
F) B) and C)

Question 18

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 fieldsE) All of the above
F) A) and D)

Question 19

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 boxE) B) and C)
F) A) and C)

Question 20

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.E) A) and D)
F) All of the above

Exam 6: Managing Data With Data Tools

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

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

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified