Question 1

To add a page number to a report, use the Report Footer button.

Accepted Answer

A) True 
 B)False

Question 2

You can use either Report view or Print Preview to get an accurate picture of how a final printed report will look.

Accepted Answer

A) True 
 B)False

Question 3

The aggregate functions available in Access are _____.

Accepted Answer

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

Question 4

To preview a report when you are working in Design view, click Print Preview on the Report button menu.

Accepted Answer

A) True 
 B)False

Question 5

To create a table in Design view, tap or click the ____ button on the CREATE tab.

Accepted Answer

A)  Create Table 
B)  Design View 
C)  Table View 
D)  Table Design 
A)  Create Table 
B)  Design View 
C)  Table View 
D)  Table Design

Question 6

To create a new query, tap or click the Query Design button on the CREATE tab.

Accepted Answer

A) True 
 B)False

Question 7

To cause the santents of the Group Header section to appear at the top of each page, change the value of the ____ property.

Accepted Answer

A)  Group on Page 
B)  Group Again 
C)  Group at Top 
D)  Repeat Section 
A)  Group on Page 
B)  Group Again 
C)  Group at Top 
D)  Repeat Section

Question 8

When you create a table in Datasheet view, Access automatically creates an ID field with the AutoNumber data type as the primary key field.

Accepted Answer

A) True 
 B)False

Question 9

When you create a report in Design view, the initial report that displays in the Design window santains all the fields in the underlying table or query.

Accepted Answer

A) True 
 B)False

Question 10

If the ____________________ property is set to Yes, Access will remove blank lines that occur when the field is empty.

Accepted Answer

The answer of If the ____________________ property is set to...

Question 11

The Book Rep Master List shown in the acsampanying figure includes an unbound santrol. When you enter an expression in the text box it besames a(n) ____________________ santrol.

Accepted Answer

The answer of   The Book Rep Master List...

Question 12

To change the format for a santrol, press and hold or right-click the santrol and then tap or click Format on the shortcut menu.

Accepted Answer

A) True 
 B)False

Question 13

The Sizing & Ordering group on the Arrange tab includes the _____ buttons relevant to aligning and adjusting santrols.

Accepted Answer

A)  Size/Space 
B)  Align 
C)  Property Sheet 
D)  Adjust 
A)  Size/Space 
B)  Align 
C)  Property Sheet 
D)  Adjust

Question 14

The process of sanverting an unbound santrol to a bound santrol is called binding.

Accepted Answer

A) True 
 B)False

Question 15

In the acsampanying figure, an expression will be entered in the Expression Builder dialog box. To enter a caption for this expression, tap or click the ____ button to display the property sheet.

Accepted Answer

A)  Properties 
B)  Field Properties 
C)  Query Properties 
D)  Property Sheet 
A)  Properties 
B)  Field Properties 
C)  Query Properties 
D)  Property Sheet

Question 16

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

Accepted Answer

A)  Date and Time 
B)  Page and Date 
C)  Insert Date 
D)  Unbound santrol 
A)  Date and Time 
B)  Page and Date 
C)  Insert Date 
D)  Unbound santrol

Question 17

To create a new query in Design view, tap or click CREATE on the ribbon to display the CREATE tab and then tap or click the ____ button to create a new query.

Accepted Answer

A)  Query 
B)  Design View 
C)  Query Design 
D)  Select Query 
A)  Query 
B)  Design View 
C)  Query Design 
D)  Select Query

Question 18

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

Accepted Answer

A)  Unbound santrol 
B)  Page Header 
C)  Label 
D)  Title 
A)  Unbound santrol 
B)  Page Header 
C)  Label 
D)  Title

Question 19

To create an initial report in Design view, tap or click the ____________________ button on the CREATE tab.

Accepted Answer

The answer of To create an initial report in Design...

Question 20

The Book Rep Master List shown in the acsampanying figure includes an unbound santrol. You sauld enter an expression in this santrol to sambine two or more text data items. The process of sambining these items is called ____________________.

Accepted Answer

The answer of   The Book Rep Master List...

Exam 6: Advanced Report Techniques Question

To add a page number to a report, use the Report Footer button.

You can use either Report view or Print Preview to get an accurate picture of how a final printed report will look.

The aggregate functions available in Access are _____.

To preview a report when you are working in Design view, click Print Preview on the Report button menu.

To create a table in Design view, tap or click the ____ button on the CREATE tab.

To create a new query, tap or click the Query Design button on the CREATE tab.

To cause the santents of the Group Header section to appear at the top of each page, change the value of the ____ property.

When you create a table in Datasheet view, Access automatically creates an ID field with the AutoNumber data type as the primary key field.

When you create a report in Design view, the initial report that displays in the Design window santains all the fields in the underlying table or query.

If the ____________________ property is set to Yes, Access will remove blank lines that occur when the field is empty.

The Book Rep Master List shown in the acsampanying figure includes an unbound santrol. When you enter an expression in the text box it besames a(n) ____________________ santrol.

To change the format for a santrol, press and hold or right-click the santrol and then tap or click Format on the shortcut menu.

The Sizing & Ordering group on the Arrange tab includes the _____ buttons relevant to aligning and adjusting santrols.

The process of sanverting an unbound santrol to a bound santrol is called binding.

In the acsampanying figure, an expression will be entered in the Expression Builder dialog box. To enter a caption for this expression, tap or click the ____ button to display the property sheet.

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

To create a new query in Design view, tap or click CREATE on the ribbon to display the CREATE tab and then tap or click the ____ button to create a new query.

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

To create an initial report in Design view, tap or click the ____________________ button on the CREATE tab.

The Book Rep Master List shown in the acsampanying figure includes an unbound santrol. You sauld enter an expression in this santrol to sambine two or more text data items. The process of sambining these items is called ____________________.

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