Question 1

You can use the arrow keys to move a selected control in Report Design view.

Accepted Answer

A) True 
 B)False

Question 2

Which of the following commands can you use to add a picture to a form? Select all the options that apply.

Accepted Answer

A)  Insert Image 
B)  Logo 
C)  Online Pictures 
D)  Background Image

Question 3

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 4

Which of the following controls would you add to a form to print the current record?

Accepted Answer

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

Question 5

You can select one or more option buttons at the same time within an option group.

Accepted Answer

A) True 
 B)False

Question 6

To use the Command Button Wizard,the _____ button must be toggled on.

Accepted Answer

A)  Create Command Button 
B)  Design View 
C)  Use Control Wizards 
D)  Set Control Defaults

Question 7

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

Accepted Answer

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

Question 8

When you add a field to a form in Form Layout view,Access creates a text box but not a label.

Accepted Answer

A) True 
 B)False

Question 9

The Display Control property of a _____ field is set to Combo Box by default.

Accepted Answer

A)  Short Text 
B)  primary key 
C)  lookup 
D)  Date/Time

Question 10

To set a command button to be a hyperlink in Form Design view,you change the button's _____ property.

Accepted Answer

A)  On Click 
B)  Web Link 
C)  Hyperlink Address 
D)  Enabled

Question 11

A command button in a report typically appears in the _____ section.

Accepted Answer

A)  Detail 
B)  Report Header 
C)  Group Header 
D)  Totals

Question 12

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 13

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

Accepted Answer

A) True 
 B)False

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

How can you select more than one control at a time in Form Design view? Select all the options that apply.

Accepted Answer

A)  Drag a selection box around the controls. 
B)  Click the ruler above or to the left of the controls. 
C)  Click a control then SHIFT+click other controls. 
D)  Right-drag the controls.

Question 16

The report's _____ property identifies the table or query that provides the fields and records for a report.

Accepted Answer

A)  Group and Sort 
B)  Conditional Formatting 
C)  Format 
D)  Record Source

Question 17

To determine whether a control appears or is hidden on a form,set the _____ property for the control.

Accepted Answer

A)  Value 
B)  Caption 
C)  Visible 
D)  Format

Question 18

When you select a control in Form Design view and then press an arrow key,you _____ the control.

Accepted Answer

A)  resize 
B)  anchor 
C)  move 
D)  lock

Question 19

Which control works best to display three choices-1,2,or 3-for a Rating field?

Accepted Answer

A)  toggle button 
B)  text box 
C)  tab control 
D)  option group

Question 20

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

Accepted Answer

A) True 
 B)False

Exam 6: Managing Data With Data Tools

You can use the arrow keys to move a selected control in Report Design view.

Which of the following commands can you use to add a picture to a form? Select all the options that apply.

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

Which of the following controls would you add to a form to print the current record?

You can select one or more option buttons at the same time within an option group.

To use the Command Button Wizard,the _____ button must be toggled on.

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

When you add a field to a form in Form Layout view,Access creates a text box but not a label.

The Display Control property of a _____ field is set to Combo Box by default.

To set a command button to be a hyperlink in Form Design view,you change the button's _____ property.

A command button in a report typically appears in the _____ section.

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

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

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

How can you select more than one control at a time in Form Design view? Select all the options that apply.

The report's _____ property identifies the table or query that provides the fields and records for a report.

To determine whether a control appears or is hidden on a form,set the _____ property for the control.

When you select a control in Form Design view and then press an arrow key,you _____ the control.

Which control works best to display three choices-1,2,or 3-for a Rating field?

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