As Dylan said you have two ways of doing it.
No offcence, but i personally don't suggest you to use the 1st method. As it will require you to write more queries and you need to execute more number of commands on the database reducing the performance. And the job is tedious too. But The method is rock solid and will not cause any trouble as you will be executing the delete command on all the related tables.
But If you are using database like MySql, SQL server or MS Access, there is another way of doing it which make life easier. ;)
i.e. Using Relation. Like the option ON DELETE CASCADE in MySQL, SQL Server etc.
ON DELETE CASCADE[
^]
And
Create Relation[
^]option provided by MS Access might help you to tacle with the prob.