Access Chapter 2
True
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.
False
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.
True
Crosstab queries are useful for summarizing data by category or group.
True
Grouping means creating groups of records that share some common characteristic.
$0.00
If the criterion for Current Due field is 0, the query results for this query will display ____ in the Current Due field.
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.
False
In fixed-width files, each record is on a separate line and the fields are separated by a special character.
Join Properties
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.
Show Table
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.
Join
In the accompanying figure, the ____ line between matching fields in the two tables indicates that the tables are related.
Design Grid
In the accompanying figure, the lower pane in the window where you enter criteria is called the ____.
Remove Table
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.
Criteria
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.
Delete
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).
True
Joining tables in a query creates an ad hoc relationship, that is, a relationship between tables created for a specific purpose.
Comparison Operators
Less than (<), greater than (>), and NOT (not equal to) are examples of ____.
Between
The ____ operator allows you to search for a range of values in one field
Join
The accompanying figure illustrates using a query to ____ tables; that is, to find records in two tables that have identical values in matching fields.
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.
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.
Where
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.
Caption
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.
Design View
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.
Query Wizard
To create a crosstab, click the ____ button on the CREATE tab.
Query Design
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.
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.
square brackets [ ]
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 ____.
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.
Zoom
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 ____.
True
To enter a criterion for a particular field without displaying the field in the results of the query, include the field in the design grid, enter the criterion, and remove the check mark from its Show check box.
True
To enter a number in a criterion, type the number without any dollar signs or commas.
External Data
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.
>1000
To find all customers whose current due amount is greater than $1,000.00, enter ____ in the Criteria row of the Current Due column.
S*
To find all customers whose names begin with S, enter ____ in the Criteria row of the Customer Name field.
True
To find all customers whose returns are greater than $0.00 and whose book rep is book rep number 42, enter each criterion on the same row.
True
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.
Rob?n
To find all individuals whose name is Robin or Robyn, enter ____ in the Criteria row of the appropriate column.
Max
To find the largest amount paid amount for a client, select ____ as the entry in the Total row for the Amount Paid column.
False
To include all fields in the design grid, double-click the question mark (?) in the field list.
Colon (:)
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.
Totals
To include the Total row in the design grid, click the ____ button on the DESIGN tab.
Group By
To indicate grouping in Access, select ____ as the entry in the Total row for the field to be used for grouping.
Yes
To omit duplicates from a query, use the property sheet and change the Unique Values property to ____.
Sort
To order the records in the answer to a query in a particular way, you ____ the records.
Tables and Related Views
To organize entries in the Navigation Pane by table, click ____ on the Navigation Pane menu.
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.
Close
To quit Access, click the ____ button on the right side of the Access title bar.
External Data
To re-use saved export steps, tap or click the Saved Exports button on the ____ tab on the ribbon.
False
To restrict the objects that appear on the Navigation Pane use the Retrieval Bar.
Quick Access Toolbar
To save a query, tap or click the Save button on the ____.
Shutter Bar Open/Close
To show the Navigation Pane if it is hidden, click the ____ Button.
Sort
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.
Open
To use a parameter query, press and hold or right-click the query in the Navigation Pane and then tap or click ____ on the shortcut menu.
Build
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 ____.
Create
To use the Report Wizard to create a report for a query, select the query in the Navigation Pane, tap or click ____ on the ribbon, and then tap or click the Report Wizard button.
Open
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.
True
Unless you specify otherwise, Access assumes that the criteria you enter involve equality (exact matches).
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
When you sort data, duplicates are not included.
True
Wildcards are symbols that represent any character or combination of characters.
False
You can export data from Access to the standard Word format.
Parentheses ( )
You can include ____ in calculations to indicate which calculation should be done first.
False
You cannot create a report for a query.
