Microsoft Jet provides a powerful query engine that supports data retrieval and manipulation by using SQL. You can also use DAO to programmatically access data in tables.
By using the data-manipulation services of Microsoft Jet, you can add, modify, and delete records in tables. These changes can be accomplished through action queries or directly through DAO by using Recordset objects. Microsoft Jet supports updatable queries, heterogeneous joins, and queries on queries.