Question 1

​ The deletion of a record is temporary and can be undone.

Accepted Answer

Deletion of a record is permanent in most systems unless there is a backup or a versioning system in place that allows for recovery.

Question 2

Which of the following is true of working with queries in Microsoft Access 2016? ​

Accepted Answer

Queries in Microsoft Access can indeed be based on multiple tables, allowing for the combination of data from different sources within the database for analysis, reporting, or specific data retrieval tasks. This capability is fundamental to relational database management systems like Access, enabling complex data relationships and insights.

Question 3

​ In Microsoft Access 2016, you can specify a format for a calculated field, just as you can for any field, by modifying its properties.

Accepted Answer

In Microsoft Access 2016, you can specify a format for a calculated field by modifying its properties in the table design view or in a query, just as you can for any other field type. This allows you to control how the calculated results are displayed (e.g., as currency, date, etc.).

Question 4

In Microsoft Access 2016, the order of the fields in the design grid cannot be changed. ​

Accepted Answer

In Microsoft Access 2016, the order of the fields in the design grid can be changed by clicking and dragging the field to a new position.

Question 5

In Microsoft Access 2016, a record in a primary table that has matching records in a related table can be deleted even if the option to cascade deletions to related records is not selected. ​

Accepted Answer

Without the option to cascade deletions selected, deleting a record in a primary table that has matching records in a related table is not allowed due to referential integrity rules, which prevent orphan records in the related table.

Question 6

​ In Microsoft Access 2016, if you want to delete a record from the primary table, you first must delete the related records in the related table.

Accepted Answer

In Microsoft Access 2016, if referential integrity is enforced between two tables, you must first delete the related records in the related table before you can delete a record in the primary table to maintain database integrity.

Question 7

In Microsoft Access 2016, the answer to a select query is returned in a query datasheet. ​

Accepted Answer

In Microsoft Access 2016, the results of a select query are indeed displayed in a query datasheet, which is a table-like view showing the data that matches the query criteria.

Question 8

In Microsoft Access 2016, the Total row added to a datasheet cannot be removed.

Accepted Answer

In Microsoft Access 2016, the Total row added to a datasheet can be removed by toggling the Total Row option off in the ribbon under the Design tab or right-clicking the row and selecting the option to remove it.

Question 9

In Microsoft Access 2016, which of the following occurs when the Ctrl+End keys are pressed? ​

Accepted Answer

Pressing Ctrl+End in Microsoft Access 2016 moves the cursor to the last field in the last record, facilitating navigation within the database.

Question 10

In Microsoft Access 2016, to create a query that retrieves data from multiple tables, the tables must have unique fields.

Accepted Answer

In Microsoft Access 2016, to create a query that retrieves data from multiple tables, the tables must have related fields, not necessarily unique fields. This relationship is often established through a common field shared between the tables, allowing the query to combine the data based on this relationship.

Question 11

In Microsoft Access 2016, the count function determines the total of the field values for the selected records.

Accepted Answer

The Count function in Microsoft Access 2016 is used to determine the number of items in a group, not the total of the field values. To calculate the total, the Sum function is used instead.

Question 12

Identify a true statement about modifying queries in Microsoft Access 2016. ​

Accepted Answer

Hiding a field's value in the query results does not remove the field from the query design; it simply means the field will not be displayed in the output, but it can still be used within the query for calculations or criteria.

Question 13

In the accompanying figure of a Microsoft Access 2016 document, if you check the option that Box 1 is pointing to, the _____. ​ ​

Accepted Answer

The answer of In the accompanying figure of a Microsoft...

Question 14

Which of the following is true of working with queries in Microsoft Access 2016? ​

Accepted Answer

Data in a query datasheet is not duplicated; it reflects the current state of the database. Query datasheets show the results of a query and can be used to view and sometimes update data, depending on the type of query.

Question 15

After you run a query, the query datasheet uses a default column name that cannot be changed.

Accepted Answer

After running a query, you can change the default column names in the query datasheet by creating aliases in the SQL view or by renaming the columns in design view, providing more meaningful names for the columns.

Question 16

In Microsoft Access 2016, calculations, such as sums, averages, minimums, and maximums, cannot be performed on the displayed records using a query datasheet.

Accepted Answer

In Microsoft Access 2016, calculations like sums, averages, minimums, and maximums can indeed be performed on the displayed records using a query datasheet by utilizing aggregate functions in the query design.

Question 17

In Microsoft Access 2016, queries cannot be based on multiple tables. ​

Accepted Answer

In Microsoft Access 2016, queries can indeed be based on multiple tables, allowing for the combination and analysis of data across different tables through relationships.

Question 18

In the accompanying figure of a Microsoft Access 2016 document, Box A points to a _____. ​

Accepted Answer

The answer of In the accompanying figure of a Microsoft...

Question 19

In Microsoft Access 2016, hiding a field's values removes the field from the query design. ​

Accepted Answer

Hiding a field's values in a query does not remove the field from the query design; it only prevents the field's values from being displayed in the query's result set. The field remains part of the query's structure and can still be used for criteria or sorting.

Question 20

Identify an accurate statement about deleting a record in Microsoft Access 2016. ​

Accepted Answer

In Microsoft Access 2016, when a record is deleted, the action is permanent and cannot be undone using the Undo command. This makes it crucial to be certain before deleting any records.

Quiz 18: Maintaining and Querying a Database

​ The deletion of a record is temporary and can be undone.

Which of the following is true of working with queries in Microsoft Access 2016? ​

​ In Microsoft Access 2016, you can specify a format for a calculated field, just as you can for any field, by modifying its properties.

In Microsoft Access 2016, the order of the fields in the design grid cannot be changed. ​

In Microsoft Access 2016, a record in a primary table that has matching records in a related table can be deleted even if the option to cascade deletions to related records is not selected. ​

​ In Microsoft Access 2016, if you want to delete a record from the primary table, you first must delete the related records in the related table.

In Microsoft Access 2016, the answer to a select query is returned in a query datasheet. ​

In Microsoft Access 2016, the Total row added to a datasheet cannot be removed.

In Microsoft Access 2016, which of the following occurs when the Ctrl+End keys are pressed? ​

In Microsoft Access 2016, to create a query that retrieves data from multiple tables, the tables must have unique fields.

In Microsoft Access 2016, the count function determines the total of the field values for the selected records.

Identify a true statement about modifying queries in Microsoft Access 2016. ​

In the accompanying figure of a Microsoft Access 2016 document, if you check the option that Box 1 is pointing to, the _____. ​ ​

Which of the following is true of working with queries in Microsoft Access 2016? ​

After you run a query, the query datasheet uses a default column name that cannot be changed.

In Microsoft Access 2016, calculations, such as sums, averages, minimums, and maximums, cannot be performed on the displayed records using a query datasheet.

In Microsoft Access 2016, queries cannot be based on multiple tables. ​

In the accompanying figure of a Microsoft Access 2016 document, Box A points to a _____. ​

In Microsoft Access 2016, hiding a field's values removes the field from the query design. ​

Identify an accurate statement about deleting a record in Microsoft Access 2016. ​

The deletion of a record is temporary and can be undone.

Which of the following is true of working with queries in Microsoft Access 2016?

In Microsoft Access 2016, you can specify a format for a calculated field, just as you can for any field, by modifying its properties.

In Microsoft Access 2016, the order of the fields in the design grid cannot be changed.

In Microsoft Access 2016, a record in a primary table that has matching records in a related table can be deleted even if the option to cascade deletions to related records is not selected.

In Microsoft Access 2016, if you want to delete a record from the primary table, you first must delete the related records in the related table.

In Microsoft Access 2016, the answer to a select query is returned in a query datasheet.

In Microsoft Access 2016, which of the following occurs when the Ctrl+End keys are pressed?

Identify a true statement about modifying queries in Microsoft Access 2016.

In the accompanying figure of a Microsoft Access 2016 document, if you check the option that Box 1 is pointing to, the _____.

Which of the following is true of working with queries in Microsoft Access 2016?

In Microsoft Access 2016, queries cannot be based on multiple tables.

In the accompanying figure of a Microsoft Access 2016 document, Box A points to a _____.

In Microsoft Access 2016, hiding a field's values removes the field from the query design.

Identify an accurate statement about deleting a record in Microsoft Access 2016.