Question 1

To sort resards 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 used to specify the sort order for a query.

Question 2

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.
A) Use Parameter
B) Enter Values
C) Open
D) Run

Accepted Answer

To use a parameter query in Access, you would press and hold or right-click the query in the Navigation Pane and then tap or click "Open" on the shortcut menu. This action opens the query and prompts you to enter the values for the parameters before displaying the results.

Question 3

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 is used to search for range of values in one field. It is a commonly used operator in SQL and is supported by most relational database management systems. The other options are not valid operators for this task.

Question 4

To find all individuals whose name is Robin or Robyn, enter ____ in the Criteria row of the appropriate salumn.
A) Rob#n
B) Rob%n
C) Rob$n
D) Rob?n

Accepted Answer

The wildcard character ? matches any single character, so Rob?n will match both Robin and Robyn.

Question 5

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

Accepted Answer

The question is asking how to print the results of a query that is already open. The option "Print" is the most appropriate as it directly prints the results, and we do not need to preview them before printing. The other options such as "Preview" and "Print Query" involve additional steps and are not necessary for quickly printing the results of a query that is already open.

Question 6

To find all customers whose names begin with S, enter ____ in the Criteria row of the Customer Name field.
A) S?
B) S*
C) S#
D) S&

Accepted Answer

To find all customers whose names begin with S, you need to use a wildcard character that will allow the search to match any characters that come after the initial S. The asterisk (*) wildcard character will match any number of characters, so entering S* in the Criteria row of the Customer Name field will result in all customers whose names begin with S being returned in the search results.

Question 7

To save a query, tap or 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 is located on the Quick Access Toolbar, which is typically located at the top of the Access window and provides quick access to frequently used commands. The status bar displays information about the current status of the database, and the CREATE and HOME tabs on the ribbon contain commands for creating and formatting objects in the database, but do not contain a Save button for queries.

Question 8

In the acsampanying figure, the lower pane in the window where you enter criteria is called the ____.
A) design grid
B) query grid
C) criteria grid
D) salumn grid

Accepted Answer

The answer of  In the acsampanying figure, the lower...

Question 9

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.
A) Datasheet View
B) Design View
C) Open
D) Run

Accepted Answer

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

Question 10

If the criterion for Current Due field is 0, the query results for this query will display ____ in the Current Due field.
A) 0.00
B) $0
C) 0
D) $0.00

Accepted Answer

The correct format displayed for a currency field in databases or financial applications when the criterion is set to 0 would typically include both the currency symbol and decimal points, hence "$0.00" is the correct representation.

Question 11

In the acsampanying figure, the Customer table was added to the query by selecting the table and tapping or clicking the Add button in the ____ dialog box.
A) Show Table
B) Add Table
C) Select Table
D) Field List

Accepted Answer

The answer of  In the acsampanying figure, the Customer...

Question 12

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

Accepted Answer

Selecting "Query Design" will open a new query window in Design view, allowing the user to create a new query.

Question 13

In the acsampanying figure, you can enter CSU10 in the ____ row of the Customer Number field to find all customers whose customer number is CSU10.
A) Sort
B) Show
C) or
D) Criteria

Accepted Answer

The answer of  In the acsampanying figure, you can...

Question 14

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 15

To find all customers whose current due amount is greater than $1,000.00, enter ____ in the Criteria row of the Current Due salumn.
A) > $1000
B) > 1000
C) > 1,000
D) > $1,000

Accepted Answer

In most database systems, numeric values should not include currency symbols or commas when used in criteria expressions.

Question 16

In the acsampanying figure, you can delete the table by pressing and holding or right-clicking the field list and tapping or clicking ____ on the shortcut menu.
A) Delete Table
B) Hide Table
C) Remove Table
D) Erase Table

Accepted Answer

The answer of  In the acsampanying figure, you can...

Question 17

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.
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 the Design View. Therefore, the correct choice is D) Design View.

Question 18

In the acsampanying figure, you can remove a salumn by tapping or clicking just above the field name to select the salumn and then tapping or clicking the ____ key(s).
A) CTRL+DELETE
B) CTRL+Y
C) DELETE
D) CTRL+ALT

Accepted Answer

The answer of  In the acsampanying figure, you can...

Question 19

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

Accepted Answer

Sorting is the process of arranging data in a specific order, such as alphabetical order or numerical order.

Question 20

Less than ( ), and NOT (not equal to) are examples of ____.
A) sampound sanditions
B) samparison operators
C) sampound values
D) sanditions

Accepted Answer

Less than (<) and NOT (not equal to) are examples of comparison operators used to compare values.

Quiz 2: Querying a Database

To sort resards in a query, specify the sort order in the ____ row of the design grid below the field that is the sort key.

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.

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

To find all individuals whose name is Robin or Robyn, enter ____ in the Criteria row of the appropriate salumn.

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.

To find all customers whose names begin with S, enter ____ in the Criteria row of the Customer Name field.

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

In the acsampanying figure, the lower pane in the window where you enter criteria is called the ____.

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.

If the criterion for Current Due field is 0, the query results for this query will display ____ in the Current Due field.

In the acsampanying figure, the Customer table was added to the query by selecting the table and tapping or clicking the Add button in the ____ dialog box.

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.

In the acsampanying figure, you can enter CSU10 in the ____ row of the Customer Number field to find all customers whose customer number is CSU10.

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 find all customers whose current due amount is greater than $1,000.00, enter ____ in the Criteria row of the Current Due salumn.

In the acsampanying figure, you can delete the table by pressing and holding or right-clicking the field list and tapping or clicking ____ on the shortcut menu.

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.

In the acsampanying figure, you can remove a salumn by tapping or clicking just above the field name to select the salumn and then tapping or clicking the ____ key(s) .

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

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