Question 1

You can specify more than one sort field in Query Design View.

Accepted Answer

Yes, you can specify more than one field and sort them in ascending or descending order in Query Design View in Microsoft Access. This allows for more customized and specific sorting of data within a query.

Question 2

A select query can be used to develop summary calculations, such as the sum of the values in a field.

Accepted Answer

False

Question 3

OR queries narrow the number of records that will appear in the datasheet because a record must be true for all criteria.

Accepted Answer

OR queries broaden the number of records that will appear in the datasheet because a record only needs to be true for one of the criteria.

Question 4

In the accompanying figure, the criteria in the first row of the query would be considered AND criteria.

Accepted Answer

The statement in the question is true. In the first row, all the criteria are joined by AND, indicating that all the conditions must be met for a record to be included in the query result.

Question 5

Deleting a field from the query design grid deletes it from the database table that contains that field.

Accepted Answer

Deleting a field from the query design grid only removes it from the query result, it does not delete it from the underlying database table.

Question 6

Access helps you with criteria syntax in the query design grid.

Accepted Answer

Access provides help with criteria syntax in the query design grid by offering suggestions and examples as you type. This can save time and improve the accuracy of your queries.

Question 7

Which type of query retrieves data from one or more linked tables and displays the results in a datasheet?
A) Common
B) Select
C) Linking
D) Web

Accepted Answer

A select query is used to retrieve data from one or more tables and displays the results in a datasheet format. Linking queries are used to link tables, but do not necessarily display results in a datasheet. Common and web queries are not valid types of queries in Microsoft Access.

Question 8

If you change a customer name from "Miller" to "Millen" in a query's datasheet, you will need to make the update in any other query that also displays this customer's name.

Accepted Answer

Changing a customer's name in a query's datasheet view typically updates the underlying table where the data is stored. Therefore, any other query pulling the customer's name from the same table will automatically reflect the change without needing to update each query individually.

Question 9

When you open a query in Datasheet View, you run it.

Accepted Answer

When a query is opened in Datasheet View, it is executed and the results are displayed in the datasheet format.

Question 10

In a query, the operator means not equal.

Accepted Answer

In SQL, the operator for not equal is "<>".

Question 11

In the accompanying figure, item 2 refers to a(n) ____.
A) field list
B) one-to-many link line
C) query design grid
D) Show Table window

Accepted Answer

Item 2 in the figure is labeled as "Field List," which is a pane in Microsoft Access used to select fields to add to a query or report.

Question 12

A query can display fields from one or more tables in a relational database.

Accepted Answer

A query can be used to display fields from one or more tables in a relational database. It is a powerful tool for retrieving specific data and presenting it in a meaningful way.

Question 13

A select query is the most common type of query.

Accepted Answer

A select query is used to retrieve data from a database and is the most commonly used query type.

Question 14

In the accompanying figure, the criteria in the TourStartDate column would be considered OR criteria.

Accepted Answer

OR criteria means that any one of the listed criteria can be met to satisfy the condition, and in the given figure, the TourStartDate column has multiple criteria separated by commas, indicating that any of them can be considered to filter the data, making it OR criteria.

Question 15

Each criteria row of the query design grid is evaluated separately.

Accepted Answer

Each criteria row in the query design grid is evaluated separately, and the result is then combined to produce the final query result.

Question 16

Sort orders defined in Query Design View are not saved with the query object.

Accepted Answer

Sort orders defined in Query Design View are indeed saved with the query object, allowing the query to be executed later with the same sorting criteria.

Question 17

Multiple criteria added to the same line of the query design grid means that each must be true for the record to appear in the datasheet.

Accepted Answer

Multiple criteria added to the same line of the query design grid means that each criterion acts as an additional filter, and only records that meet all the specified criteria will be included in the query results.

Question 18

In the accompanying figure, fields from how many tables will display on the datasheet?
A) 1
B) 2
C) 3
D) 4

Accepted Answer

The answer of  In the accompanying figure, fields from...

Question 19

In Query Design View, one-to-many join lines identify linking fields between related tables.

Accepted Answer

One-to-many join lines do indeed identify linking fields between related tables in Query Design View.

Question 20

In Query Design View, a table's name displays in the field list title bar.

Accepted Answer

In Query Design View, the table's name displays in the field list title bar.

Quiz 6: Modifying the Database Structure