Access Chapter 2 Study Guide

10 September 2022
4.7 (114 reviews)
50 test answers

Unlock all answers in this set

Unlock answers (46)
question
To view the results of a query, open it by pressing and holding or right-clicking the query in the Navigation Pane and tapping or clicking ____ on the shortcut menu.
answer
Open
question
To save a query, tap or click the Save button on the ____.
answer
Quick Access Toolbar
question
To find the largest amount paid amount for a client, select ____ as the entry in the Total row for the Amount Paid column.
answer
MAX
question
To export data from a query to Excel, select the query in the Navigation Pane, tap or click ____ on the ribbon, and then tap or click the Excel button.
answer
EXTERNAL DATA
question
To create a new query in Design view, tap or click CREATE on the ribbon to display the CREATE tab and then tap or click the ____ button to create a new query.
answer
Query Design
question
In the accompanying figure, you can enter CSU10 in the ____ row of the Customer Number field to find all customers whose customer number is CSU10.
answer
Criteria
question
To find all customers whose current due amount is greater than $1,000.00, enter ____ in the Criteria row of the Current Due column.
answer
> 1000
question
To order the records in the answer to a query in a particular way, you ____ the records.
answer
sort
question
In the accompanying figure, you can delete the table by pressing and holding or right-clicking the field list and tapping or clicking ____ on the shortcut menu.
answer
Remove Table
question
In the accompanying figure, you can remove a column by tapping or clicking just above the field name to select the column and then tapping or clicking the ____ key(s).
answer
DELETE
question
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.
answer
colon (:)
question
In the accompanying figure, the Customer table was added to the query by selecting the table and tapping or clicking the Add button in the ____ dialog box.
answer
Show Table
question
To indicate grouping in Access, select ____ as the entry in the Total row for the field to be used for grouping.
answer
Group By
question
To change the design of a query that is not currently open, press and hold or right-click the query and then tap or click ____ on the shortcut menu.
answer
Design View
question
To print the results of a query that is open, tap or click FILE on the ribbon, tap or click the ____ tab in the Backstage view, and then tap or click Quick Print.
answer
Print
question
To create a crosstab, click the ____ button on the CREATE tab.
answer
Query Wizard
question
Less than (<), greater than (>), and NOT (not equal to) are examples of ____.
answer
comparison operators
question
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 ____.
answer
Zoom
question
In the accompanying figure, press and hold or right-click the join line and tap or click ____ on the shortcut menu to display the Join Properties dialog box.
answer
Join Properties
question
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 ____.
answer
square brackets [ ]
question
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 ____.
answer
Build
question
In the accompanying figure, the ____ line between matching fields in the two tables indicates that the tables are related.
answer
join
question
The ____ operator allows you to search for a range of values in one field.
answer
BETWEEN
question
In the accompanying figure, Amount Paid is the ____ key. a. primary sort b. major c. secondary sort d. minor
answer
C,D
question
To re-use saved export steps, tap or click the Saved Exports button on the ____ tab on the ribbon.
answer
EXTERNAL DATA
question
The special criteria that can be used in queries are ____. a. IN b. AND c. BETWEEN d. INCLUSIVE
answer
A,B,C
question
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.
answer
Where
question
For group calculations, Microsoft Access supports ____ built-in statistics. a. STDEV b. MAX c. LOW d. VAR
answer
A,B,D
question
The accompanying figure illustrates using a query to ____ tables; that is, to find records in two tables that have identical values in matching fields.
answer
join
question
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.
answer
Sort
question
When you enter text data in a criterion, you must enclose the text in quotation marks.
answer
F
question
If you specify more than one sort key, the sort key on the left will be the major sort key and the one on the right will be the minor sort key.
answer
T
question
You can export data from Access to the standard Word format.
answer
F
question
To find all customers whose returns are greater than $0.00 or whose book rep is book rep number 42, enter each criterion on the same row.
answer
F
question
The expression for a calculated field can be typed directly into the Field row.
answer
T
question
The question mark (?) wildcard represents any collection of characters.
answer
F
question
A property sheet is a window containing the various properties of the object.
answer
T
question
The field or fields on which records are sorted is called the sort key.
answer
T
question
In fixed-width files, each record is on a separate line and the fields are separated by a special character.
answer
F
question
To create a top-values query, use the Top Values box on the DESIGN tab to change the number of records to be included from All to the desired number.
answer
F
question
A query that prompts for input whenever it is run is a dialog query.
answer
F
question
To find all customers whose names begin with S, enter S? in the Criteria row of the design grid.
answer
F
question
To enter a number in a criterion, type the number without any dollar signs or commas.
answer
T
question
The asterisk (*) wildcard represents any collection of characters.
answer
T
question
You cannot create a report for a query.
answer
F
question
When you sort data, duplicates are not included.
answer
F
question
Grouping means creating groups of records that share some common characteristic.
answer
T
question
Crosstab queries are useful for summarizing data by category or group.
answer
T
question
A crosstab query calculates a statistic for data that is grouped by two different types of information. ____________________
answer
T
question
A summary function is a function that performs some mathematical function against a group of records. ____________________
answer
F