Add a visual clue that the data is still being loaded before user can get the drop-down to choose type (e.g., Sum, or Count)
After I add a Totals row to my datasheet (by clicking the Sigma button), I was expecting to get a drop down when I click on any column for the Totals row. With a Linked Table (SQL Server), I wasn't getting this. I assumed it was because this Totals row would not work for Linked Tables, perhaps?
I had even asked why this might be with this SQL Server support forum: https://social.msdn.microsoft.com/Forums/sqlserver/en-US/502dea49-1a92-4fdb-89b0-1d778a7b7df4/not-able-to-display-column-totals-totals-row-in-ms-access-for-linked-table-from-sql-server
As described in that forum post, the reason I wasn't getting the drop-down allowing me to choose Sum, or Count, etc., was because MS Access was still loading data from the Linked table, and thus the UI was not responsive for that specific action (clicking on any column in the Totals row).
Simply waiting for Access to finish loading the data, and then clicking on a column in the Totals row did yield the drop-down with the Sum, Count, etc, that was was looking for.
So essentially, my request is that Access provide some visual that it is still loading data, and therefore, my click event on the Totals row was not being acted on yet.
So this is a request for a UI / UX improvement.
I don't know if Access has this same behavior with local tables, or if this only happens with Linked tables, so if it is Linked tables only (and only large amount of data), there probably aren't all that many people that are impacted by this.
