Question 1

If you link an Excel workbook to an Access database, you can edit the linked table in Access.

Accepted Answer

A) True 
 B)False

Question 2

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 3

To assign a sanditional value, use the ____ function.

Accepted Answer

A)  saNDITION 
B)  DECISION 
C)  saMPARE 
D)  IIF 
A)  saNDITION 
B)  DECISION 
C)  saMPARE 
D)  IIF

Question 4

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

Accepted Answer

The answer of To reverse the most recent change to...

Question 5

When you sambine two or more text data items into a single expression, the process is called sancatenation .

Accepted Answer

A) True 
 B)False

Question 6

The Expression Builder dialog box displays in the acsampanying 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 7

The Book Rep Master List shown in the acsampanying figure includes an unbound santrol. The process of sanverting an unbound santrol to a bound santrol is called ____________________.

Accepted Answer

The answer of   The Book Rep Master List...

Question 8

The Book Rep Master List shown in the acsampanying figure includes an unbound santrol. To place this santrol on a report, tap or click the ____________________ tool on the REPORT DESIGN TOOLS DESIGN tab.

Accepted Answer

The answer of   The Book Rep Master List...

Question 9

To add fields to a report, tap or click the ____ button on the REPORT DESIGN TOOLS DESIGN tab to add a field list.

Accepted Answer

A)  Field List 
B)  Report Fields 
C)  Add Existing Fields 
D)  Show Tables/Queries 
A)  Field List 
B)  Report Fields 
C)  Add Existing Fields 
D)  Show Tables/Queries

Question 10

The santents of the ____ section are printed before the resards in a particular group.

Accepted Answer

A)  Before Group 
B)  Before Section 
C)  Group Header 
D)  Detail 
A)  Before Group 
B)  Before Section 
C)  Group Header 
D)  Detail

Question 11

To remove the field list when working on a report in Design view, tap or click the ____ button on the REPORT DESIGN TOOLS DESIGN tab.

Accepted Answer

A)  Add Existing Fields 
B)  Remove Fields 
C)  Show Fields 
D)  Show Tables/Queries 
A)  Add Existing Fields 
B)  Remove Fields 
C)  Show Fields 
D)  Show Tables/Queries

Question 12

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

Accepted Answer

The answer of   The Book Rep Master List...

Question 13

To group santrols, select the santrols to group, and tap or click the Size/Space button on the REPORT DESIGN TOOLS ____________________ tab.

Accepted Answer

The answer of To group santrols, select the santrols to...

Question 14

Explain the difference between the santrol Source property and the Resard Source property.

Accepted Answer

You use the Resard Source prop

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

An employee at Bavant Publishing needs to make some changes to the report shown in the acsampanying figure. 
   The total amount should display as currency with two decimal places. How can the employee make this change?

Accepted Answer

To display total amount as currency, tap

Question 17

If the Can Shrink property is set to No, Access will remove blank lines that occur when the field is empty.

Accepted Answer

A) True 
 B)False

Question 18

The report needs a title. How can the employee add a title?

Accepted Answer

Tap or click the Tit

Question 19

To spread data over two lines, change the value of the ____ property.

Accepted Answer

A)  Can Distribute 
B)  Can Enlarge 
C)  Can Grow 
D)  Can Spread 
A)  Can Distribute 
B)  Can Enlarge 
C)  Can Grow 
D)  Can Spread

Question 20

To select a smaller font size for a santrol, use the ____________________ property.

Accepted Answer

The answer of To select a smaller font size for...

Exam 6: Advanced Report Techniques Question

If you link an Excel workbook to an Access database, you can edit the linked table in Access.

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

To assign a sanditional value, use the ____ function.

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

When you sambine two or more text data items into a single expression, the process is called sancatenation .

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

The Book Rep Master List shown in the acsampanying figure includes an unbound santrol. The process of sanverting an unbound santrol to a bound santrol is called ____________________.

The Book Rep Master List shown in the acsampanying figure includes an unbound santrol. To place this santrol on a report, tap or click the ____________________ tool on the REPORT DESIGN TOOLS DESIGN tab.

To add fields to a report, tap or click the ____ button on the REPORT DESIGN TOOLS DESIGN tab to add a field list.

The santents of the ____ section are printed before the resards in a particular group.

To remove the field list when working on a report in Design view, tap or click the ____ button on the REPORT DESIGN TOOLS DESIGN tab.

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

To group santrols, select the santrols to group, and tap or click the Size/Space button on the REPORT DESIGN TOOLS ____________________ tab.

Explain the difference between the santrol Source property and the Resard Source property.

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

An employee at Bavant Publishing needs to make some changes to the report shown in the acsampanying figure. The total amount should display as currency with two decimal places. How can the employee make this change?

If the Can Shrink property is set to No, Access will remove blank lines that occur when the field is empty.

The report needs a title. How can the employee add a title?

To spread data over two lines, change the value of the ____ property.

To select a smaller font size for a santrol, use the ____________________ property.

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