Unlock document.
This document is partially blurred.
Unlock all pages and 1 million more documents.
Get Access
Exam
Name___________________________________
MULTIPLE CHOICE. Choose the one alternative that best completes the statement or answers the question.
1)
Which criterion is correct for writing a parameter query?
1)
A)
<(price should be below)
B)
price is <?
C)
<[price should be below]
D)
<price is less than>
2)
Which of the following is an incorrect use of wildcard characters?
2)
A)
Like “*Management*”
B)
Like “*Management”
C)
Like “#i*”
D)
Like “?i*”
3)
Which of the following statements is false regarding Access queries?
3)
A)
The top row is where the table name is displayed.
B)
The last row is for “or” criteria to be typed.
C)
QBE is a format where a user can specify what is desired without having to write computer
code to retrieve records from the database.
D)
The third row provides an option of sorting the results.
4)
The correct method of writing a query so that the results produce the prices that are greater than or
equal to $50 but less than or equal to $75 is:
4)
A)
>=50 Or <=75.
B)
>$50 And <$75.
C)
>=50 And <=75.
D)
>=$50 And <=$75.
5)
Which of the following is not a method for creating a query?
5)
A)
double-clicking Create query by using wizard
B)
double-clicking Create query in design view
C)
clicking the New button on the toolbar
D)
double-clicking Create query in table view
SHORT ANSWER. Write the word or phrase that best completes each statement or answers the question.
6)
Without the ________ between the tables, the query does not restrict itself to records that
match.
6)
7)
The ________ is a wildcard that matches any value or string of values, even a null value.
7)
8)
Sometimes a decision maker will know which ________ constrains a query but not know
the value of the constraint.
8)
9)
A ________ is a wildcard match for a single character.
9)
10)
When using ________ in a query in which there is no matching value between the tables,
the records with no match are not displayed in the query results.
10)
TRUE/FALSE. Write 'T' if the statement is true and 'F' if the statement is false.
11)
To see the results of a query, choose View, then choose Datasheet View.
11)
12)
Constraints on fields containing text can be difficult to create because what constitutes a match
might be ambiguous.
12)
13)
Action queries let the user provide a value as the query runs.
13)
14)
Typing <75 or >100 in the Criteria row is the correct use of the OR query in QBE.
14)
15)
Data is the essential tool of a decision maker.
15)
ESSAY. Write your answer in the space provided or on a separate sheet of paper.
16)
What do managers use queries for?
17)
Give an example of a computation.
18)
Why is it important for decision makers to be able to generate their own queries?
19)
Give an example of why a decision maker would use a parameter query.
20)
What is data field concatenation?
3
