Vocabulary
Sections
Reports
Formatting
Miscellaneous
100
Enhancing the appearance of information displayed in the report.
What is formatting?
100
This determines where a control appears on the report and how often it prints.
What is section?
100
This is a tool that asks questions to guide you through the initial development of the report.
What is the report wizard?
100
An Access object used to create professional-looking printouts.
What is a report?
100
This appears at the end of the entire report.
What is the report footer?
200
A combination of field names, operators, and functions that result in a single value before and after the group records.
What is an expression?
200
Prints once for every record.
What is detail section?
200
This is the table or query that defines the fields and records displayed on the report.
What is the record source?
200
This property determines the color of the section background.
What is the back color?
200
Reports are this which means you cannot edit the data within the report.
What is read-only?
300
A built-in formula, such as count or sum that helps you quickly create a calculation.
What is a function?
300
This prints at the bottom of every page.
What is page footer section?
300
This view maximizes that amount of data you can see on the screen.
What is report view?
300
This changes the background color of alternate records in the selected sectin.
What is the alternate fill/back color button?
300
When an argument is a field name, the field name must be surrounded by these.
What are square brackets?
400
Pieces of information that the function needs to create the final answer.
What are arguments?
400
This prints after every group of records.
What is the group footer?
400
This is used to identify which fields and records are passed to the report.
What is the record source property?
400
In order for your report to print out on one page, then you may need to change this.
What are margins (or page orientation)?
400
In an expression, the arguments for the function are placed in these.
What are parentheses?
500
Sorting records plus providing a section.
What is grouping?
500
In this section, text box controls for the field by which the records are grouped are commonly placed here.
What is the group header section?
500
Sorting records plus providing a section.
What is grouping?
500
To select more than one control in Report Design View, you need to hold this key.
What is shift?
500
This is the expression needed to find the average of the values in the salary field.
What is =Avg([Salary])?
Continue
ESC
Reveal Correct Response
Spacebar
M
e
n
u
Team 1
0
+
-
Access Unit D
No teams
1 team
2 teams
3 teams
4 teams
5 teams
6 teams
7 teams
8 teams
9 teams
10 teams
Custom
Press
F11
Select menu option
View > Enter Fullscreen
for full-screen mode
Edit
•
Print
•
Download
•
Embed
•
Share
JeopardyLabs