Access Mod 2 Q1

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

• DATABASE TOOLS

• REPORT

• FILE

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

• DATABASE TOOLS

• EXTERNAL DATA

• OFFICE EXPORT

• CREATE

To re-use saved export steps, click the Saved Exports button on the ____ tab on the ribbon.

• FILE

• CREATE

• DATABASE TOOLS

• EXTERNAL DATA

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

• 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

You can include ____ in calculations to indicate which calculation should be done first.

• curly braces { }

• brackets [ ]

• parentheses ( )

• slashes //

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.

• Caption

• Property Sheet

• Field Name

• Format

To include the Total row in the design grid, click the ____ button on the DESIGN tab.

• Aggregate

• Statistics

• Calculations

• Totals

To find the largest amount paid amount for a client, select ____ as the entry in the Total row for the Amount Paid column.

• Large

• Maximum

• LGE

• MAX