3610.003 BCIS Access Quiz 3
7/2/2009 Sum I
Name: _________________________________
Student ID: _______________________
Identify the choice that best completes the statement or answers the question.
____
1. To modify the design of a table, right-click the table in the Navigation Pane, and click _____ on the shortcut
menu.
a. Modify Table
c. Design View
b. Change Table
d. Modify View
____
2. By default, Access disables macros when it opens a database and displays a Security Warning.
a. True
b. False
____
3. The _____ data type is used for a field that contains text that is variable in length and that can potentially be
very lengthy.
a. Variable
c. VarChar
b. Attachment
d. Memo
____
4. In the JSP Recruiters database the Client Financial Form, Client Number BH72 shows an Amount Paid is:
a. $0.00
c. $17,500.00
b. $29,200.00
d. $12,500.00
____
5. In the Second Hand Goods database, the Master Seller Form shows that Seller MT has ____ items sold.
a. 0
c. 2
b. 1
d. 3
____
6. An input specifies mask how data is to be entered and how it will appear.
a. True
b. False
____
7. If the primary key of the Seminar Offerings table contains the primary key for both the Client table and
Seminar table, there is a _____ relationship between clients and seminars.
a. one-to-one
c. many-to-one
b. one-to-many
d. many-to-many
____
8. To relate tables, click the _____ button on the Database Tools tab.
a. Relate Tables
c. Referential Integrity
b. Relationships
d. Show Tables
____
9. In the Second Hand Goods database there are _____ macros contained in the SHG Macros group.
a. 3
c. 5
b. 4
d. 6
____ 10. In the Second Hand Goods database, the relationship between Seller and Item is:
a. one-to-one
c. many-to-one
b. one-to-many
d. many-to-many
Access Quiz 3
Answer Section
MULTIPLE CHOICE
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
ANS:
ANS:
ANS:
ANS:
ANS:
ANS:
ANS:
ANS:
ANS:
ANS:
C
A
D
B
C
A
D
B
D
B
PTS:
PTS:
PTS:
PTS:
PTS:
PTS:
PTS:
PTS:
PTS:
PTS:
1
1
1
1
1
1
1
1
1
1
REF: AC 302
REF: AC 392