WorksheetsACCESS CHAPTER 2 - Study Guide Mar22
Total questions: 20
Worksheet time: 11mins
A question that is asked of Access or any other database management system is called a(n) '
(a)
To include the Total row in the design grid, click the _____ button on the Design tab.
Totals
Aggregate
Statistics
Calculations
To show the Navigation Pane if it is hidden, click the ____ Button.
Restore
Show/Hide
Shutter Bar Open/Close
Show
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.
Property Sheet
Caption
Format
Field Name
To use a parameter query, right-click the query in the Navigation Pane and then click ____ on the shortcut menu.
Run
Enter Values
Use parameter
Open
To include all fields in the design grid, double-click the question mark (?) in the field list. ____________________
True
False
A(n) ____ join is the default join in Access.
left outer
outer
inner
right inner
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 ____.
Enlarge
Magnify
Resize
zoom
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 ____.
Expression Builder
Builder box
Field Builder
Build
You can include ____ in calculations to indicate which calculation should be done first.
curly braces {}
slashes//
brackets[]
parentheses()
To quit Access, click the ____ button on the right side of the Access title bar.
close
exit
quit
stop
To find all individuals whose name is Francis or Frances, enter ____ in the Criteria row of the appropriate column.
Franc#s
Franc%s
Franc*s
Franc?s
To indicate grouping in Access, select _____ as the entry in the Total row for the field to be used for grouping.
Group By
Like
Where
Same
Wildcards are symbols that represent any character or combination of characters. ____________________
True
False
You can delete a table by right-clicking the field list and clicking ____ on the shortcut menu.
Remove Table
Erase Table
Delete Table
Hide Table
Each individual criterion must be true in order for the compound criterion to be true.
OR Criterion
AND Criterion
Represents any collection of characters.
*
/
A comparison operator.
AND
NOT
A mathematical operator for division.
*
/
Either individual criterion must be true in order for the compound criterion to be true.
NOT criterion
OR criterion
