Question 1

To delete records from a query datasheet, click the record selector button to the left of the record, click the Home tab, click the Delete button in the Records group, and click Yes.

Accepted Answer

This is the correct procedure to delete records from a query datasheet.

Question 2

A filter can be used to create calculated fields.

Accepted Answer

A filter is used to limit or narrow down the data that is displayed, it does not create calculated fields. Calculated fields are created using formulas or expressions.

Question 3

Deleting a field from a query also deletes it from the underlying table.

Accepted Answer

Deleting a field from a query only removes it from the query and does not affect the underlying table. However, deleting a field from a table can also remove it from any query or report that uses that field.

Question 4

By copying a query before starting to make modifications to it, you can avoid changing the original query by mistake.

Accepted Answer

By copying the query, you can work on the copy without affecting the original query.

Question 5

To filter for comparative data, use the Filter By Selection feature.

Accepted Answer

The answer of To filter for comparative data, use the...

Question 6

A query allows the selection of a subset of fields and records from one or more tables, then presents the selected data as a single datasheet.

Accepted Answer

This is a correct statement that describes the purpose and function of a query in a database.

Question 7

SQL stands for ____.
A) Structured Query Lingo
B) Standard Query Lingo
C) Standard Query Language
D) Structured Query Language

Accepted Answer

SQL stands for Structured Query Language. It is a standard programming language used for managing and manipulating relational databases.

Question 8

Query criteria are not case sensitive.​

Accepted Answer

Query criteria are not case sensitive, meaning whether you use uppercase or lowercase letters will not impact the results of your query.

Question 9

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

Accepted Answer

OR criteria can be entered on separate Criteria rows in the query design grid.

Question 10

A query datasheet is sometimes called a ____ of the data.
A) logical view
B) duplicate copy
C) table simulator
D) warehouse

Accepted Answer

A query datasheet is a logical view of the data because it presents a selection of data that meets specific criteria or conditions, rather than showing all the data in a table or database.

Question 11

The asterisk (*) is the wildcard used to represent one and only one character in criteria.

Accepted Answer

The answer of The asterisk (*) is the wildcard used...

Question 12

A query can be used to create calculated fields.

Accepted Answer

A query can use expressions and functions to calculate new fields based on existing fields in the same table or in other tables. These calculated fields are commonly referred to as calculated columns or computed columns.

Question 13

The question mark (?) is the wildcard character which stands for any single character in criteria.

Accepted Answer

The statement is true. The question mark (?) can be used as a wildcard character to represent any single character in criteria.

Question 14

The easiest way to filter the records for an exact match is to use the Filter By Form feature.

Accepted Answer

The answer of The easiest way to filter the records...

Question 15

To add, delete, or change fields in a query, you use Query Design View.

Accepted Answer

In Query Design View, you can easily add, delete, or change fields in a query by selecting or deselecting them in the select query builder.

Question 16

In large datasheets, you may want to ____ certain fields so that they remain on the screen at all times.
A) fix
B) post
C) freeze
D) view

Accepted Answer

The answer of In large datasheets, you may want to...

Question 17

In Access, the Save As command allows you to save either the entire database or the current object with a new name.​

Accepted Answer

The Save As command in Access allows you to save either the entire database or the current object with a new name, making it easier to create copies or variations of your work.

Question 18

Filters are used to select a subset of records in a datasheet.

Accepted Answer

Filters are used to narrow down and display a subset of records from a larger dataset based on certain criteria.

Question 19

You enter and edit data in a query datasheet in the same way you do in a table datasheet.

Accepted Answer

You can enter and edit data in a query datasheet just like in a table datasheet. The difference is that a query datasheet displays only the records that match the specified criteria or joins, rather than displaying all the records in the table.

Question 20

You use Query Design View to add ____ to limit the number of records shown in the resulting datasheet.
A) criteria
B) posts
C) versioning
D) indices

Accepted Answer

Query Design View is used to create and design queries in Microsoft Access. You can add criteria to limit the number of records shown in the resulting datasheet. Criteria are used to specify the conditions that must be met for a record to be included in the query results. For example, you can create a query that shows only the products with a price greater than $5, or only the customers who live in a certain state.

Quiz 2: Building and Using Queries