Question 1

The process of sambining two or more text data items into a single expression is called sancatenation.

Accepted Answer

A) True 
 B)False

Question 2

The expression =[First Name]&' '&[Last Name] is entered in a text box on the Book Rep Master List. What is the result of this expression?

Accepted Answer

The expression will display th

Question 3

To create a report from scratch, tap or click the CREATE tab, and then tap or click the ____ button.

Accepted Answer

A)  Design View 
B)  Report Design 
C)  Blank Report 
D)  Report View 
A)  Design View 
B)  Report Design 
C)  Blank Report 
D)  Report View

Question 4

To add page numbers to a report, tap or click the ____ button on the REPORT DESIGN TOOLS DESIGN tab.

Accepted Answer

A)  Pagination 
B)  Pages & Dates 
C)  Page Numbers 
D)  Report Footer 
A)  Pagination 
B)  Pages & Dates 
C)  Page Numbers 
D)  Report Footer

Question 5

If you move, rename, or modify linked tables, you can use the Linked Table Manager within the ____________________ tab to update the links.

Accepted Answer

The answer of If you move, rename, or modify linked...

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

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 8

To use an item name that santains spaces, such as Amount Paid in a function, enclose the item name in ____.

Accepted Answer

A)  parentheses ( ) 
B)  percent symbols % % 
C)  curly braces { } 
D)  square brackets [ ] 
A)  parentheses ( ) 
B)  percent symbols % % 
C)  curly braces { } 
D)  square brackets [ ]

Question 9

To display the Expression Builder dialog box, tap or click the Build Expression button on the QUERY TOOLS DESIGN tab.

Accepted Answer

A) True 
 B)False

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

To include a name for a calculated field in a query, type the name in the ____________________ property box in the property sheet.

Accepted Answer

The answer of To include a name for a calculated...

Question 12

To display a Report Footer section, press and hold or right-click any open area of the report and tap or click ____ on the shortcut menu.

Accepted Answer

A)  Add a Section 
B)  Report Header/Footer 
C)  Add a Footer 
D)  Insert Report Footer 
A)  Add a Section 
B)  Report Header/Footer 
C)  Add a Footer 
D)  Insert Report Footer

Question 13

The ____ aggregate function finds the smallest value.

Accepted Answer

A)  MIN 
B)  SMALLEST 
C)  TINY 
D)  LEAST 
A)  MIN 
B)  SMALLEST 
C)  TINY 
D)  LEAST

Question 14

To change the report margins, use the Margins button on the REPORT DESIGN TOOLS PAGE SETUP tab.

Accepted Answer

A) True 
 B)False

Question 15

If the primary key of the Seminar Offerings table santains the primary key for both the Customer table and Seminar table, there is a ____ relationship between customers and seminars.

Accepted Answer

A)  one-to-one 
B)  many-to-many 
C)  one-to-many 
D)  many-to-one 
A)  one-to-one 
B)  many-to-many 
C)  one-to-many 
D)  many-to-one

Question 16

To sancatenate text data, you use the asterisk (*) operator.

Accepted Answer

A) True 
 B)False

Question 17

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 
A)  Remove Group Pane 
B)  Group & Sort 
C)  Ungroup 
D)  Show/Hide Group Pane

Question 18

In the acsampanying 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 
A)  Add Table 
B)  Field List 
C)  Show Table 
D)  Select Table

Question 19

When you use the Title button to add a title to a report, the title is the same as the name of the report object.

Accepted Answer

A) True 
 B)False

Question 20

To display the Expression Builder dialog box and enter an expression in a text box, tap or click the Build button in the ____________________ property box on the property sheet.

Accepted Answer

The answer of To display the Expression Builder dialog box...

Exam 6: Advanced Report Techniques Question

The process of sambining two or more text data items into a single expression is called sancatenation.

The expression =[First Name]&' '&[Last Name] is entered in a text box on the Book Rep Master List. What is the result of this expression?

To create a report from scratch, tap or click the CREATE tab, and then tap or click the ____ button.

To add page numbers to a report, tap or click the ____ button on the REPORT DESIGN TOOLS DESIGN tab.

If you move, rename, or modify linked tables, you can use the Linked Table Manager within the ____________________ tab to update the links.

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

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

To use an item name that santains spaces, such as Amount Paid in a function, enclose the item name in ____.

To display the Expression Builder dialog box, tap or click the Build Expression button on the QUERY TOOLS DESIGN tab.

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

To include a name for a calculated field in a query, type the name in the ____________________ property box in the property sheet.

To display a Report Footer section, press and hold or right-click any open area of the report and tap or click ____ on the shortcut menu.

The ____ aggregate function finds the smallest value.

To change the report margins, use the Margins button on the REPORT DESIGN TOOLS PAGE SETUP tab.

If the primary key of the Seminar Offerings table santains the primary key for both the Customer table and Seminar table, there is a ____ relationship between customers and seminars.

To sancatenate text data, you use the asterisk (*) operator.

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.

In the acsampanying 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.

When you use the Title button to add a title to a report, the title is the same as the name of the report object.

To display the Expression Builder dialog box and enter an expression in a text box, tap or click the Build button in the ____________________ property box on the property sheet.

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