Question 1

Match between columns
                        Premises: A green triangular symbol that can appear in the upper-left corner of a report.

Accepted Answer

The Answer of text box and control source and REPORT is...

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

Critical Thinking Questions Case 6-1 An employee at Bavant Publishing needs to make some changes to the report shown in the accompanying 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 4

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 5

The SubReport Wizard displays in the accompanying 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 6

To periodically view a report to gauge how it will look containing 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

Question 7

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 8

To display the Group, Sort, and Total pane, tap or click the ____ button on the REPORT DESIGN TOOLS DESIGN tab.

Accepted Answer

A)  Grouping 
B)  Group Report 
C)  Group & Sort 
D)  Totals 
A)  Grouping 
B)  Group Report 
C)  Group & Sort 
D)  Totals

Question 9

Modified Multiple Choice You can create a report using _____.

Accepted Answer

A)  Design view 
B)  Report view 
C)  Report Wizard 
D)  Layout view 
A)  Design view 
B)  Report view 
C)  Report Wizard 
D)  Layout view

Question 10

Critical Thinking Questions Case 6-2 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 11

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 12

Match between columns
                        Premises: A control that is initially unbound and has an attached label.

Accepted Answer

The Answer of SHIFT and error indicator and DATABASE TOOLS is...

Question 13

Modified Multiple Choice The aggregate functions available in Access are _____.

Accepted Answer

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

Question 14

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 15

Match between columns
                        Premises: Tab on ribbon that contains buttons to allow you to align data.

Accepted Answer

The Answer of record source and control source and binding is...

Question 16

Describe three ways that you can create a calculated field in a query.

Accepted Answer

To create a calculated field, you can:

Question 17

The employee has decided to select the pre-defined option, Narrow, to reduce the size of the margins for the report. How does she change to the Narrow margin option?

Accepted Answer

Tap or click the Margins butto

Question 18

The process of converting an unbound control to a bound control is called binding.

Accepted Answer

A) True 
 B)False

Question 19

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

Accepted Answer

A) True 
 B)False

Question 20

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

Accepted Answer

A) True 
 B)False

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

Critical Thinking Questions Case 6-1 An employee at Bavant Publishing needs to make some changes to the report shown in the accompanying figure. The total amount should display as currency with two decimal places. How can the employee make this change?

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

The SubReport Wizard displays in the accompanying 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 periodically view a report to gauge how it will look containing data, tap or click _____ on the View menu.

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

To display the Group, Sort, and Total pane, tap or click the ____ button on the REPORT DESIGN TOOLS DESIGN tab.

Modified Multiple Choice You can create a report using _____.

Critical Thinking Questions Case 6-2 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?

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

Modified Multiple Choice The aggregate functions available in Access are _____.

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

Describe three ways that you can create a calculated field in a query.

The employee has decided to select the pre-defined option, Narrow, to reduce the size of the margins for the report. How does she change to the Narrow margin option?

The process of converting an unbound control to a bound control is called binding.

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

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

Access: Creating Reports and Forms

Access: Multiple-Table Forms

Access: Advanced Form Techniques

Excell: Financial Functions, Data Tables, and Amortization Schedules Question

Excell: Working With Multiple Worksheets and Workbooks

Excell: Creating, Sorting, and Querying a Table

Excell: Creating Templates, Importing Data, and Working With Smartart, Images, and Screen Shots

Outlook : Managing Contacts and Personal Contact Information With Outlook

Powerpoint: Creating and Formatting Information Graphics Question

Powerpoint: Collaborating on and Delivering a Presentation Question

Powerpoint: Navigating Presentations Using Hyperlinks and Action Buttons

Powerpoint: Creating a Self-Running Presentation Containing Animation

Word: Using a Template to Create a Resume and Sharing a Finished Document

Word: Generating Form Letters, Mailing Labels, and a Directory

Word: Creating a Newsletter With a Pull-Quote and Graphics

Filters

Exam 3: Access: Advanced Report Techniques

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

Critical Thinking Questions Case 6-1 An employee at Bavant Publishing needs to make some changes to the report shown in the accompanying figure. The total amount should display as currency with two decimal places. How can the employee make this change?

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

The SubReport Wizard displays in the accompanying 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 periodically view a report to gauge how it will look containing data, tap or click _____ on the View menu.

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

To display the Group, Sort, and Total pane, tap or click the ____ button on the REPORT DESIGN TOOLS DESIGN tab.

Modified Multiple Choice You can create a report using _____.

Critical Thinking Questions Case 6-2 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?

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

Modified Multiple Choice The aggregate functions available in Access are _____.

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

Describe three ways that you can create a calculated field in a query.

The employee has decided to select the pre-defined option, Narrow, to reduce the size of the margins for the report. How does she change to the Narrow margin option?

The process of converting an unbound control to a bound control is called binding.

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

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

Access: Creating Reports and Forms

Access: Multiple-Table Forms

Access: Advanced Form Techniques

Excell: Financial Functions, Data Tables, and Amortization Schedules Question

Excell: Working With Multiple Worksheets and Workbooks

Excell: Creating, Sorting, and Querying a Table

Excell: Creating Templates, Importing Data, and Working With Smartart, Images, and Screen Shots

Outlook : Managing Contacts and Personal Contact Information With Outlook

Powerpoint: Creating and Formatting Information Graphics Question

Powerpoint: Collaborating on and Delivering a Presentation Question

Powerpoint: Navigating Presentations Using Hyperlinks and Action Buttons

Powerpoint: Creating a Self-Running Presentation Containing Animation

Word: Using a Template to Create a Resume and Sharing a Finished Document

Word: Generating Form Letters, Mailing Labels, and a Directory

Word: Creating a Newsletter With a Pull-Quote and Graphics

Filters