Question 1

AND criteria means that all criteria must be true to select a record.

Accepted Answer

This statement is true. When using AND criteria in a query or filter, all criteria must be met for a record to be selected.

Question 2

To _____ a query, you right-click it in the Navigation Pane, and then click Copy on the shortcut menu.
A) paste
B) cut
C) copy
D) rename

Accepted Answer

To copy a query, you need to right-click it in the Navigation Pane, and then click Copy on the shortcut menu. The other options, including paste, cut, and rename, are not relevant to copying a query.

Question 3

What does the criterion <=200 mean?
A) less than or equal to 200
B) less than 200
C) greater than or equal to 200
D) not equal to 200

Accepted Answer

The symbol <= signifies "less than or equal to," therefore the criterion <=200 means a value that is less than or equal to 200.

Question 4

To select records in the Sales table that have no related records in the Customers table, create a(n) _____ join.
A) right inner
B) orphan outer
C) select inner
D) right outer

Accepted Answer

A right outer join will include all records from the Sales table, while only matching records from the Customers table are included. Records in the Sales table that do not have matching records in the Customers table will be included with null values in the customer-related columns. This makes it a good choice to select records in the Sales table that have no related records in the Customers table.

Question 5

_____ criteria are two or more criteria on the same Criteria row of the query design grid.
A) AND
B) OR
C) Comparison
D) Date/Time

Accepted Answer

AND criteria means that all criteria in the same row must be met for the query to return a result. OR criteria means that either of the criteria in the same row can be met for the query to return a result. Comparison and Date/Time are types of criteria, but are not specific to multiple criteria on the same row.

Question 6

What kind of criteria would you use to find records with OrderDate values in May or June?
A) IS NULL
B) PLUS
C) AND
D) OR

Accepted Answer

To find records with OrderDate values in May OR June, we need the logical OR operator. Therefore, option D (OR) is the right choice.

Question 7

Enter _____ criteria on different Criteria rows in the query design grid.
A) AND
B) Date/Time
C) null
D) OR

Accepted Answer

In query design, entering criteria on different rows acts as an OR condition, meaning that records matching any of the criteria entered on separate rows will be included in the query results.

Question 8

The _____ property renames a field list in Query Design view.
A) Caption
B) Alias
C) Field List
D) Recordset

Accepted Answer

The Alias property allows you to rename field names in a query, which can make the output easier to read and understand. The Caption property, on the other hand, only changes the label in forms and reports but does not affect the underlying field name. The Field List and Recordset properties do not allow you to rename fields.

Question 9

As you add AND criteria to the query design grid, you increase the number of records selected for the resulting datasheet.

Accepted Answer

- OR
False - or
False - Or

Question 10

Use >500 as the criterion for a Number field in a query to select records with a value less than 500 in that field.

Accepted Answer

- greater
False - Greater
False - GREATER

Question 11

_____ criteria are two or more criteria on different Criteria rows of the query design grid.
A) AND
B) OR
C) SHOW
D) SELECT

Accepted Answer

When there are multiple criteria rows in a query, using the OR operator will return results that meet either of those criteria. Using the AND operator would only return results that meet both criteria, which may not be what is desired. The terms SHOW and SELECT are not related to combining criteria in a query.

Question 12

To display a field list for the Employees table with the name "Managers" in Query Design view, you change the _____ property for the field list. ​
A) Description
B) Source
C) Lookup
D) Alias

Accepted Answer

To display a field list with a different name in Query Design view, you need to change the Alias property for the field list. The Alias property changes the displayed name for the field list without actually renaming the underlying table or field.

Question 13

You cannot view a query with a self join in SQL View.

Accepted Answer

In SQL, you can view a query with a self join in SQL View just like any other query. A self join is simply a regular join, but the table is joined with itself.

Question 14

Create a(n) _____ join to relate an Employee table to itself using two fields in the same table to identify the relationship between employees and supervisors.
A) inner
B) outer
C) self
D) referential

Accepted Answer

A self-join is used to relate a table to itself. In this case, we want to use two fields in the same table to identify the relationship between employees and supervisors. Thus, a self-join would be the best choice.

Question 15

Which of the following are tasks you can perform on a query listed in the Navigation Pane? Select all the options that apply. ​
A) Close the query.
B) Copy the query.
C) Paste the query.
D) Open the query.

Accepted Answer

The answer of Which of the following are tasks you...

Question 16

A(n) self join selects all the records from the "one" table regardless of whether there is a related record in the "many" table.

Accepted Answer

- outer
False - Outer
False - OUTER

Question 17

What criterion would you use to find numbers greater than or equal to 100? A) <=100 B) <>100 C) >+100 D) >=100

Accepted Answer

The symbol >= means "greater than or equal to," so choosing D would correctly identify all numbers greater than or equal to 100.

Question 18

To select records from the Customers table that have no related records in the Sales table, create a(n) _____ join.
A) inner
B) outer
C) self
D) referential

Accepted Answer

An outer join is used to combine records from two tables, including matching records and unmatched records from one or both tables. In this case, we want to select customers with no related records in the Sales table, which means we need to include all customers even if they do not have a matching record in the Sales table. An inner join, on the other hand, would only include matching records from both tables. A self-join is used to join a table to itself, and a referential join is not a valid type of join in SQL.

Question 19

Which of the following statements describe OR criteria? Select all the options that apply.
A) You enter OR criteria on different rows of the query design grid.
B) You use OR criteria when any one criterion must be true to select a record.
C) As you add OR criteria to a query, you increase the number of records in the resulting datasheet.
D) You use OR criteria when all of the criteria must be true to select a record.

Accepted Answer

- A) OR criteria are entered on different rows in a query design grid to indicate that any of the criteria can be true for a record to be included in the results.- B) OR criteria mean that if any one of the specified conditions is true, the record will be selected, which aligns with the definition of OR logic.- C) Adding OR criteria to a query generally increases the number of records in the resulting datasheet because it broadens the conditions under which records are selected.

Question 20

You enter _____ criteria on the same row of the query design grid.
A) NOT
B) AND
C) TEXT
D) OR

Accepted Answer

When entering multiple criteria on the same row of the query design grid, the logical operator used to combine them should be "AND" to ensure that all criteria are met for a record to be included in the query results. "OR" would include records that meet any of the criteria, which may not narrow down the results enough, while "NOT" would exclude records that meet the criteria, which may also not be desirable. "TEXT" is not a logical operator and cannot be used in this context.

Quiz 9: Access

AND criteria means that all criteria must be true to select a record.

To _____ a query, you right-click it in the Navigation Pane, and then click Copy on the shortcut menu.

What does the criterion <=200 mean?

To select records in the Sales table that have no related records in the Customers table, create a(n) _____ join.

_____ criteria are two or more criteria on the same Criteria row of the query design grid.

What kind of criteria would you use to find records with OrderDate values in May or June?

Enter _____ criteria on different Criteria rows in the query design grid.

The _____ property renames a field list in Query Design view.

As you add AND criteria to the query design grid, you increase the number of records selected for the resulting datasheet.

Use >500 as the criterion for a Number field in a query to select records with a value less than 500 in that field.

_____ criteria are two or more criteria on different Criteria rows of the query design grid.

To display a field list for the Employees table with the name "Managers" in Query Design view, you change the _____ property for the field list. ​

You cannot view a query with a self join in SQL View.

Create a(n) _____ join to relate an Employee table to itself using two fields in the same table to identify the relationship between employees and supervisors.

Which of the following are tasks you can perform on a query listed in the Navigation Pane? Select all the options that apply. ​

A(n) self join selects all the records from the "one" table regardless of whether there is a related record in the "many" table.

What criterion would you use to find numbers greater than or equal to 100?

To select records from the Customers table that have no related records in the Sales table, create a(n) _____ join.

Which of the following statements describe OR criteria? Select all the options that apply.

You enter _____ criteria on the same row of the query design grid.

To display a field list for the Employees table with the name "Managers" in Query Design view, you change the _____ property for the field list.

Which of the following are tasks you can perform on a query listed in the Navigation Pane? Select all the options that apply.