Access Unit Review Part 2

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.

• Show
• Criteria
• Order
• Sort

To omit duplicates from a query, use the property sheet and change the Unique Values property to _____.

• No
• Yes
• Off
• On

Use a query to _____ tables; that is, to find records in two tables that have identical values in matching fields.

• combine
• concatenate
• interleave
• join

A(n) ____ join is the default join in Access.

• left outer
• right outer
• outer
• inner

To display the Join Properties dialog box, right-click the join line and click ____ on the shortcut menu.

• Properties
• Property Sheet
• Join Properties
• Modify Properties

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.

• New Report
• Create
• Query Report
• Save as Report

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
• Database Tools
• Create
• Office Export

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
• Builde box
• Build
• Field Builder

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 (:)
• semi-colon (;)
• equal sign (=)
• exclamation point (!)

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
• Resize
• Magnify
• Zoom