First before I go into this, is the table you are deleting from in the access database?
if it is all you will have to do is create a new query, set its type to delete, by going to the query menu and select delete query. then grab the * at the top of the table that you added to the query and hit the exlamation point. If its not in the database you will need to run a SQL Pass threw query. Let me know if this helps