A temporary table that is created when you execute a query. The table contains the values from your query.
A set of records produced by running a query or applying a filter.
A type of Recordset object that returns a dynamic set of pointers to live database data. Like a table- or a snapshot-type Recordset, a dynaset returns data in records (rows) and fields (columns). Unlike a table-type Recordset, a dynaset-type Recordset can be the result of a query that joins two or more tables. The records in a dynaset-type Recordset object are updatable if the Updatable property of the Recordset is True, the Field being changed is updatable, and the data page containing the current record isn't locked. The data page is locked when the Update method is used (when the LockEdits property is False), or the Edit method is used (when the LockEdits property is True). .
a dynamic part of the database that matches the criteria of the SQL query
a dynamic set of records that you can use to add, change, or delete records from an underlying database table or tables
a logical representation of data from one or more tables that is accessed internally through a set of ordered pointers and pages of data
an updatable view of a database that is a unique feature of Jet database engine
a set of records (Recordset) extracted from the table, and its benefit is that we can filter the records in the set
A table which is generated from a select query, it is dynamic-ally linked to a source table.
Short for dynamic set of data. A dynaset is the datasheet (row and column) view of a query that you can edit.
A recordset that can include data from one or more tables from a database. A dynaset can be used to view or modify data contained in the underlying database.
A dynamic (two-way) updatable query result set. A type of cursor.
A dynaset (short for dynamic set) is a set of data that is dynamically linked back to the database. Instead of having the query result stored in a temporary table, where the data cannot be updated directly by the user, the dynaset allows the user to view and update the data contained in the dynaset. Thus, if a university lecturer queried all students who received a distinction in their assignment and found an error in that student's record, they would only need to update the data in the dynaset, which would automatically update the student's database record without the need for them to send a specific update query after storing the query results in a temporary table.