Question

(ACCESS 2016)

What statements best describe total rows? Check all that apply.

Their values are not stored in a database.

Their values are stored on the top row in a database

Their values update when changes are made in a table

Their values update only when they are manually refreshed

Their values are automatically totaled when a total row is added

​

Answer 1

Total rows in Access 2016 are dynamic calculations that appear at the bottom of a table or dataset, automatically updating with changes in data, and are not stored in the database.

Step-by-step explanation:

Total rows in Access 2016 are special types of rows in a table or query that provide additional functionalities, such as calculating sums, averages, counts, or other types of totals. Here's a closer look at the characteristics of total rows:

Their values are not stored in a database. Total rows perform calculations on existing data, but the values they show are not saved as part of the database's data storage.

Their values do not appear on the top row in a database; instead, they typically appear at the bottom of a table or query result set.

Their values update when changes are made in a table. If data in the underlying rows change, the calculated values in total rows will automatically update to reflect these changes.

Their values do not update only when manually refreshed; they update dynamically.

Their values are automatically totaled when a total row is added. For instance, if you add a total row to count the number of items, the count would be calculated automatically without manual intervention.

Answer 2

Total rows in Access represent the dynamic calculation of aggregate data, such as sums or averages, which are automatically updated when table data changes and are not stored in the database. They appear at the bottom of a datasheet view when added.

Step-by-step explanation:

Total rows in Microsoft Access are a feature that allows for the dynamic calculation of data within a table. When a total row is added to a table, it appears at the bottom, and its main function is to calculate aggregate values such as sums, averages, counts, etc., for a column of data.

Let's address each point from the question:

Their values are not stored in a database: This is true. Total rows are a dynamic feature in Access, which means that the data they display is calculated on the fly and is not stored within the actual database tables.

Their values are stored on the top row in a database: This is false. Total rows appear at the bottom of a datasheet view, not at the top.

Their values update when changes are made in a table: This is true. Total rows dynamically calculate aggregate values, so when data in the table changes, the values in the total row reflect these changes automatically.

Their values update only when they are manually refreshed: This is false. As mentioned, total rows update automatically when the underlying data changes.

Their values are automatically totaled when a total row is added: This is true. Once you add a total row to your datasheet, it will automatically calculate the specified aggregate function for each column where it's applicable.