NEW
Font size
S
M
L
XL
WorksheetsIT150 Chapter 7
Total questions: 26
Worksheet time: 13mins
Name
Class
Date
1.
A(n) ________ displays data in two views: From view and Datasheet view on a single form.
a)
split form
b)
main form
c)
dual form
d)
subform
2.
A split form displays data in which two views?
a)
Layout view and Design view
b)
Design view and Form view
c)
Form view and Layout view
d)
Datasheet view and Form view
3.
All split form properties can be changed in
a)
Form view
b)
Datasheet view
c)
Design view
d)
Layout view
4.
Which property needs to be set to specify an exact height or width in a split form?
a)
Split Form Datasheet
b)
Split Form Orientation
c)
Split Form Splitter Bar
d)
Split Form Size
5.
Which property needs to be set to allow edits in the datasheet section?
a)
Split Form Orientation
b)
Split Form Size
c)
Split Form Splitter Bar
d)
Split Form Datasheet
6.
The Split Form Printing property can be set in which view(s)?
a)
Design view and Form view
b)
Datasheet view or Form view
c)
Form view and Layout view
d)
Layout view or Design view
7.
When you point to a picture in the form section of the split form the Mini toolbar displays all of the following options EXCEPT
a)
Manage Attachments button
b)
Rotate Picture button
c)
Forward button
d)
Back button
8.
To delete a field from a split form you must delete it from the
a)
form section
b)
form section or datasheet section
c)
datasheet section
d)
layout section
9.
Adding a sum to a field in the subreport causes the sum to display
a)
in the subreport control on the subform
b)
in the main report control on the subform
c)
in the main report control on the main form
d)
in the subreport control on the main form
10.
The Split Form Datasheet property can be set in which view(s)?
a)
Form view only
b)
Design view only
c)
Datasheet view or Form view
d)
Layout view or Design view
11.
The two views in a split form display data
a)
from one source file and are synchronized with each other every five minutes
b)
from two different source files and are synchronized with each every five minutes
c)
from two different source files and are synchronized with each other at all times
d)
from one source file and are synchronized with each other at all times
12.
Which of the following statements is true?
a)
The default for a split form orientation is Datasheet on Top
b)
The default for a split form orientation is Datasheet on Bottom
c)
The default for a split form orientation is Datasheet to the Right
d)
The default for a split form orientation is Datasheet to the Left
13.
A ________ is a miniature semitransparent toolbar that is used to work with objects on the screen.
a)
floating toolbar
b)
navigation pane
c)
transparent toolbar
d)
mini toolbar
14.
The ________ defines whether the datasheet displays above below to the left or to the right of the form when using split form.
a)
Split Form Datasheet
b)
Split Form Orientation
c)
Split Form Splitter Bar
d)
Split Form Size
15.
A ________ is a form that is embedded within another form the main form and is used to view enter and edit data that is related to data in the main form.
a)
linked form
b)
split form
c)
subform
d)
subdatasheet
16.
In a(n) ________ relationship one record in either table can relate to many records in the other table.
a)
many-to-one
b)
one-to-one
c)
many-to-many
d)
one-to-many
17.
A ________ is used to break down many-to-many relationships into two one-to-many relationships.
a)
connection table
b)
divider table
c)
junction table
d)
relationship table
18.
A ________ is a related form that is not stored within the main form.
a)
linked form
b)
split form
c)
subreport
d)
subform
19.
The Split Form Size property can be set in the following view(s)
a)
Layout view only
b)
Form view Design view and Layout view
c)
Design view and Form view
d)
Design view and Layout view
20.
You can have a maximum of ________ levels of subforms.
a)
ten
b)
seven
c)
five
d)
three
21.
A main report can contain up to ________ levels of subforms and subreports.
a)
seven
b)
three
c)
ten
d)
five
22.
________ is a way to apply formatting to specific controls based on a comparison to a rule set in the New Rule dialog box.
a)
Comparison formatting
b)
Syntax
c)
Conditional formatting
d)
Control formatting
23.
________ is one way to highlight an entry that might require additional action based on a comparison to a rule set.
a)
Control formatting
b)
Conditional formatting
c)
Syntax
d)
Comparison formatting
24.
________ are subforms that are contained in other subforms instead of the main form.
a)
Integrated forms
b)
Nested subforms
c)
Linked subforms
d)
Split forms
25.
A ________ displays the data from underlying table or query on more than one page.
a)
linked form
b)
split form
c)
multi window form
d)
multi-page form
26.
To convert an existing form to a split form the form must be open in
a)
Layout view
b)
Form view
c)
Datasheet view
d)
Design view
Reset
