Question 1

To add a subreport to a report, use the Text Box tool on the REPORT DESIGN TOOLS DESIGN tab.

Accepted Answer

A) True 
 B)False

Question 2

The form in the accompanying figure has no title. When you add a title to a form using the Title button, Access uses the name of the object instead of the caption as the title.

Accepted Answer

A) True 
 B)False

Question 3

If the label for a combo box is Name to Find: and the N is underlined, the user can select the combo box by pressing ____________________+N.

Accepted Answer

The answer of If the label for a combo box...

Question 4

When working on a report in Design view, you can make adjustments to the alignment of the controls in your report by using the Adjustment button on the REPORT DESIGN TOOLS ARRANGE tab.

Accepted Answer

A) True 
 B)False

Question 5

The subreport appears as a separate report in the Navigation Pane.

Accepted Answer

A) True 
 B)False

Question 6

To remove the Group, Sort, and Total pane when working on a report in Design view, tap or click the ____ button on the REPORT DESIGN TOOLS DESIGN tab.

Accepted Answer

A)  Remove Group Pane 
B)  Group & Sort 
C)  Ungroup 
D)  Show/Hide Group Pane

Question 7

To change the appearance of a control so that text in the control displays in a different color, change the ____ property for the control.

Accepted Answer

A)  Font 
B)  Format 
C)  Fore Color 
D)  Text Color

Question 8

To ensure that a combo box will appear within a rectangle, change the ____ property to Transparent.

Accepted Answer

A)  Format 
B)  Special Effects 
C)  Color 
D)  Back Style

Question 9

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

Accepted Answer

The answer of  
 The accompanying figure shows command...

Question 10

The Form Wizard and the Form button are two of several tools that you can use to create a form.

Accepted Answer

A) True 
 B)False

Question 11

To ensure that the data in a combo box is sorted correctly, tap or click the combo box control, tap or click the Property Sheet on the FORM DESIGN TOOLS DESIGN tab, and then tap or click the ____________________ property.

Accepted Answer

The answer of To ensure that the data in a...

Question 12

To insert a chart, use the Chart tool on the FORM DESIGN TOOLS DESIGN tab.

Accepted Answer

A) True 
 B)False

Question 13

Modified Multiple Choice The Record Navigation category includes the ____ actions.

Accepted Answer

A)  Add New Record 
B)  Go To Next Record 
C)  Go To Previous Record 
D)  Close Form

Question 14

To insert a chart, use the Graph Object tool on the FORM DESIGN TOOLS DESIGN tab.

Accepted Answer

A) True 
 B)False

Question 15

To periodically view a report to gauge how it will look containing data, tap or click _____ on the View menu.

Accepted Answer

A)  Print 
B)  Data View 
C)  View 
D)  Print Preview

Question 16

To change the background color of a form, use the Background Color button on the FORM DESIGN TOOLS FORMAT tab.

Accepted Answer

A) True 
 B)False

Question 17

Match between columns
                        Premises: A control that is initially unbound and has an attached label.

Accepted Answer

The Answer of SHIFT and linking and REPORT DESIGN TOOLS is...

Question 18

A(n) ____________________ form is a form that contains more than one page of information.

Accepted Answer

The answer of A(n) ____________________ form is a form that...

Question 19

To modify the query that Access creates for a combo box, tap or click the Row Source property for the combo box and then tap or click the ____ button.

Accepted Answer

A)  Query 
B)  Query Design 
C)  Build 
D)  Expression Builder

Question 20

If a Security Warning appears when you open a database, tap or click the ____ button.

Accepted Answer

A)  Customize 
B)  Enable Content 
C)  Security 
D)  Warning

Exam 8: Advanced Report Techniques

To add a subreport to a report, use the Text Box tool on the REPORT DESIGN TOOLS DESIGN tab.

The form in the accompanying figure has no title. When you add a title to a form using the Title button, Access uses the name of the object instead of the caption as the title.

If the label for a combo box is Name to Find: and the N is underlined, the user can select the combo box by pressing ____________________+N.

When working on a report in Design view, you can make adjustments to the alignment of the controls in your report by using the Adjustment button on the REPORT DESIGN TOOLS ARRANGE tab.

The subreport appears as a separate report in the Navigation Pane.

To remove the Group, Sort, and Total pane when working on a report in Design view, tap or click the ____ button on the REPORT DESIGN TOOLS DESIGN tab.

To change the appearance of a control so that text in the control displays in a different color, change the ____ property for the control.

To ensure that a combo box will appear within a rectangle, change the ____ property to Transparent.

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

The Form Wizard and the Form button are two of several tools that you can use to create a form.

To ensure that the data in a combo box is sorted correctly, tap or click the combo box control, tap or click the Property Sheet on the FORM DESIGN TOOLS DESIGN tab, and then tap or click the ____________________ property.

To insert a chart, use the Chart tool on the FORM DESIGN TOOLS DESIGN tab.

Modified Multiple Choice The Record Navigation category includes the ____ actions.

To insert a chart, use the Graph Object tool on the FORM DESIGN TOOLS DESIGN tab.

To periodically view a report to gauge how it will look containing data, tap or click _____ on the View menu.

To change the background color of a form, use the Background Color button on the FORM DESIGN TOOLS FORMAT tab.

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

A(n) ____________________ form is a form that contains more than one page of information.

To modify the query that Access creates for a combo box, tap or click the Row Source property for the combo box and then tap or click the ____ button.

If a Security Warning appears when you open a database, tap or click the ____ button.