Exam 8: Analyzing Data With Reports
Exam 1: Getting Started With Access 201368 Questions
Exam 2: Building and Using Queries66 Questions
Exam 3: Using Forms68 Questions
Exam 4: Using Reports68 Questions
Exam 5: Modifying the Database Structure79 Questions
Exam 6: Improving Queries80 Questions
Exam 7: Enhancing Forms81 Questions
Exam 8: Analyzing Data With Reports81 Questions
Exam 9: Importing and Exporting Data81 Questions
Exam 10: Analyzing Database Design Using Northwind77 Questions
Exam 11: Creating Advanced Queries81 Questions
Exam 12: Creating Advanced Reports81 Questions
Exam 13: Creating Macros88 Questions
Exam 14: Creating Macros74 Questions
Exam 15: Administering the Database89 Questions
Exam 16: Access and the Web78 Questions
Exam 17: Getting Started With Microsoft Office 201366 Questions
Select questions type
Parameter formatting allows you to change the appearance of a control on a form or report based on criteria you specify. _________________________
Free
(True/False)
4.9/5
(32)
Correct Answer:
False
You can add ____ conditional format(s) for any combination of selected controls.
Free
(Multiple Choice)
4.8/5
(34)
Correct Answer:
C
____________________ formatting allows you to change the appearance of a control on a form or report based on criteria you specify.
Free
(Short Answer)
4.9/5
(29)
Correct Answer:
Conditional
Match each term with its correct description.
Correct Answer:
Premises:
Responses:
(Matching)
4.7/5
(35)
The ____________________ New Page property helps you start printing a section at the top of a new page.
(Short Answer)
4.8/5
(34)
It is necessary for each report to have at least one control in the Detail section.
(True/False)
4.9/5
(31)
Which report section is most commonly used to calculate a summary statistic on a group of records?
(Multiple Choice)
4.8/5
(36)
To create a summary report, you should delete all of the controls in the ____ section of the report.
(Multiple Choice)
4.8/5
(37)
In the accompanying figure, which section does not contain any controls?

(Multiple Choice)
4.8/5
(31)
Report section properties cannot be modified to improve report printouts. _________________________
(True/False)
4.9/5
(30)
In Report Design View, if you want to view the grouping and sorting fields, click the ____.
(Multiple Choice)
4.9/5
(40)
You can use the Format Painter to format lines, labels, and text boxes.
(True/False)
4.7/5
(27)
Which key do you press and hold to create a perfectly horizontal line?
(Multiple Choice)
4.7/5
(33)
In the accompanying figure, the expression =Sum([Revenue]) is contained in a text box in both the Category Footer as well as Report Footer sections. Explain the difference between these two controls.
![In the accompanying figure, the expression =Sum([Revenue]) is contained in a text box in both the Category Footer as well as Report Footer sections. Explain the difference between these two controls.](https://storage.examlex.com/TBX8825/11ec00d9_4a69_70cd_9ec1_eda14ad10c23_TBX8825_00.jpg)
(Essay)
4.9/5
(35)
____________________ are predefined formats that you apply to the database to set all of the formatting enhancements such as font, color, and alignment.
(Short Answer)
5.0/5
(29)
Parameters are predefined formats that you apply to the database to set all of the formatting enhancements. _________________________
(True/False)
4.8/5
(28)
You enter parameter criteria in Query Design View inside of ____.
(Multiple Choice)
4.7/5
(29)
To move a control from one report section to another, use cut and paste.
(True/False)
4.8/5
(34)
Compared to forms and datasheets, ____ give you more control over how data is printed and greater flexibility in presenting summary information.
(Multiple Choice)
4.8/5
(30)
Showing 1 - 20 of 81
Filters
- Essay(0)
- Multiple Choice(0)
- Short Answer(0)
- True False(0)
- Matching(0)