Name:     ID: 
 
Email: 

Access Chapter Two

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

 1. 
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
 

 2. 
You can enter BC76 in the ____ row of the Client Number field to find all clients whose client number is BC76.
a.
Sort
c.
or
b.
Show
d.
Criteria
 

 3. 
You can remove a column by clicking just above the field name to select the column and then clicking the ____ key(s).
a.
CTRL + DELETE
c.
DELETE
b.
CTRL + Y
d.
CTRL+ALT
 

 4. 
To save a query, click the Save button on the ____.
a.
Quick Access Toolbar
c.
Create tab on the Ribbon
b.
Home tab on the Ribbon
d.
status bar
 

 5. 
To view the results of a query, open it by right-clicking the query in the Navigation Pane and clicking ____ on the shortcut menu.
a.
Datasheet View
c.
Run
b.
Design View
d.
Open
 

 6. 
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
 

 7. 
To find all clients whose names begin with Gr, enter _____ in the Criteria row of the Client Name field.
a.
Gr..
c.
Gr*
b.
Gr?
d.
Gr&
 

 8. 
To find all individuals whose name is Francis or Frances, enter ____ in the Criteria row of the appropriate column.
a.
Franc?s
c.
Franc#s
b.
Franc*s
d.
Franc%s
 

 9. 
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 ‘’
 

 10. 
To find all clients whose current due amount is greater than $1,000.00, erase the 0 and enter _____ in the Criteria row of the Current Due column.
a.
> $1000
c.
> 1,000
b.
> 1000
d.
> $1,000
 

 11. 
The criterion for Current Due is 0. To find all clients whose current due amount is $2,000.00, erase the 0 in the Current Due column and enter _____ in the Criteria row of the Amount Paid column.
a.
=2,000
c.
=$2,000
b.
2,000
d.
2000
 

 12. 
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
 

 13. 
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
 

 14. 
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
 

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

 16. 
To display the Join Properties dialog box, right-click the join line and click ____ on the shortcut menu.
a.
Properties
c.
Property Sheet
b.
Join Properties
d.
Modify Properties
 

 17. 
To export data from a query to Excel, select the query in the Navigation Pane, click _____ on the Ribbon, and then click the Excel button.
a.
External Data
c.
Create
b.
Database Tools
d.
Office Export
 

 18. 
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.
Resize
d.
Zoom
 

 19. 
To change the caption for a field in a query, click the field in the design grid, click the _____ button on the Design tab, click the Caption box, and enter the new caption.
a.
Caption
c.
Field Name
b.
Property Sheet
d.
Format
 

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



 
         Start Over