Question 1

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.
A)Caption
B)Property Sheet
C)Field Name
D)Format

Accepted Answer

Clicking the "Caption" button on the Design tab allows you to change the caption (the label or title) for a field in a query.

Question 2

The ____ operator allows you to search for a range of values in one field.
A)BETWEEN
B)RANGE
C)IN
D)SEARCH

Accepted Answer

The BETWEEN operator allows you to search for a range of values in one field. It is used with the WHERE clause to filter the results based on a specified range of values.

Question 3

To re-use saved export steps, click the Saved Exports button on the ____ tab on the ribbon.
A)FILE
B)CREATE
C)DATABASE TOOLS
D)EXTERNAL DATA

Accepted Answer

The External Data tab on the ribbon is where all export and import actions are managed in Access, including the option to save export steps for easier re-use.

Question 4

To change the design of a query that is not currently open, right-click the query and then click ____ on the shortcut menu.
A)Datasheet View
B)Layout View
C)Change View
D)Design View

Accepted Answer

To change the design of a query that is not currently open, you need to access its Design View. This can be done by right-clicking the query and then clicking Design View on the shortcut menu.

Question 5

To view the results of a query, open it by right-clicking the query in the Navigation Pane and clicking ____ on the shortcut menu.
A)Datasheet View
B)Design View
C)Open
D)Run

Accepted Answer

The answer of To view the results of a query,...

Question 6

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.
A)colon (:)
B)semi-colon (;)
C)equal sign (=)
D)exclamation point (!)

Accepted Answer

The answer of To include calculated fields in queries, enter...

Question 7

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 ____.
A)curly braces { }
B)square brackets [ ]
C)parentheses ( )
D)single quotes ''

Accepted Answer

Square brackets [ ] are used to enclose parameters in a parameter query, indicating that the user will be prompted to enter a value when the query is run.

Question 8

To view the results of a query, right-click the query in the Navigation Pane and then click ____ on the shortcut menu.
A)Use Parameter
B)Enter Values
C)Open
D)Run

Accepted Answer

The answer of To view the results of a query,...

Question 9

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.
A)Show
B)List
C)Sort
D)Order

Accepted Answer

The "Sort" row in the design grid is specifically used for indicating the sort order of the records in the result set. It allows the user to select whether the sort order should be ascending or descending, and allows for sorting by multiple fields if desired. The other options listed (Show, List, Order) are not relevant to sorting records in a query.

Question 10

Less than (<), greater than (>), and NOT (not equal to) are examples of ____.
A)compound conditions
B)comparison operators
C)compound values
D)conditions

Accepted Answer

<, >, and != are all comparison operators used to compare values in conditional statements.

Question 11

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.
A)DATABASE TOOLS
B)EXTERNAL DATA
C)OFFICE EXPORT
D)CREATE

Accepted Answer

The External Data tab on the ribbon includes options for importing and exporting data, including the Excel button. The other choices are not relevant for exporting data to Excel.

Question 12

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 ____.
A)Expression Builder
B)Builder box
C)Build
D)Field Builder

Accepted Answer

The correct option to select in order to use the Expression Builder for creating a calculated field is "Build." This option is typically available in the shortcut menu when you right-click in the Field row within various database management systems, such as Microsoft Access.

Question 13

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.
A)Preview
B)Query
C)Print Query
D)Print

Accepted Answer

The user needs to click on the "Print" option in the Backstage view to print the results of a query that is open. The other options, such as "Preview" and "Print Query" do not directly relate to printing the open query results.

Question 14

To save a query, click the Save button on the ____.
A)status bar
B)Quick Access Toolbar
C)CREATE tab on the ribbon
D)HOME tab on the ribbon

Accepted Answer

The answer of To save a query, click the Save...

Question 15

To order the records in the answer to a query in a particular way, you ____ the records.
A)index
B)sort
C)arrange
D)list

Accepted Answer

"Sort" is the most appropriate choice as it specifically refers to arranging records in a certain order based on a particular field or criterion. We can also say "Sort in ascending/descending order" to specify the direction of the sorting.

Question 16

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.
A)CREATE
B)DATABASE TOOLS
C)REPORT
D)FILE

Accepted Answer

The answer of To use the Report Wizard to create...

Question 17

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.
A)Query
B)Design View
C)Query Design
D)Select Query

Accepted Answer

Clicking on "Query Design" in the "CREATE" tab will open a new query in Design View.

Question 18

To omit duplicates from a query, use the property sheet and change the Unique Values property to ____.
A)No
B)Yes
C)Off
D)On

Accepted Answer

To omit duplicates from a query in Access, you would change the Unique Values property to "Yes". This ensures that the query returns only unique records, eliminating any duplicates.

Question 19

You can include ____ in calculations to indicate which calculation should be done first.
A)curly braces { }
B)brackets [ ]
C)parentheses ( )
D)slashes //

Accepted Answer

Parentheses are used in mathematical expressions to indicate which operations should be done first, following the order of operations. This is also known as "grouping."

Question 20

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 ____.
A)Enlarge
B)Resize
C)Magnify
D)Zoom

Accepted Answer

To display the entire entry for a calculated field in a database program like Microsoft Access, you would select the column in the Field row, right-click to display the shortcut menu, and then click "Zoom." This option allows you to see the complete content of the field, especially useful for viewing long expressions or text that doesn't fit in the standard field view.

Quiz 12: Access_Module_2

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.

The ____ operator allows you to search for a range of values in one field.

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

To change the design of a query that is not currently open, right-click the query and then click ____ on the shortcut menu.

To view the results of a query, open it by right-clicking the query in the Navigation Pane and clicking ____ on the shortcut menu.

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.

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 ____.

To view the results of a query, right-click the query in the Navigation Pane and then click ____ on the shortcut menu.

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.

Less than (<) , greater than (>) , and NOT (not equal to) are examples of ____.

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.

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 ____.

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 save a query, click the Save button on the ____.

To order the records in the answer to a query in a particular way, you ____ the records.

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.

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.

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

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

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 ____.