The correct answer is: D. Dynaset
A dynaset is a collection of records that match the parameters of a query. It is a dynamic set of data that is updated as the underlying data changes. A dynaset is a type of recordset.
A field is a column in a table that stores data. A record is a row in a table that contains data. A query is a statement that retrieves data from a database.
Here is a more detailed explanation of each option:
- Field
A field is a column in a table that stores data. For example, a table of employees might have fields for employee name, employee ID, and department.
- Record
A record is a row in a table that contains data. For example, a table of employees might have a record for each employee, with the employee name, employee ID, and department in separate fields.
- Query
A query is a statement that retrieves data from a database. For example, a query might retrieve all employees in the department of sales.
- Dynaset
A dynaset is a collection of records that match the parameters of a query. It is a dynamic set of data that is updated as the underlying data changes. A dynaset is a type of recordset.