PART I: MATCHING (4 pts
Select the term that BEST
corresponds to each definition presented below. Select only ONE
term for each definition. Indicate your selection by printing the
corresponding letter in the space provided. GOOD LUCK!
A. Data Validation
I. Find Command
K. Relational Database
L. Referential Integrity
M. Replace Command
N. Design View
1. ______ Indicates that
the user is working on the record and that changes have not yet been
2. ______ Answers a
question about a database.
3. ______ Presents the
data in a table or query in an attractive fashion on the printed page.
4. ______ Contains
multiple tables and enables the user to extract information from those
tables in a single query.
5. ______ Displays a
subset of records from the table according to a specified criteria.
6. ______ Anticipates
errors that the user might make and rejects them prior to accepting data.
7. ______ Assures that
data is consistent between related databases.
8. ______ A filter which
allows the user to select criteria from a drop-down list, and to apply
multiple criteria simultaneously.
9. ______ Used to automate
the performance of any repetitive task.
10. ______ Used to define
the table initially and to specify the fields it will contain.
Circle the letter
corresponding to BEST answer choice for each of the
questions presented below. Select only ONE answer for
each question. Make sure your final answer choices are clear.
11. To create a database
to organize the different college books that you must purchase, which of
the following is the BEST Microsoft program to use?
12. The symbol that represents
Microsoft Access is a:
13. A table consists of:
14. The database view is used to:
Add, Delete or Edit Records
Specify the fields that a table will contain
Initially define the table
Modify the table definition if changes are necessary
15. Which of the following is NOT
true about the open database command?
You can execute it from the file menu
You can click the open button on the database toolbar
It loads a database from disk into memory
It opens the selected table from the database view
16. The purpose of a table is to:
Present a document that can be posted on the internet
Present a document in a professional fashion so it can be printed
Store data about an entity
Answer a question about the database
17. The correct hierarchy of terms from
largest to smallest is:
field, record, table, database
record, table, database, field
database, table, field, record
database, table, record, field
18. The easiest way to implement a
filter that contains all the desired criteria is to apply a:
Filter by form
Filter by selection
Filter excluding selection
19. If you wanted to display records
from highest to lowest value, which one of the following commands would
20. Which of the following is true after
you have removed a filter?
All previously filtered records are again displayed
The filter is not deleted
All of the above
Only a) but not b)
21. A relational database must have at
least how many databases?
A relational database has no databases
22. How many queries are needed to
locate information in a relational database?
No queries are needed
23. Which of the following functions
(symbols) enables easy access to all related database of a single entry?
24. All of the following apply to data
Anticipates user error
Reject incorrect data prior to entry
Assures consistency between related databases
Is a crucial part of any system
25. The disadvantage of the undo command
is that it:
Only allows the reversal of the most recent command
Has no shortcut button on the toolbar
Not common to all Microsoft Office applications
Only applies to certain records
PART III: TRUE OR FALSE (3 pts each)
For the following sentences decide
whether the statement is true or false. Indicate your answer by
writing a T or F in the space provided next to each statement.
26. ______ The shortcut to the find
command button is represented on the toolbar by a lightning bolt.
27. ______ The most useful advantage of
filtering by selection is that the user can specify relationships within a
28. ______ Sort ascending is more
appropriate to use for numerical values than sort descending.
29. ______ A module provides a greater
degree of automation.
30. ______ A triangle indicates that the
record has been saved to disk.
to Main Page