The Delete Query is fairly straight forward
The Append Query will depend upon whether you have an IDENTITY field
That is like an Access AutoNumber field
IF YOU HAVE NO IDENTITY FIELD
IF you have an Identity field then
You must name Each Field That exists in the Tables and also Add a Line to Allow insertion into the Identity Field
To be honest, you should not have to do any of this.
Once you have set the BIT Fields to 0, and then Updated the design
to have a default and Not allow zero's everything should be fine.