6. MICROSOFT ACCESS QUERIES – ADVANCED
To remove entire rows from a table you use a Delete query. As with previous query types discussed, you can begin with a Simple query that retrieves the rows you wish to delete. Once the Simple query is working you can change its type to Delete and run the query (or save it and run it later). Be careful with delete queries, as they can delete many rows in a single run.