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 should be below]
C)
<price is less than>
D)
price is <?
2)
Which of the following statements is false regarding Access queries?
2)
A)
QBE is a format where a user can specify what is desired without having to write computer
code to retrieve records from the database.
B)
The last row is for “or” criteria to be typed.
C)
The top row is where the table name is displayed.
D)
The third row provides an option of sorting the results.
3)
Which of the following is an incorrect use of wildcard characters?
3)
A)
Like “*Management*”
B)
Like “*Management”
C)
Like “?i*”
D)
Like “#i*”
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)
clicking the New button on the toolbar
C)
double-clicking Create query in table view
D)
double-clicking Create query in design view
SHORT ANSWER. Write the word or phrase that best completes each statement or answers the question.
6)
It is important for ________ to be able to generate their own queries.
6)
7)
________ is an essential decision-making tool.
7)
8)
Access uses two characters as ________ in the matching of text fields.
8)
9)
________ on fields containing text can be difficult to create because what constitutes a
match may be ambiguous.
9)
10)
________ queries let a user provide a value as the query runs.
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)
Typing <75 or >100 in the Criteria row is the correct use of the OR query in QBE.
12)
13)
Data is the essential tool of a decision maker.
13)
14)
Constraints on fields containing text can be difficult to create because what constitutes a match
might be ambiguous.
14)
15)
Action queries let the user provide a value as the query runs.
15)
ESSAY. Write your answer in the space provided or on a separate sheet of paper.
16)
What trains a decision maker to use information better?
17)
Why is it important for decision makers to be able to generate their own queries?
18)
How can you copy an entire database in Access?
19)
What do queries that require more than one table require?
20)
How do you remove duplicate names in the query results?
3
