BIS 245 chapter 4 quiz week 6 | Devry University
- Devry University / BIS 245
- 11 Aug 2021
- Price: $5
- Computer Science Assignment Help / Microsoft Office Assignment Help
BIS
245 chapter 4 quiz week 6 | Devry University
Question
1
What
is a text box that gets its value from an expression?
A. bound control
B. unbound control
C. calculated control (correct)
D. stacked control
Question 2
Which
of the following form controls is used to perform an action such as Close Form,
Open Form, Delete Record, and so on?
A. text box
B. label
C. button (correct)
D. check box
Question
3
Which
of the following form controls is used to display or accept data for a field
with a Yes/No data type?
A. text box
B.
label
C.
button
D.
check
box (correct)
Question
4
What
does Access call a form that is directly connected to a table or query, the
source of the data?
A. bound form (correct)
B.
connected
form
C.
unbound
form
D.
split
form
Question
4
Which
of the following report layouts displays fields in one column?
A. Columnar (correct)
B.
Tabular
C.
justified
D.
stepped
Question
5
When
creating a form using the Form Wizard, which of the following layout options
would you use to display the fields in a table (row and column) format?
A. Columnar
B.
Tabular
(correct)
C.
Datasheet
D.
Justified
Question
6
Which
of the following report layouts displays fields in a horizontal layout?
A. Columnar
B.
Tabular
C.
justified
D.
steppedDone (correct)
Question
7
Which
of the following would you change in order to view a report using a landscape
orientation?
A. page size
B.
margins
C.
page
orientation (correct)
D.
headers
and footersDoniee
Question
8
Which
of the following grouping options is used to group records based on the entire
value in a selected field?
A. By entire value (correct)
B.
By
partial value
C.
Custom
D.
Ascending
or descending sortDone
Question
9
Which
of the following form properties determines whether a form is restricted to
data entry?
A. Allow Edits property
B.
Allow
Deletions property
C.
Data
Entry property (correct)
D.
Allow
Edits propertyDone
Question
9
In
addition to selecting the rule type and conditions, what else must you select
when building a conditional formatting rule?
A. command buttons
B.
bound
controls
C.
a
control layout
D.
desired
formattingDone (correct)
Question
10
Which
of the following should you use to create a report if you are short on time?
A. Report view
B.
Report
Wizard (correct)
C.
Report
Layout
D.
Report
DesignDone
Question
11
Which
of the following is true about blank reports?
A. They use the tabular layout.
B.
They
use the stacked layout.
C.
They
don't contain any controls. (correct)
D.
The
header area contains a default title.Done
Question
12
Which
of the following is not an option in the Page Numbers dialog box?
A. Page Number Format (correct)
B.
Page
Number Position
C.
Page
Number Alignment
D.
Page
Number FontDone
Question
13
Which
of the following controls can print the current form, close the current form,
navigate to the next record, or open another form?
A. text box
B.
label
C.
command
button (correct)
D.
check
box
Question
14
Which
of the following options in the Group, Sort, and Total Pane calculates overall
totals for all records?
A. Select the field and type of
calculation
B.
Show
grand totals (correct)
C.
Show
group totals as percent of grand total
D.
Show
in header or footer section
Question
15
Which
of the following enables you to format only values that meet a certain
condition?
A. Rules Manager
B.
Conditional
formatting (correct)
C.
Text
Formatting group
D.
Report
formatting
Question
15
Which
of the following report views shows how the report will look in print and enable
you to make modifications to the print settings?
A. Report view
B.
Print
Preview view (correct)
C.
Design
view
D.
Layout
view
Question
16
Which
of the following creates a button and attaches all the necessary functionality
to the button?
A. Conditional Formatting Rules
Manager
B.
Control
layouts
C.
Property
Sheet
D.
Command
Button Wizard (correct)
Question
17
When
using multiple conditional formatting rules, which of the following statements
is true?
A. The order of the rules is
unimportant.
B.
The
order of the rules is important. (correct)
C.
Access
continues to evaluate rules after a match is found.
D.
You
cannot select multiple fields and apply the same rule to all the selected
fields.
Question
18
Which
of the following report views divides a report into the following three
sections: Page Header, Detail, and Page Footer?
A. Report view (correct)
B.
Print
Preview view
C.
Design
view
D.
Layout
view