Please review my profile I am working with skills that you required for this job from 16 years.
I am working with VB 6.0,COM,ActiveX,MS Access,Excel,MS SQL and VBA from long time. I can definitely help you in this job, to make your database design very proficient. I have done lots of split databases with MS Access as Front-end and MS Access/MS SQL/MySQL/Teradata database as back-end.
Please contact me with your interest to discuss next.