NEW
Font size
S
M
L
XL
WorksheetsAccess - Lesson 10
Total questions: 10
Worksheet time: 5mins
Name
Class
Date
1.
Aaron needs to duplicate a field that is used in his customer table in the business database for a new form he is creating for entering customer orders. Which item from the tools group would enable him to perform this operation?
a)
Tab Order
b)
Add Existing Fields
c)
View Code
d)
Property Sheet
2.
Sally is the National Technical Honor Society president. She is creating a database to manage her membership information. What form tool could she use to quickly create a set of tabs a user could click to access forms and reports in the database?
a)
Form View
b)
Layout View
c)
Design View
d)
Navigation Form
3.
Cathy needs to duplicate a column that is used in her spring sports table in the athletic database for a new form she is creating for fall sports. Which item from the tools group would enable her to perform this operation?
a)
Tab Order
b)
Add Existing Fields
c)
View Code
d)
Property Sheet
4.
Susie has a relational database for her catering business. She wants to create a form which shows the data in a customer table one record at a time. This type of form is a:
a)
main form
b)
subform
c)
hierarchical form
d)
datasheet
5.
When you use the Multiple Items tool, the form that Access creates resembles a
a)
control
b)
datasheet
c)
filter
d)
query
6.
A split form shows your data in which views?
a)
Form view and Datasheet view
b)
Layout view and Design view
c)
Form view and Design view
d)
Layout view and Datasheet view
7.
Susie has a relational database for her catering business. She wants to create a form which shows the customer information at the top and any orders for that customer at the bottom. The orders section of the form is a:
a)
main form
b)
subform
c)
hierarchical form
d)
datasheet
8.
Amy would like to quickly create a form in layout view so that she can easily modify contents and formatting. Which option uses layout view and gives the user greater control over the form's appearance while displaying the data?
a)
Blank form
b)
Form Design
c)
Form Wizard
d)
Form Tool
9.
Which type of form allows you to view data from more than one table or query on the same form?
a)
Multi-item form
b)
Split form
c)
Subform
d)
Navigation form
10.
A form/subform combination is sometimes referred to as a
a)
hierarchical form
b)
master/detail form
c)
parent/child form
d)
All of them
Reset
