Append or delete multiple records

I can select a record from a source data table by building a Recordset, then use the "Insert Record" wizard to insert selected fields into another destination table.  But it only works one recordata time.  How can I insert new records in the destination table for ALL of the records which satisfy the criteria in the recordset?

I use to be able to do this with Microsoft FrontPage (ugh) because it had a provision for entering a full SQL statement derived in Access. Is there any way I can harness Dreamweaver to allow managing multiple records?  This would include the ability to append, update, or delete all records which satisfy described criteria.