Question 1

A control is said to have the ____ when it becomes active; that is, when it becomes able to receive user input through mouse, touch, or keyboard actions.

Accepted Answer

A)  currency 
B)  center 
C)  immediacy 
D)  focus 
A)  currency 
B)  center 
C)  immediacy 
D)  focus D

Question 2

Match between columns
                        Premises: Operator used to concatenate strings.

Accepted Answer

The Answer of DATABASE TOOLS and ampersand (&) and linking is...

Question 3

Match between columns
                        Premises: Also called foreground color.

Accepted Answer

The Answer of concatenation and tab control and rectangle and is...

Question 4

A combo box only allows users to select entries from a list.

Accepted Answer

A) True 
 B)False

Question 5

The SubForm Wizard displays in the accompanying figure. To ensure that the wizard guides you through the process of adding a subform, make sure the ____ button is selected.

Accepted Answer

A)  Wizard 
B)  Wizard & Tools 
C)  Use Control Wizards 
D)  Select Wizard 
A)  Wizard 
B)  Wizard & Tools 
C)  Use Control Wizards 
D)  Select Wizard

Question 6

The SubForm Wizard displays in the accompanying figure. To open a subform in Design view, press and hold or right-click the subform in the Navigation Pane and tap or click ____ on the shortcut menu.

Accepted Answer

A)  Subform View 
B)  Modify Subform 
C)  Design View 
D)  Subform Design 
A)  Subform View 
B)  Modify Subform 
C)  Design View 
D)  Subform Design

Question 7

To change the report margins, tap or click the Margins button on the REPORT DESIGN TOOLS ____ tab.

Accepted Answer

A)  ARRANGE 
B)  DESIGN 
C)  PAGE SETUP 
D)  FORMAT 
A)  ARRANGE 
B)  DESIGN 
C)  PAGE SETUP 
D)  FORMAT

Question 8

Match between columns
                        Premises: Specifies the source of data for the control.

Accepted Answer

The Answer of error indicator and control source and REPORT is...

Question 9

Modified Multiple Choice The categories of actions available for command buttons are ____.

Accepted Answer

A)  Record Navigation 
B)  Macro Operations 
C)  Record Operations 
D)  Form Operations 
A)  Record Navigation 
B)  Macro Operations 
C)  Record Operations 
D)  Form Operations

Question 10

The Expression Builder dialog box displays in the accompanying figure. You also can display the ____ dialog box to type an expression.

Accepted Answer

A)  Builder 
B)  Arithmetic 
C)  Calculation 
D)  Zoom 
A)  Builder 
B)  Arithmetic 
C)  Calculation 
D)  Zoom

Question 11

To calculate the total of a field, such as Amount Paid, use the ____ aggregate function.

Accepted Answer

A)  COUNT 
B)  TOTAL 
C)  ADD 
D)  SUM 
A)  COUNT 
B)  TOTAL 
C)  ADD 
D)  SUM

Question 12

To add a text box to a report, tap or click the ____ tool in the Tools group on the REPORT DESIGN TOOLS DESIGN tab.

Accepted Answer

A)  Add Box 
B)  Text Box 
C)  Unbound 
D)  Add Text 
A)  Add Box 
B)  Text Box 
C)  Unbound 
D)  Add Text

Question 13

To ungroup controls, use the Ungroup button on the Size/Space button menu on the REPORT DESIGN TOOLS ARRANGE tab.

Accepted Answer

A) True 
 B)False

Question 14

Modified Multiple Choice The Header/Footer group on the Design tab includes the _____ buttons.

Accepted Answer

A)  Page Numbers 
B)  Title 
C)  Tools 
D)  Date and Time 
A)  Page Numbers 
B)  Title 
C)  Tools 
D)  Date and Time

Question 15

Match between columns
                        Premises: Appears if a button has the focus.

Accepted Answer

The Answer of focus and concatenation and code and rectangle is...

Question 16

To align command buttons, use the buttons on the FORM DESIGN TOOLS DESIGN tab.

Accepted Answer

A) True 
 B)False

Question 17

To change the report margins, use the Margins button on the REPORT DESIGN TOOLS PAGE SETUP tab.

Accepted Answer

A) True 
 B)False

Question 18

To display a Report Footer section, press and hold or right-click any open area of the report and tap or click ____ on the shortcut menu.

Accepted Answer

A)  Add a Section 
B)  Report Header/Footer 
C)  Add a Footer 
D)  Insert Report Footer 
A)  Add a Section 
B)  Report Header/Footer 
C)  Add a Footer 
D)  Insert Report Footer

Question 19

Match between columns
                        Premises: Indicates a control is able to receive user input.

Accepted Answer

The Answer of rectangle and arguments and macro and font is...

Question 20

If #Name to Find is entered as the label for a combo box, users can select the combo box by pressing ALT+N.

Accepted Answer

A) True 
 B)False

A control is said to have the ____ when it becomes active; that is, when it becomes able to receive user input through mouse, touch, or keyboard actions.

A combo box only allows users to select entries from a list.

The SubForm Wizard displays in the accompanying figure. To ensure that the wizard guides you through the process of adding a subform, make sure the ____ button is selected.

The SubForm Wizard displays in the accompanying figure. To open a subform in Design view, press and hold or right-click the subform in the Navigation Pane and tap or click ____ on the shortcut menu.

To change the report margins, tap or click the Margins button on the REPORT DESIGN TOOLS ____ tab.

Modified Multiple Choice The categories of actions available for command buttons are ____.

The Expression Builder dialog box displays in the accompanying figure. You also can display the ____ dialog box to type an expression.

To calculate the total of a field, such as Amount Paid, use the ____ aggregate function.

To add a text box to a report, tap or click the ____ tool in the Tools group on the REPORT DESIGN TOOLS DESIGN tab.

To ungroup controls, use the Ungroup button on the Size/Space button menu on the REPORT DESIGN TOOLS ARRANGE tab.

Modified Multiple Choice The Header/Footer group on the Design tab includes the _____ buttons.

To align command buttons, use the buttons on the FORM DESIGN TOOLS DESIGN tab.

To change the report margins, use the Margins button on the REPORT DESIGN TOOLS PAGE SETUP tab.

To display a Report Footer section, press and hold or right-click any open area of the report and tap or click ____ on the shortcut menu.

If #Name to Find is entered as the label for a combo box, users can select the combo box by pressing ALT+N.

Office 2013 and Windows 8: Essential Concepts and Skills

Office 365 Essentials

Databases and Database Objects: an Introduction

Querying a Database

Maintaining a Database

Creating Reports and Forms

Multiple-Table Forms

Filters

Exam 8: Advanced Report Techniques

A control is said to have the ____ when it becomes active; that is, when it becomes able to receive user input through mouse, touch, or keyboard actions.

A combo box only allows users to select entries from a list.

The SubForm Wizard displays in the accompanying figure. To ensure that the wizard guides you through the process of adding a subform, make sure the ____ button is selected.

The SubForm Wizard displays in the accompanying figure. To open a subform in Design view, press and hold or right-click the subform in the Navigation Pane and tap or click ____ on the shortcut menu.

To change the report margins, tap or click the Margins button on the REPORT DESIGN TOOLS ____ tab.

Modified Multiple Choice The categories of actions available for command buttons are ____.

The Expression Builder dialog box displays in the accompanying figure. You also can display the ____ dialog box to type an expression.

To calculate the total of a field, such as Amount Paid, use the ____ aggregate function.

To add a text box to a report, tap or click the ____ tool in the Tools group on the REPORT DESIGN TOOLS DESIGN tab.

To ungroup controls, use the Ungroup button on the Size/Space button menu on the REPORT DESIGN TOOLS ARRANGE tab.

Modified Multiple Choice The Header/Footer group on the Design tab includes the _____ buttons.

To align command buttons, use the buttons on the FORM DESIGN TOOLS DESIGN tab.

To change the report margins, use the Margins button on the REPORT DESIGN TOOLS PAGE SETUP tab.

To display a Report Footer section, press and hold or right-click any open area of the report and tap or click ____ on the shortcut menu.

If #Name to Find is entered as the label for a combo box, users can select the combo box by pressing ALT+N.

Office 2013 and Windows 8: Essential Concepts and Skills

Office 365 Essentials

Databases and Database Objects: an Introduction

Querying a Database

Maintaining a Database

Creating Reports and Forms

Multiple-Table Forms

Filters