Exam
Name___________________________________
MULTIPLE CHOICE. Choose the one alternative that best completes the statement or answers the question.
1)
Which of the following is not a choice in the Join Properties dialog box when the table names are
CLASS and INTERSECTION?
1)
A)
Only include rows from ‘CLASS’ where the joined fields from both tables are equal.
B)
Include ALL records from ‘CLASS’ and only those records from ‘INTERSECTION’ where the
joined fields are equal.
C)
Only include rows where the joined fields from both tables are equal.
D)
Include ALL records from ‘INTERSECTION’ and only those records from ‘CLASS’ where the
joined fields are equal.
2)
The function used to replace an index with a set of values is the:
2)
A)
choose function.
B)
index function.
C)
unbound function.
D)
properties function.
A
3)
To edit a relationship between two tables:
3)
A)
double–click on the relationship line and click Join.
B)
right–click on the relationship line and click Join Properties.
C)
click the relationship button on the toolbar and choose Properties.
D)
click on the relationship line and click Join Properties.
B
4)
Which of the following is the correct format to take the fourth character from within a text field?
4)
A)
Level:Mid([CLASS.ClassNumb],4,1)
B)
Level:Mid(CLASS.ClassNumb,4,1)
C)
Level:Mid$[CLASS.ClassNumb,4,1]
D)
Level:Mid$([CLASS.ClassNumb],4,1)
D
A
5)
Which statement is false regarding reports?
5)
A)
The understanding of the database gained by writing queries trains a decision maker to use
that tool better.
B)
Creating reports based upon query results is valuable so that the decision maker can produce
documents for his or her subordinates.
C)
Data is the essential tool of a decision maker.
D)
Reports based on query results must usually be modified to create visually appealing reports.
SHORT ANSWER. Write the word or phrase that best completes each statement or answers the question.
6)
There may be many ________ in a database, they are all contained in the single database
file.
6)
7)
Reporting unmatched records is achieved by editing the ________ between tables.
7)
8)
When the query is run, the results are displayed, but the ________ of the parameter is not
reported.
8)
9)
It is more difficult to capture values entered in a ________ query to be displayed in a
report.
9)
10)
Decision makers may wish to limit the information in a report by using a ________ query.
10)
TRUE/FALSE. Write ‘T’ if the statement is true and ‘F’ if the statement is false.
11)
Using the Join option can modify relationships between tables.
11)
12)
Reporting unmatched records is achieved by editing the tables to create a match.
12)
13)
Reports based on query results must usually be modified from the default report settings to create
visually appealing reports.
13)
14)
Mid$ is a function in Access to take values from within a text field.
14)
15)
Fields from different tables can be combined when a common value exists between the tables.
15)
ESSAY. Write your answer in the space provided or on a separate sheet of paper.
16)
How can users reverse mistakes in the database?
17)
What can be used to change the content of a report?
18)
Why should a parameter value be placed in a title?
19)
What is the Mid$ function?
20)
Managers often need to generate what based on the results of queries?
3