WorksheetsAccess Lesson 6
Total questions: 20
Worksheet time: 5hrs 0mins
Name
Class
Date
1.
A database object that is used to organize and display data from tables and queries.
a)
report
b)
Report Wizard
c)
record source
d)
Field List pane
2.
The table or query that provides the data used to generate a report.
a)
Report Wizard
b)
Detail
c)
record source
d)
Find command
3.
Guides you through a series of questions and then generates a report based on your answers.
a)
Find command
b)
Sort
c)
Report Wizard
d)
Report
4.
A list of available fields for adding to a report.
a)
report
b)
Field List pane
c)
design grid
d)
Detail
5.
The section of a report that includes the body of the report.
a)
theme
b)
record source
c)
Detail
d)
Field List pane
6.
A predefined format that you can apply to any report in Layout view.
a)
theme
b)
Find command
c)
report
d)
Report Wizard
7.
organizes data in a particular order.
a)
Report Wizard
b)
Field List pane
c)
Sort
d)
record source
8.
displays data that meets the criteria you have specified and hides the rest.
a)
report
b)
theme
c)
Find command
d)
Filter
9.
the way a report is displayed in Design view.
a)
Find command
b)
design grid
c)
Filter
d)
report
10.
locates data in an open object like a table, query, or report.
a)
Find command
b)
design grid
c)
record source
d)
Detail
11.
A simple report contains all the records in a table or query.
a)
TRUE
b)
FALSE
12.
You can edit the data in a report.
a)
TRUE
b)
FALSE
13.
Click the Report button to define a record source.
a)
TRUE
b)
FALSE
14.
In the Report Wizard, you can skip steps such as Sorting or Grouping by clicking the Next button.
a)
TRUE
b)
FALSE
15.
You can drag a field from the Field List pane to the design grid to add it to the report.
a)
TRUE
b)
FALSE
16.
Layout view gives you the most options for creating a report, because it shows you the underlying structure of the report.
a)
TRUE
b)
FALSE
17.
In Report Design view, you can click on the top of the border of a label to move both the field and its label.
a)
TRUE
b)
FALSE
18.
You can save a filter with a report.
a)
TRUE
b)
FALSE
19.
You can use the Group, Sort, and Total pane to specify sort order or view the results of sorting using the shortcut menu.
a)
TRUE
b)
FALSE
20.
The Toggle Filter button removes a filter permanently.
a)
TRUE
b)
FALSE
100 %
