Name:     ID: 
 
Email: 

COSC 4325  Chap 2

True/False
Indicate whether the statement is true or false.
 

 1. 
Only the fields that appear in the design grid are included in the results of the query.
 

 2. 
The asterisk (*) wildcard represents any collection of characters.
 

 3. 
The question mark (?) wildcard represents any collection of characters.
 

 4. 
To find all clients whose names begin with Be, enter Be? in the Criteria row of the design grid.
 

 5. 
To enter a criterion for a particular field without displaying the field in the results of the query, include the field in the design grid, enter the criterion, and remove the check mark from its Show check box.
 

 6. 
A query that prompts for input whenever it is run is a run-time query.
 

 7. 
You create a parameter by enclosing a value in a criterion in curly braces ({}).
 

 8. 
To run a saved query, right-click the query in the Navigation Pane and click Open on the shortcut menu.
 

 9. 
To enter a number in a criterion, type the number without any dollar signs or commas.
 

 10. 
To search for a range of values in one field, use the RANGE operator.
 

 11. 
To find all clients whose amount paid is greater than $20,000.00 AND whose recruiter is recruiter 21, enter each criterion on the same line.
 

 12. 
To find all clients whose amount paid is greater than $20,000.00 OR whose recruiter is recruiter 21, enter each criterion on the same line.
 

 13. 
If you specify more than one sort key, the sort key on the left will be the minor sort key and the one on the right will be the major sort key.
 

 14. 
When you sort data, duplicates normally are included.
 

 15. 
When tables are joined in a query, it is not possible to restrict retrieval by using criteria.
 

 16. 
The expression for a calculated field can be typed directly into the Field row.
 

 17. 
A field name used in a calculation always must be enclosed in square brackets.
 

 18. 
Grouping means creating groups of records that share some common characteristic.
 

 19. 
Parameter queries are useful for summarizing data.
 

Multiple Choice
Identify the choice that best completes the statement or answers the question.
 

 20. 
If a Security Warning appears when you open a database, click the ____ button to display the Microsoft Office Security Options dialog box.
a.
Customize
c.
Security
b.
Options
d.
Warning
 

 21. 
To use the Simply Query wizard to create a query, click the ____ tab on the Ribbon and then click the Query Wizard button.
a.
Design
c.
Database Tools
b.
Home
d.
Create
 

 22. 
To change the design of a query, right-click the query and then click ____ on the shortcut menu.
a.
Datasheet View
c.
Open
b.
Design View
d.
Change
 

 23. 
To print a query without first opening it, select the query in the Navigation Pane and then click the Office Button, point to Print on the Office Button menu, and then click ____ on the Print submenu
a.
Quick Print
c.
Preview Query
b.
Print Query
d.
Run and Print
 

 24. 
You can click either the View button or the ____ button on the Ribbon to execute a query.
a.
Run
c.
Select
b.
Execute
d.
Results
 

 25. 
To create a new query in Design view, click Create on the Ribbon to display the Create tab and then click the ____ button to create a new query.
a.
Query
c.
Query Design
b.
Design View
d.
Select Query
 

 26. 
To find all individuals whose name is Tom or Tim, enter ____ in the Criteria row of the appropriate column.
a.
T?m
c.
T$m
b.
T#m
d.
T&m
 

 27. 
To create a parameter query, enter a parameter rather than a specific value as a criterion in the design grid. The parameter must be enclosed in _____.
a.
curly braces { }
c.
parentheses ( )
b.
square brackets [ ]
d.
single quotes ‘’
 

 28. 
To use a saved query, right-click the query in the Navigation Pane and then click ____ on the shortcut menu.
a.
Use
c.
Run
b.
Manipulate
d.
Open
 

 29. 
Less than (<), greater than (>), and NOT (not equal to) are examples of _____.
a.
compound conditions
c.
compound values
b.
comparison operators
d.
conditions
 

 30. 
The ____ operator allows you to search for a range of values in one field.
a.
BETWEEN
c.
IN
b.
RANGE
d.
SEARCH
 

 31. 
To order the records in the answer to a query in a particular way, you ____ the records.
a.
index
c.
arrange
b.
sort
d.
list
 

 32. 
To sort records in a query, specify the sort order in the _____ row of the design grid below the field that is the sort key.
a.
Show
c.
Order
b.
Criteria
d.
Sort
 

 33. 
To omit duplicates from a query, use the property sheet and change the Unique Values property to _____.
a.
No
c.
Off
b.
Yes
d.
On
 

 34. 
Use a query to _____ tables; that is, to find records in two tables that have identical values in matching fields.
a.
combine
c.
merge
b.
concatenate
d.
join
 

 35. 
To include calculated fields in queries, enter a name for the calculated field, a(n) _____, and then the expression in one of the columns in the Field row.
a.
colon (:)
c.
equal sign (=)
b.
semi-colon (:)
d.
exclamation point (!)
 

 36. 
To display the entire entry for a calculated field, select the column in the Field row, right-click to display the shortcut menu, and then click ____.
a.
Enlarge
c.
Magnify
b.
Zoom
d.
Resize
 

 37. 
You can include ____ in calculations to indicate which calculation should be done first.
a.
curly braces {}
c.
parentheses ()
b.
brackets []
d.
slashes //
 

 38. 
To include the Total row in the design grid, click the _____ button on the Design tab.
a.
Aggregate
c.
Calculations
b.
Statistics
d.
Totals
 

 39. 
To find the average amount paid amount for a client, select _____ as the entry in the Total row for the Amount Paid column.
a.
AVG
c.
VAR
b.
Average
d.
Median
 

 40. 
To calculate statistics for only those records that satisfy certain criteria, select ____ as the entry in the Total row for the field, and then enter the criterion in the Criteria row.
a.
Having
c.
Restrict
b.
Where
d.
Find
 

 41. 
To indicate grouping in Access, select _____ as the entry in the Total row for the field to be used for grouping.
a.
Group By
c.
Same
b.
Where
d.
Like
 

 42. 
To create a crosstab, click the ____ button on the Create tab.
a.
Crosstab
c.
Statistics
b.
Query Wizard
d.
Chart
 

 43. 
To show the Navigation Pane if it is hidden, click the ____ Button.
a.
Show
c.
Restore
b.
Shutter Bar Open/Close
d.
Show/Hide
 

 44. 
To organize entries in the Navigation Pane by table, click ____ on the Navigation Pane menu.
a.
Objects by Table
c.
Tables and Related Views
b.
Table Object
d.
Default
 

 45. 
To quit Access, click the ____ button on the right side of the Access title bar.
a.
Quit
c.
Stop
b.
Exit
d.
Close
 

Completion
Complete each statement.
 

 46. 
If there are no restrictions involved in the query, nor any special order or calculations, you can use the ____________________ wizard.
 

 

 47. 
A(n) ____________________ is a condition that the records to be included in a query must satisfy.
 

 

 48. 
To find all clients whose names begin with Be, enter ____________________ as the criterion for the Client Name field.
 

 

 49. 
____________________ are symbols that represent any character or combination of characters.
 

 

 50. 
The ____________________ wildcard represents any collection of characters.
 

 

 51. 
The ____________________ wildcard represents any individual character.
 

 

 52. 
A(n) ____________________ query is a query that prompts for input whenever it is used.
 

 

 53. 
To find all clients whose amount paid is more than $20,000.00, use the ____________________ operator.
 

 

 54. 
To sort records by amount paid within recruiter number, specify Recruiter Number as the ____________________ key.
 

 

 55. 
____________________ joins are used to show all the records in one table as well as the common records; that is, the records that share the same value in the join field.
 

 

 56. 
If two tables have matching fields, that is, fields with the same name, Access draws a line called a(n) ____________________ line between the matching fields to indicate that the tables are related.
 

 

 57. 
____________________ properties are the properties that indicate which records appear in a join.
 

 

 58. 
The ____________________ is an Access tool that helps you create complex expressions.
 

 

 59. 
The ____________________ function finds the largest value in a group of records.
 

 

Matching
 
 
Identify the letter of the choice that best matches the phrase or definition.
a.
*
f.
NOT
b.
?
g.
Return box
c.
/
h.
OR criterion
d.
Total
i.
Show
e.
AND criterion
j.
COUNT
 

 60. 

 Each individual criterion must be true in order for the compound criterion to be true.
 

 61. 

 Represents any collection of characters.
 

 62. 

 A comparison operator.
 

 63. 

 A mathematical operator for division.
 

 64. 

 Represents any individual character.
 

 65. 

 Either individual criterion must be true in order for the compound criterion to be true.
 

 66. 

 Row that displays in the design grid when aggregate functions are used.
 

 67. 

 An aggregate function.
 

 68. 

 Row that includes check boxes to control which fields appear in the query result.
 

 69. 

 Use to change the number of records to be included in query results.
 



 
         Start Over