8. What is QBE?
A. Quick Blank Example: a quick new template
B. Query Back Empty: returns any blank fields
C. Question Bank Effect: creates sample question to help in designing a
Query
D: Query By Example: a visual format for programming
Tip: Beginning Access, page 164
4. Which
Query commands change the data?
(Give all
correct answers.)
A. Select
B. Cross Tab
C. Append
D. Update
E. Delete
Tip: Beginning Access, page 165
5. To add a field in Query Design mode, double-click the Field name in
the Data Source box above the QBE Grid.
A. True
B. False
Tip: Beginning Access, page 172
6. When you Run a Query, it displays the results based on the fields and
any criteria programmed.
A. True
B. False
Tip: Beginning Access, page 167, 170
7. Any change to a Query should be tested to make sure it works as
desired.
A. True
B. False
Tip: Beginning Access, page 176
1. Which are
templates in the Query Wizard?
(Give all
correct answers.)
A. Simple Query Wizard
B. Crosstab Query Wizard
C. Find Duplicates Query Wizard
D. Find Unmatched Query Wizard
Tip: Beginning Access, page 157
2. Queries have which of the following views?
(Give all
correct answers.)
A. Datasheet
B. PivotTable
C. PivotChart
D. SQL View
E. Design View
Tip: Beginning Access, page 163
3. Which Query commands show data?
(Give all
correct answers.)
A. Select
B. Cross Tab
C. Append
D. Update
E. Delete
Tip: Beginning Access, 165
