Question 1

Describe three ways that you can create a calculated field in a query.

Accepted Answer

The answer of Describe three ways that you can create...

Question 2

Match between columns
                        Premises: Series of actions that Access performs when a particular event occurs.

Accepted Answer

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

Question 3

To place a rectangle around a combo box, use the ____ tool on the FORM DESIGN TOOLS DESIGN tab in the Controls group.

Accepted Answer

A)  Line 
B)  Rectangle 
C)  Bound Object Frame 
D)  Unbound Object Frame

Question 4

The employee has decided to select the pre-defined option, Narrow, to reduce the size of the margins for the report. How does she change to the Narrow margin option?

Accepted Answer

The answer of The employee has decided to select the...

Question 5

You can align controls in the Report Design window using the Align button on the REPORT DESIGN TOOLS ____ tab.

Accepted Answer

A)  ALIGN 
B)  CONTROLS 
C)  PAGE LAYOUT 
D)  ARRANGE

Question 6

To import a text file, tap or click the ____ button on the EXTERNAL DATA tab.

Accepted Answer

A)  Text File 
B)  ASCII Text 
C)  ASCII File 
D)  More

Question 7

In the accompanying figure, the Seminar Offerings table was added to the query by selecting the table and tapping or clicking the Add button in the ____ dialog box.

Accepted Answer

A)  Add Table 
B)  Field List 
C)  Show Table 
D)  Select Table

Question 8

To change the appearance of a control so that it appears sunken, change the ____ property for the control.

Accepted Answer

A)  Format 
B)  Style 
C)  Special Effect 
D)  Font

Question 9

To display a field list, tap or click the ____ button on the FORM DESIGN TOOLS DESIGN tab in the Tools group.

Accepted Answer

A)  Field List 
B)  Show Fields 
C)  Show/Hide Field List 
D)  Add Existing Fields

Question 10

The Book Rep Master List shown in the accompanying figure includes an unbound control. The process of converting an unbound control to a bound control is called ____________________.

Accepted Answer

The answer of  
 The Book Rep Master List...

Question 11

To find the largest value, use the LARGE aggregate function.

Accepted Answer

A) True 
 B)False

Question 12

To modify a macro associated with a command button, press and hold or right-click the command button and tap or click ____ on the shortcut menu.

Accepted Answer

A)  Build Event 
B)  Macro Window 
C)  Change To 
D)  Macro Design

Question 13

The Book Rep Master List shown in the accompanying figure includes an unbound control. You could enter an expression in this control to combine two or more text data items. The process of combining these items is called ____________________.

Accepted Answer

The answer of  
 The Book Rep Master List...

Question 14

The form in the accompanying figure includes command buttons and a combo box. When you create an Add Record command button using the Command Button Wizard, the button automatically places an insertion point in the first field on the form.

Accepted Answer

A) True 
 B)False

Question 15

When the Control Wizard is used to create a combo box, the values in the combo box are sorted in alphabetical order automatically.

Accepted Answer

A) True 
 B)False

Question 16

The accompanying figure shows command buttons on a form. The action for the Next Record button is Go To Next Record, which is in the ____________________ category.

Accepted Answer

The answer of  
 The accompanying figure shows command...

Question 17

The contents of the ____ section are printed after the records in a particular group.

Accepted Answer

A)  After Group 
B)  After Section 
C)  Subtotal Footer 
D)  Group Footer

Question 18

To change the On Current property for a form, tap or click the form selector for the form, tap or click the ____ button on the FORM DESIGN TOOLS DESIGN tab in the Tools group, and then tap or click the On Current property.

Accepted Answer

A)  Form Properties 
B)  Event Properties 
C)  Property Sheet 
D)  VBA Code

Question 19

To add a concatenated field to a form, use the ____________________ tool in the Controls group on the FORM DESIGN TOOLS DESIGN tab.

Accepted Answer

The answer of To add a concatenated field to a...

Question 20

The form in the accompanying figure includes command buttons and a combo box. To select an entry from a combo box, press the TAB key.

Accepted Answer

A) True 
 B)False

Exam 8: Advanced Report Techniques

Describe three ways that you can create a calculated field in a query.

Identify the letter of the choice that best matches the phrase or definition.

To place a rectangle around a combo box, use the ____ tool on the FORM DESIGN TOOLS DESIGN tab in the Controls group.

The employee has decided to select the pre-defined option, Narrow, to reduce the size of the margins for the report. How does she change to the Narrow margin option?

You can align controls in the Report Design window using the Align button on the REPORT DESIGN TOOLS ____ tab.

To import a text file, tap or click the ____ button on the EXTERNAL DATA tab.

In the accompanying figure, the Seminar Offerings table was added to the query by selecting the table and tapping or clicking the Add button in the ____ dialog box.

To change the appearance of a control so that it appears sunken, change the ____ property for the control.

To display a field list, tap or click the ____ button on the FORM DESIGN TOOLS DESIGN tab in the Tools group.

The Book Rep Master List shown in the accompanying figure includes an unbound control. The process of converting an unbound control to a bound control is called ____________________.

To find the largest value, use the LARGE aggregate function.

To modify a macro associated with a command button, press and hold or right-click the command button and tap or click ____ on the shortcut menu.

The Book Rep Master List shown in the accompanying figure includes an unbound control. You could enter an expression in this control to combine two or more text data items. The process of combining these items is called ____________________.

The form in the accompanying figure includes command buttons and a combo box. When you create an Add Record command button using the Command Button Wizard, the button automatically places an insertion point in the first field on the form.

When the Control Wizard is used to create a combo box, the values in the combo box are sorted in alphabetical order automatically.

The accompanying figure shows command buttons on a form. The action for the Next Record button is Go To Next Record, which is in the ____________________ category.

The contents of the ____ section are printed after the records in a particular group.

To change the On Current property for a form, tap or click the form selector for the form, tap or click the ____ button on the FORM DESIGN TOOLS DESIGN tab in the Tools group, and then tap or click the On Current property.

To add a concatenated field to a form, use the ____________________ tool in the Controls group on the FORM DESIGN TOOLS DESIGN tab.

The form in the accompanying figure includes command buttons and a combo box. To select an entry from a combo box, press the TAB key.