Office 2010 Pro +
Sharepoint 2010

I'm two weeks in to the design phase of what's turned very quickly from an 8-12 user project meant to simlify and automate some of the recon and importing required by out different divisions, into what is now well over 20 with plans in the 100s, and dealing with everything from accounting and analytics to warehousing. *It's probably outgrown my current abilities. *Knowing that what we already have planned is far outside the capabilities of an accdb, my question is how far will access take us? *

More specifically:

1.) How easy/possible is it to migrate to SQL?
2.) Based on #1. Would it be best to work out a lite version of the intended final product, and start there while I take a crash course in SQL?
3.) How difficult is SQL to learn?
4.) is SQL even a good choice, outside of it's compaitibility with access?

Basically: *How deep can I go with this access project before building it has become counter productive when it comes to converting it? *Any input will be welcomed and appreciated!


Thanks!