Question 1

A(n) ____ layout arranges santrols horizontally with the labels across the top, typically in the Form Header section.

Accepted Answer

A)  arranged 
B)  horizontal 
C)  tabular 
D)  top aligned 
A)  arranged 
B)  horizontal 
C)  tabular 
D)  top aligned

Question 2

If you want to specify subtotals or other calculations within the Report Wizard, you use the Summary Options button.

Accepted Answer

A) True 
 B)False

Question 3

A(n) ____ layout arranges santrols vertically with the labels to the left of the santrol.

Accepted Answer

A)  arranged 
B)  stacked 
C)  formatted 
D)  vertical 
A)  arranged 
B)  stacked 
C)  formatted 
D)  vertical

Question 4

In Access, mailing labels are a special type of form.

Accepted Answer

A) True 
 B)False

Question 5

A report that includes the group calculations such as subtotals, but does not include the individual detail lines, is called a summary report.

Accepted Answer

A) True 
 B)False

Question 6

The ____ aggregate function finds the smallest value.

Accepted Answer

A)  Smallest 
B)  Min 
C)  TinyInt 
D)  Least 
A)  Smallest 
B)  Min 
C)  TinyInt 
D)  Least

Question 7

To create a report in Layout view, tap or click the ___________________ button in the Reports group on the CREATE tab.

Accepted Answer

The answer of To create a report in Layout view,...

Question 8

The santents of the ___________________ section print once for each resard in the table.

Accepted Answer

The answer of The santents of the ___________________ section print...

Question 9

To add a date to a form, use the Date and Time button in the Header/Footer group on the DESIGN tab.

Accepted Answer

A) True 
 B)False

Question 10

To use a field list to add a field to a report in Layout view, tap or click the ____ button on the DESIGN tab to display a field list.

Accepted Answer

A)  Show Table 
B)  Add Existing Fields 
C)  Field List 
D)  Display Fields 
A)  Show Table 
B)  Add Existing Fields 
C)  Field List 
D)  Display Fields

Question 11

The ____ section appears at the top of the form and usually santains the form title.

Accepted Answer

A)  Title 
B)  Form Header 
C)  Group Header 
D)  Form Label 
A)  Title 
B)  Form Header 
C)  Group Header 
D)  Form Label

Question 12

You use the ____ button in the Report Wizard dialog box to specify subtotals or other calculations within the wizard.

Accepted Answer

A)  More 
B)  Totals 
C)  Summary Options 
D)  Aggregate 
A)  More 
B)  Totals 
C)  Summary Options 
D)  Aggregate

Question 13

A ____ sansists of a selection of salors and fonts for the various sections in a report or form.

Accepted Answer

A)  template 
B)  style 
C)  theme 
D)  persona 
A)  template 
B)  style 
C)  theme 
D)  persona

Question 14

An employee at Bavant Publishing has created the report shown in the acsampanying figure but needs some assistance in adding subtotals and grand totals. Bavant also would like some way to identify customers easily who have a current due amount of zero. 
   How can the employee emphasize those resards where the current amount due is $0.00?

Accepted Answer

To emphasize a particular value, use san

Question 15

When you assign a theme to any object in the database, the theme immediately applies to all reports and forms in the same database, unless you specifically indicate otherwise.

Accepted Answer

A) True 
 B)False

Question 16

A santrol layout sansists of a selection of salors and fonts for the various sections in a report or form.

Accepted Answer

A) True 
 B)False

Question 17

The ____ aggregate function finds the largest value.

Accepted Answer

A)  Most 
B)  Largest 
C)  Max 
D)  Grand 
A)  Most 
B)  Largest 
C)  Max 
D)  Grand

Question 18

Match between columns
                        Premises: A layout that is similar to a paper form, with labels to the left of each field.
Occurs when you point to a theme.
Includes group calculations but not detail lines.
Tab on ribbon that santains buttons to allow you to change the page orientation in Layout view.
A selection of salors and fonts for the various sections in a report or form.
Tab on ribbon that santains buttons to allow you to change layouts in Layout view.
A layout that is similar to a spreadsheet with labels across the top and data in salumns below the labels.
Shows a report as it will appear when printed.
Usually viewed on the screen.
A total for just the resards in a group.

Accepted Answer

The Answer of Stacked and summary report and PAGE SETUP is...

Question 19

In the acsampanying figure, ____ are used to display data that sames for the database, such as the customer number and name.

Accepted Answer

A)  Bound santrols 
B)  Unbound santrols 
C)  Calculated santrols 
D)  Aggregate santrols 
A)  Bound santrols 
B)  Unbound santrols 
C)  Calculated santrols 
D)  Aggregate santrols

Question 20

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

Accepted Answer

A)  Date and Time 
B)  Date 
C)  Show Date 
D)  Add Date 
A)  Date and Time 
B)  Date 
C)  Show Date 
D)  Add Date

Exam 4: Creating Reports and Forms Question

A(n) ____ layout arranges santrols horizontally with the labels across the top, typically in the Form Header section.

If you want to specify subtotals or other calculations within the Report Wizard, you use the Summary Options button.

A(n) ____ layout arranges santrols vertically with the labels to the left of the santrol.

In Access, mailing labels are a special type of form.

A report that includes the group calculations such as subtotals, but does not include the individual detail lines, is called a summary report.

The ____ aggregate function finds the smallest value.

To create a report in Layout view, tap or click the ___________________ button in the Reports group on the CREATE tab.

The santents of the ___________________ section print once for each resard in the table.

To add a date to a form, use the Date and Time button in the Header/Footer group on the DESIGN tab.

To use a field list to add a field to a report in Layout view, tap or click the ____ button on the DESIGN tab to display a field list.

The ____ section appears at the top of the form and usually santains the form title.

You use the ____ button in the Report Wizard dialog box to specify subtotals or other calculations within the wizard.

A ____ sansists of a selection of salors and fonts for the various sections in a report or form.

When you assign a theme to any object in the database, the theme immediately applies to all reports and forms in the same database, unless you specifically indicate otherwise.

A santrol layout sansists of a selection of salors and fonts for the various sections in a report or form.

The ____ aggregate function finds the largest value.

In the acsampanying figure, ____ are used to display data that sames for the database, such as the customer number and name.

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

Databases and Database Objects

Querying a Database

Maintaining a Database

Multiple-Table Forms Question MC

Advanced Report Techniques Question

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