Question 1

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

When you want to put the records in a specific order, you sort them. This can be done in ascending or descending order based on a particular column or attribute. Indexing is a process of optimizing the query performance by creating a data structure that makes it faster to find specific records. Arranging and listing also refer to the same process of sorting records in a specific order. Nonetheless, sorting is the more specific term that refers to this process.

Question 2

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

The correct button to create a new query in Design view is the "Query Design" button on the CREATE tab. Option A is incorrect as it refers to the name of an existing query, not the button to create a new one. Option B is incorrect as it refers to a view mode, not a button. Option D is incorrect as it refers to a different type of query that does not involve designing a new one.

Question 3

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

Accepted Answer

Less than and not equal to are both comparison operators used in creating conditions.

Question 4

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 5

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 calculations to indicate which operation should be done first, according to the order of operations. This is also known as grouping symbols.

Question 6

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 commonly used with numeric or date fields to search for values within a range.

Question 7

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 8

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 9

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

This is because the question is asking how to change the design of a query that is not currently open, and Design View is where one can modify query design. The other options (Datasheet View, Layout View, and Change View) are not relevant to modifying query design.

Question 10

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 Save button for queries is located on the Quick Access Toolbar.

Question 11

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 12

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

When exporting data from a query to Excel, the best choice is the External Data tab on the ribbon. Within this tab, you can find the Excel button to export the query results to an Excel workbook. The other options listed do not provide the necessary functionality for this specific task.

Question 13

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

The Property Sheet button on the Design tab will allow access to the properties for the selected field, including the ability to edit the caption. The Caption box is located within the properties for the field.

Question 14

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 15

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 16

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 is to click "Build" to open the Expression Builder and create a calculated field. The other options listed are not correct actions to take in this scenario.

Question 17

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 Saved Exports button is located on the EXTERNAL DATA tab on the ribbon in Microsoft Access. This is the best choice as it directly relates to exporting data and the option to save export steps for future use. The FILE and CREATE tabs do not have direct options for exporting data, and the DATABASE TOOLS tab is more focused on database management tasks rather than data export.

Question 18

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 is the designated area in the query design grid where the sort order can be specified for a specific field. The other choices (Show, List, Order) are not relevant to sorting records in a query.

Question 19

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 correct tab to select for printing the results of an open query is the "Print" tab. The "Quick Print" option is also specifically mentioned, which is found under the "Print" tab. The other options listed, such as "Query" and "Print Query," are not relevant for printing the results of an open query.

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 2: Access 2 Querying a Database

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

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.

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

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

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

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

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

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 change the design of a query that is not currently open, right-click the query and then click ____ on the shortcut menu.

To save a query, click the Save button on the ____.

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

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 parameter query, enter a parameter rather than a specific value as a criterion in the design grid. The parameter must be enclosed in ____.

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 re-use saved export steps, click the Saved Exports button on the ____ tab on the ribbon.

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.

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