The world’s Largest Sharp Brain Virtual Experts Marketplace Just a click Away
Levels Tought:
Elementary,Middle School,High School,College,University,PHD
| Teaching Since: | Apr 2017 |
| Last Sign in: | 57 Weeks Ago |
| Questions Answered: | 7570 |
| Tutorials Posted: | 7352 |
BS,MBA, PHD
Adelphi University/Devry
Apr-2000 - Mar-2005
HOD ,Professor
Adelphi University
Sep-2007 - Apr-2017
Score for this quiz: 40 out of 40
Â
Question 1
Â
(CO 1) When creating a report, you should consider all of the following except
 Â
data that should be considered confidential.
Â
Â
 Â
number of records input into the report.
Â
 Â
the purpose of the report.
Â
 Â
who will use the report.
Â
Â
Question 2
Â
(CO 1) A report footer
 Â
is used to print the report results.
Â
Â
 Â
prints grand totals at the end of the report.
Â
 Â
prints group statistics at the end of the report.
Â
 Â
All of the above
Â
Â
Question 3
Â
(CO 1) Summary options are found
 Â
All of the above
Â
Â
 Â
in the report wizard with sorting options.
Â
 Â
in the print layout view.
Â
 Â
in the options toolbar.
Â
Â
Question 4
Â
(CO 1) The following steps will create a report.
Â
 Â
Set focus on a table or query object, click on the create tab, then click the report button in the reports group.
 Â
Click on the table tab, select your fields, and then click the finish button.
Â
 Â
Set focus on a table or query object, click on the design tab, open the table or query object, then click design report.
 Â
Click on the create tab, select the report wizard, select your tables or queries, and then your fields.
Â
Question 5
Â
(CO 1) A report can be created from
Â
 Â
queries and tables.
Â
 Â
a spreadsheet.
Â
 Â
a database.
Â
 Â
forms.
Â
Â
Question 6
Â
(CO 1) When designing a report, make sure that your report
 Â
uses all report sections.
Â
 Â
has grouped data.
Â
 Â
has a date and time.
Â
Â
 Â
is easy to understand.
Â
Â
Question 7
Â
(CO 7) Using grouping when building a report accomplishes the following.
Â
 Â
All of the above.
Â
 Â
Grouped data can be summarized.
Â
 Â
Grouped data can be sorted.
Â
 Â
Summary options allow for sum, average, min and max.
Â
Â
Question 8
Â
(CO 7) To use the report wizard, do the following steps first.
 Â
Click create and click report wizard.
Â
 Â
Click report wizard and select the correct table.
Â
 Â
Select the correct fields.
Â
Â
 Â
All of the above
Â
Â
Question 9
Â
(CO 7) The label wizard is NOT used for the following.
 Â
To create labels for file folders.
Â
Â
 Â
To create labels for a form
Â
 Â
To create name tags.
Â
 Â
To create mailing labels.
Â
Â
Question 10
Â
(CO 7) When modifying a report, the arrange option does the following.
Â
 Â
All of the above
Â
 Â
To change the layout of the report
Â
 Â
To move fields up or down
Â
 Â
To insert space above or below your position
Â
Â
BIS----------- 24-----------5 W-----------eek----------- 6 -----------Qui-----------z A-----------nsw-----------ers-----------