WorksheetsAccess Unit Review Part 2
Total questions: 20
Worksheet time: 10mins
Name
Class
Date
1.
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
b)
Criteria
c)
Order
d)
Sort
2.
To omit duplicates from a query, use the property sheet and change the Unique Values property to _____.
a)
No
b)
Yes
c)
Off
d)
On
3.
Use a query to _____ tables; that is, to find records in two tables that have identical values in matching fields.
a)
combine
b)
concatenate
c)
interleave
d)
join
4.
A(n) ____ join is the default join in Access.
a)
left outer
b)
right outer
c)
outer
d)
inner
5.
To display the Join Properties dialog box, right-click the join line and click ____ on the shortcut menu.
a)
Properties
b)
Property Sheet
c)
Join Properties
d)
Modify Properties
6.
To use the Report Wizard to create a report for a query, select the query in the Navigation Pane, click _____ on the Ribbon, and then click the Report Wizard button.
a)
New Report
b)
Create
c)
Query Report
d)
Save as Report
7.
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
b)
Database Tools
c)
Create
d)
Office Export
8.
To use the Expression Builder to create a calculated field, select the column in the Field row, right-click to display the shortcut menu, and then click ____.
a)
Expression Builder
b)
Builde box
c)
Build
d)
Field Builder
9.
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 (:)
b)
semi-colon (;)
c)
equal sign (=)
d)
exclamation point (!)
10.
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
b)
Resize
c)
Magnify
d)
Zoom
11.
You can include ____ in calculations to indicate which calculation should be done first.
a)
french brackets {}
b)
brackets []
c)
parenthese ()
d)
slashes //
12.
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
b)
Property Sheet
c)
Field Name
d)
Format
13.
To include the Total row in the design grid, click the _____ button on the Design tab.
a)
Aggregate
b)
Statistics
c)
Calculations
d)
Totals
14.
To find the largest amount paid amount for a client, select _____ as the entry in the Total row for the Amount Paid column.
a)
Large
b)
Maximum
c)
LGE
d)
MAX
15.
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
b)
Where
c)
Same
d)
Group By
16.
To indicate grouping in Access, select _____ as the entry in the Total row for the field to be used for grouping.
a)
Like
b)
Where
c)
Same
d)
Group By
17.
To create a crosstab, click the ____ button on the Create tab.
a)
Crosstab Wizard
b)
Query Wizard
c)
Statistics
d)
Chart
18.
To show the Navigation Pane if it is hidden, click the ____ Button.
a)
Show
b)
Shutter Bar Open/Close
c)
Restore
d)
Show/Hide
19.
To organize entries in the Navigation Pane by table, click ____ on the Navigation Pane menu.
a)
Object by Table
b)
Table Object
c)
Tables and Related Views
d)
Default
20.
To quit Access, click the ____ button on the right side of the Access title bar.
a)
Quit
b)
Close
c)
Stop
d)
Exit
100 %
