Truthfully, My experience only takes me as far as building queries in SQL view. I'm pretty knowledgeable with that and the process of creating databases that are standardized and uniform.

Right now the DB that I am tasked to fix, update and further expand has a DB Back End to a parent DB and then 3 child DB's that link to it. All the DB's have VBA script protection and are password protected to avoid sensitive info from being mishandled. Then the servers are tightly controlled to only allow access to a very minimal group of people. I've already corrected all the broken server, table and import/export links & have already updated to access 2010, it runs in a compatibility version 2007-2010. I will research SSIS and see if I can learn if I can and how I would with my current setup. Thanks for hopefully pointing me in the right direction.