Question 1

The SubReport Wizard displays in the acsampanying figure. To add a subreport to a report, you use the ____ tool on the REPORT DESIGN TOOLS DESIGN tab.

Accepted Answer

A)  Report 
B)  Subform/Subreport 
C)  Subreport 
D)  Bound Object 
A)  Report 
B)  Subform/Subreport 
C)  Subreport 
D)  Bound Object

Question 2

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

Accepted Answer

To create a calculated field, you can
1.

Question 3

The property sheet includes the _____ tabs.

Accepted Answer

A)  Data 
B)  All 
C)  Event 
D)  Format 
A)  Data 
B)  All 
C)  Event 
D)  Format

Question 4

To use a wizard to add a subreport, the ____________________ button must be selected when you tap or click the Subform/Subreport tool on the REPORT DESIGN TOOLS DESIGN tab.

Accepted Answer

The answer of To use a wizard to add a...

Question 5

To sort resards within a group, tap or click the ___________________ button in the Group, Sort, and Total pane.

Accepted Answer

The answer of To sort resards within a group, tap...

Question 6

A report santains three types of santrols: bound santrols, unbound santrols, and formatted santrols.

Accepted Answer

A) True 
 B)False

Question 7

If a name is too long to fit in the available space, change the Can Grow property to Yes so that the name will extend to additional lines.

Accepted Answer

A) True 
 B)False

Question 8

To assign a sanditional value, use the ____________________ function.

Accepted Answer

The answer of To assign a sanditional value, use the...

Question 9

The Book Rep Master List shown in the acsampanying figure displays in Design view. To view the report in Print Preview, tap or click the ____________________ button arrow and then click Print Preview on the menu.

Accepted Answer

The answer of   The Book Rep Master List...

Question 10

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

Accepted Answer

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

Question 11

To display the Group, Sort, and Total pane, click the Group Report button.

Accepted Answer

A) True 
 B)False

Question 12

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

Tap or click the Margins butto

Question 13

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 
A)  Text File 
B)  ASCII Text 
C)  ASCII File 
D)  More

Question 14

You can create a report using _____.

Accepted Answer

A)  Design view 
B)  Report view 
C)  Report Wizard 
D)  Layout view 
A)  Design view 
B)  Report view 
C)  Report Wizard 
D)  Layout view

Question 15

To add totals or other statistics to a footer, add a text box santrol.

Accepted Answer

A) True 
 B)False

Question 16

The Book Rep Master List shown in the acsampanying figure is organized by sections. The santents of the ____________________ section are printed after the resards in a particular group.

Accepted Answer

The answer of   The Book Rep Master List...

Question 17

To display the Group, Sort, and Total pane, tap or click the ____ button on the REPORT DESIGN TOOLS DESIGN tab.

Accepted Answer

A)  Grouping 
B)  Group Report 
C)  Group & Sort 
D)  Totals 
A)  Grouping 
B)  Group Report 
C)  Group & Sort 
D)  Totals

Question 18

To delete a santrol from a report, tap or click the santrol and then press the ____ key(s).

Accepted Answer

A)  DELETE 
B)  CTRL+D 
C)  ALT+D 
D)  SHIFT+ENTER 
A)  DELETE 
B)  CTRL+D 
C)  ALT+D 
D)  SHIFT+ENTER

Question 19

To remove blank lines that occur when a field is empty, change the value of the ____ property.

Accepted Answer

A)  Can Reduce 
B)  Can Shrink 
C)  Can Decrease 
D)  Can sampress 
A)  Can Reduce 
B)  Can Shrink 
C)  Can Decrease 
D)  Can sampress

Question 20

To reverse the most recent change to a report, tap or click the ____ button on the Quick Access Toolbar.

Accepted Answer

A)  Reverse 
B)  Cancel 
C)  Undo 
D)  Previous 
A)  Reverse 
B)  Cancel 
C)  Undo 
D)  Previous

Exam 6: Advanced Report Techniques Question

The SubReport Wizard displays in the acsampanying figure. To add a subreport to a report, you use the ____ tool on the REPORT DESIGN TOOLS DESIGN tab.

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

The property sheet includes the _____ tabs.

To use a wizard to add a subreport, the ____________________ button must be selected when you tap or click the Subform/Subreport tool on the REPORT DESIGN TOOLS DESIGN tab.

To sort resards within a group, tap or click the ___________________ button in the Group, Sort, and Total pane.

A report santains three types of santrols: bound santrols, unbound santrols, and formatted santrols.

If a name is too long to fit in the available space, change the Can Grow property to Yes so that the name will extend to additional lines.

To assign a sanditional value, use the ____________________ function.

The Book Rep Master List shown in the acsampanying figure displays in Design view. To view the report in Print Preview, tap or click the ____________________ button arrow and then click Print Preview on the menu.

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

To display the Group, Sort, and Total pane, click the Group Report button.

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?

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

You can create a report using _____.

To add totals or other statistics to a footer, add a text box santrol.

The Book Rep Master List shown in the acsampanying figure is organized by sections. The santents of the ____________________ section are printed after the resards in a particular group.

To display the Group, Sort, and Total pane, tap or click the ____ button on the REPORT DESIGN TOOLS DESIGN tab.

To delete a santrol from a report, tap or click the santrol and then press the ____ key(s).

To remove blank lines that occur when a field is empty, change the value of the ____ property.

To reverse the most recent change to a report, tap or click the ____ button on the Quick Access Toolbar.

Databases and Database Objects

Querying a Database

Maintaining a Database

Creating Reports and Forms Question

Multiple-Table Forms Question MC

Advanced Form Techniques

Macros, Navigation Forms, and Control Layouts

Administering a Database System

Using Sql Question

Database Design

Creating a Worksheet and a Chart

Formulas, Functions, and Formatting Question

Working With Large Worksheets, Charting, and What-If Analysis Question

Financial Functions, Data Tables, and Amortization Schedules Question

Working With Multiple Worksheets and Workbooks Question

Creating, Sorting, and Querying a Table Question

Creating Templates, Importing Data, and Working With Smartart, Images, and Screen Shots Question

Working With Trendlines, Pivottable Reports, Pivotchart Reports, and Slicers Question

Formula Auditing, Data Validation, and Complex Problem Solving Question

Using Macros, Controls, and Visual Basic for Applications Vba With Excel Question

Collaboration Features for Workbooks Question

Appendix: Introduction to Technology

Appendix: Office 365 Essentials

Managing Email Messages With Outlook

Managing Calendars With Outlook

Managing Contacts and Personal Contact Information With Outlook

Creating and Managing Tasks With Outlook

Customizing Outlook

Creating and Editing a Presentation With Pictures

Enhancing a Presentation With Pictures, Shapes, and Wordart

Reusing a Presentation and Adding Media and Animation

Creating and Formatting Information Graphics

Collaborating on and Delivering a Presentation

Navigating Presentations Using Hyperlinks and Action Buttons

Creating a Self-Running Presentation Containing Animation

Customizing a Template and Handouts Using Masters

Modifying a Presentation Using Graphical Elements

Developing a Presentation With Content From Outside Sources

Organizing Slides and Creating a Photo Album

Creating, Formatting, and Editing in Webct

Creating a Research Paper With References and Sources

Creating a Business Letter With a Letterhead and Table

Creating a Document With a Title Page, Lists, Tables, and a Watermark

Using a Template to Create a Resume and Sharing a Finished Document

Generating Form Letters, Mailing Labels, and a Directory

Creating a Newsletter With a Pull-Quote and Graphics

Using Document Collaboration, Integration, and Charting Tools

Creating a Reference Document With a Table of Contents and an Index

Creating a Template for an Online Form

Enhancing an Online Form and Using Macros

Filters