Quiz #10 Access Ch. 2
The special criteria that can be used in queries are ____.
AND, BETWEEN, and IN
The ____ operator allows you to search for a range of values in one field.
BETWEEN
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 ____.
Build
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.
CREATE
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.
Colon (:)
To change the design of a query that is not currently open, right-click the query and then click ____ on the shortcut menu.
Design View
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.
EXTERNAL DATA
To re-use saved export steps, click the Saved Exports button on the ____ tab on the ribbon.
EXTERNAL DATA
A query that prompts for input whenever it is run is a dialog query.
False
A summary function is a function that performs some mathematical function against a group of records.
False
In fixed-width files, each record is on a separate line and the fields are separated by a special character.
False
The only calculated fields you can create in Access are those involving addition and subtraction.
False
The question mark (?) wildcard represents any collection of characters.
False
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.
False
To include all fields in the design grid, double-click the question mark (?) in the field list.
False
To restrict the objects that appear on the Navigation Pane use the Retrieval Bar.
False
When you enter text data in a criterion, you must enclose the text in quotation marks.
False
When you sort data in a query, the records in the underlying table are actually rearranged.
False
You can export data from Access to the standard Word format.
False
To indicate grouping in Access, select ____ as the entry in the Total row for the field to be used for grouping.
Group By
To find the largest amount paid amount for a client, select ____ as the entry in the Total row for the Amount Paid column.
MAX
To view the results of a query, open it by right-clicking the query in the Navigation Pane and clicking ____ on the shortcut menu.
Open
To view the results of a query, right-click the query in the Navigation Pane and then click ____ on the shortcut menu.
Open
To print the results of a query that is open, click FILE on the ribbon, click the ____ tab in the Backstage view, and then click Quick Print.
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
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.
Query Design
To create a crosstab, click the ____ button on the CREATE tab.
Query Wizard
To save a query, click the Save button on the ____.
Quick Access Toolbar
To show the Navigation Pane if it is hidden, click the ____ Button.
Shutter Bar Open/Close
To order the records in the answer to a query in a particular way, you ____ the records.
Sort
To organize entries in the Navigation Pane by table, click ____ on the Navigation Pane menu.
Tables and Related Views
To include the Total row in the design grid, click the ____ button on the DESIGN tab.
Totals
A crosstab query calculates a statistic for data that is grouped by two different types of information.
True
A property sheet is a window containing the various properties of the object.
True
Crosstab queries are useful for summarizing data by category or group.
True
Grouping means creating groups of records that share some common characteristic.
True
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.
True
Joining tables in a query creates an ad hoc relationship, that is, a relationship between tables created for a specific purpose.
True
The asterisk (*) wildcard represents any collection of characters.
True
The expression for a calculated field can be typed directly into the Field row.
True
The field or fields on which records are sorted is called the sort key.
True
To create a parameter query that will prompt users to enter a city name as input, place [Enter City] as the criterion in the City field.
True
To enter a number in a criterion, type the number without any dollar signs or commas.
True
To find all accounts whose current due amounts are greater than $2,500.00 and whose account manager is manager 31, enter each criterion on the same row.
True
Wildcards are symbols that represent any character or combination of characters.
True
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.
Where
To omit duplicates from a query, use the property sheet and change the Unique Values property to ____.
Yes
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 ____.
Zoom
Less than (<), greater than (>), and NOT (not equal to) are examples of ____.
comparison operators
You can include ____ in calculations to indicate which calculation should be done first.
parentheses ( )
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 ____.
square brackets [ ]
