 |
1 | |
This button allows you to create a new report, table, form, or query. |
|
| | A) | Add Object |
| | B) | New Object |
| | C) | Database Object |
| | D) | Object Wizard |
|
2 | |
Organizing the sections of a report based on categories is called what? |
|
| | A) | tabling |
| | B) | seriating |
| | C) | normalizing |
| | D) | grouping |
|
3 | |
Andy Zeigler and Ashish Mungara work in accounting. Anna Patel and Ryan Allen work in marketing. If a payroll report were generated that was grouped first on department and then on employee last name, in what order would these employees appear on the report? |
|
| | A) | Allen, Mungara, Patel, Zeigler |
| | B) | Allen, Patel, Mugara, Zeigler |
| | C) | Mungara, Zeigler, Allen, Patel |
| | D) | Patel, Allen, Zeigler, Mungara |
|
4 | |
When grouping, you can sum numerical fields in the group by clicking this button in the Report Wizard. |
|
| | A) | Summary Options |
| | B) | Sort Options |
| | C) | Computation Options |
| | D) | Field Options |
|
5 | |
Which of the following is not one of the group calculations that can be performed in the Summary Options dialog box? |
|
| | A) | Count |
| | B) | Average |
| | C) | Sum |
| | D) | Max |
|
6 | |
In the Summary Options dialog box, you can choose to do any of the following except |
|
| | A) | calculate percent of total for sums. |
| | B) | show detail and summary. |
| | C) | show detail only. |
| | D) | show summary only. |
|
7 | |
This is not an available layout for a grouped report in the Report Wizard. |
|
| | A) | Outline 1 |
| | B) | Center |
| | C) | Block |
| | D) | Stepped |
|
8 | |
Which of the following is not one of the styles available in the Report Wizard? |
|
| | A) | Soft Gray |
| | B) | Formal |
| | C) | Compact |
| | D) | Industrial |
|
9 | |
Changes to the layout of the report are made in what view? |
|
| | A) | Report Create |
| | B) | Report Design |
| | C) | Report Format |
| | D) | Report Layout |
|
10 | |
In a grouped report, the label control for a text box appears in which section? |
|
| | A) | Report Header |
| | B) | Group Header |
| | C) | Detail |
| | D) | Group Footer |
|
11 | |
To automatically resize the selected control to fit its contents, choose |
|
| | A) | Edit/Control/Size |
| | B) | Tools/Controls/Sizing Handles |
| | C) | Format/Control/Size |
| | D) | Format/Size/To Fit |
|
12 | |
Groups should be created based on priority from the smallest to the largest. |
|
| | A) | TRUE |
| | B) | FALSE |
|
13 | |
You can group by as many as ten fields in any one report. |
|
| | A) | TRUE |
| | B) | FALSE |
|
14 | |
Use the Max group calculation to add all the values by group. |
|
| | A) | TRUE |
| | B) | FALSE |
|
15 | |
You must use grouping in order to use the Report Wizard to display summary data in a report. |
|
| | A) | TRUE |
| | B) | FALSE |
|
16 | |
You can use the Report Wizard to quickly create a report and then customize the report in Design view. |
|
| | A) | TRUE |
| | B) | FALSE |