Directions for Automation

Does anyone have any detailed directions to create an automation that drops tables in toad and then imports tables from an access database file. I would then need to run a script after all of this is completed. This is my first experience with automation so I am looking for some step by step guide to show how to drop the tables then select the right ones to import from access file. Thank You!!!