Query
Query
A query datasheet displays the results of a query operation, showing data based on specified criteria or calculations. A table datasheet displays the data in a table format, representing information stored in a database table. In essence, a query datasheet is derived from a table datasheet and is dynamic based on the query criteria.
Datasheet view
grid
Yes.
datasheet view
performs calculations on the values in a field and displays the results in a datasheet
Multiple Items Form
Yes, that is correct. A query datasheet presents a logical view of the data because it displays the information based on the query conditions without physically storing it. The data itself remains stored in the underlying tables of the database.
What you seem to be describing is a Query. Databases run queries when the humans want information out of the database. Microsoft Access has a separate Table structure for creating and running Query. The correct answer is called a Run. (report)
a tableA table. In the contexts of certain types of software it could be called a worksheet or a datasheet.
status bar