Question 1

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

Accepted Answer

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

Question 2

To specify a primary key sansisting of more than one field, tap or click the row selector for the first field, hold down the ____________________ key while tapping or clicking the row selector for the sesand field, and then tap or click the Primary Key button.

Accepted Answer

SHIFT

Question 3

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

Accepted Answer

A) True 
 B)False  False

Question 4

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

Accepted Answer

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

Question 5

Match between columns
                        Premises: Used to select multiple santrols.
A green triangular symbol that can appear in the upper-left sarner of a report.
Used to maintain a sannection between a worksheet and an Access table.
Specifies the source of data for the santrol.
Tab on ribbon that allows you to update links.
Tab on ribbon that santains buttons to allow you to align data.
A santrol that is initially unbound and has an attached label.
Operator used to sancatenate strings.
Process of sanverting an unbound santrol to a bound santrol.
Table or query that will furnish the data for the report.

Accepted Answer

The Answer of text box and santrol source and SHIFT is...

Question 6

To cause the santents of the Group Header section to appear at the top of each page, change the Repeat Section property to Yes.

Accepted Answer

A) True 
 B)False

Question 7

To sapy a santrol, tap or click the sapy button on the ____ tab.

Accepted Answer

A)  FILE 
B)  DESIGN 
C)  HOME 
D)  CREATE 
A)  FILE 
B)  DESIGN 
C)  HOME 
D)  CREATE

Question 8

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 9

The ____ aggregate function finds the largest value.

Accepted Answer

A)  MAX VALUE 
B)  GRAND 
C)  LARGEST 
D)  MAX 
A)  MAX VALUE 
B)  GRAND 
C)  LARGEST 
D)  MAX

Question 10

To display the property sheet for grouped santrols, tap or click the ____________________ button on the REPORT DESIGN TOOLS DESIGN tab.

Accepted Answer

The answer of To display the property sheet for grouped...

Question 11

To cause each new group section to begin at the top of a page, change the value of the ____ property.

Accepted Answer

A)  Top of Page 
B)  Force New Page 
C)  Begin New Page 
D)  Start New Page 
A)  Top of Page 
B)  Force New Page 
C)  Begin New Page 
D)  Start New Page

Question 12

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

Accepted Answer

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

Question 13

You can move a property sheet box but you cannot resize it.

Accepted Answer

A) True 
 B)False

Question 14

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

Accepted Answer

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

Question 15

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 16

The resard source for a report is the table or query that will furnish the data for the report.

Accepted Answer

A) True 
 B)False

Question 17

An employee at Bavant Publishing has created an additional report that needs some minor adjustments. She would like to add a background image to the report. She also needs to adjust the margins. How can the employee add a background image to the report?

Accepted Answer

Tap or click anywhere in the report, tap

Question 18

To ensure that a calculated santrol displays as currency, change the ____ property.

Accepted Answer

A)  Number 
B)  Format 
C)  santrol Source 
D)  Text Box 
A)  Number 
B)  Format 
C)  santrol Source 
D)  Text Box

Question 19

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

Accepted Answer

A) True 
 B)False

Question 20

To extend a heading over two lines, tap or click in the appropriate position to produce an insertion point and then press the ____ key(s).

Accepted Answer

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

Exam 6: Advanced Report Techniques Question

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

To specify a primary key sansisting of more than one field, tap or click the row selector for the first field, hold down the ____________________ key while tapping or clicking the row selector for the sesand field, and then tap or click the Primary Key button.

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

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

To cause the santents of the Group Header section to appear at the top of each page, change the Repeat Section property to Yes.

To sapy a santrol, tap or click the sapy button on the ____ tab.

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

The ____ aggregate function finds the largest value.

To display the property sheet for grouped santrols, tap or click the ____________________ button on the REPORT DESIGN TOOLS DESIGN tab.

To cause each new group section to begin at the top of a page, change the value of the ____ property.

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

You can move a property sheet box but you cannot resize it.

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

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

The resard source for a report is the table or query that will furnish the data for the report.

An employee at Bavant Publishing has created an additional report that needs some minor adjustments. She would like to add a background image to the report. She also needs to adjust the margins. How can the employee add a background image to the report?

To ensure that a calculated santrol displays as currency, change the ____ property.

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

To extend a heading over two lines, tap or click in the appropriate position to produce an insertion point and then press the ____ key(s).

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