Greg, Relax.
First off, take whatever you read, or hear about Microsoft Project, with a pinch of salt. Its a good package. I know, I use it. Since 1997.
The latest version, Microsoft Professional 2010, is VERY capable. If you are going to use it with Microsoft Project Server 2010 (as I assume you would, considering the project ranges), then you are covered more or less with everything you could want. It runs on SQL Server 2008. And can pretty much go to UNLIMITED resources and UNLIMITED tasks. So you are safe expansion wise.
Note, that no software package can provide 100 percent of everything. Neither does Microsoft Project 2010. Regardless of what other people tell you, there ARE glaring flaws in the software. Lucky, if you don't need to use those features. Unlucky, if you do.
But, in case of second situation --- you want to use features that are flawed, you are in luck. Microsoft Project 2010, among ALL project management softwares, has the MOST number of addins. Last counted at approximate 200! These addins let you do, what Microsoft Project 2010 on its own, cannot. I know of NO other project software (P3, P6, Asta, Spider Etc) that let you does this.
So, yes, if you use Microsoft Project 2010, then you are covered with 65 percent of your project range and construction industry out of the box. For the rest, there are addins. Of course, it is good to keep in mind that having addins (a lot of them) and Microsoft Project 2010, is still LOTS economical, than having a BIG software (read P6).
Now, I'd suggest 2 ways to become familiar:
1. Take a Microsoft Project 2010 class (useless, in my opinion)
2. Read the BRILLIANT book by Paul Harris (a forum member) on the Microsoft Project 2010. Not only does that book tell you how to become a master (people reading half the book are more experts than the so called trainers in step 1), it also tells you the difference between Microsoft Project 2010, Asta and P6! This is a double bonus, because when the differences come up, you KNOW that these are the ONLY things that cannot be done in P6. Everything else can. How? Well, read the book. (sorry, this is not a plug, but fact. I own his 2010 books --- both on solo project as well as project under PRINCE2)
Finally, you need to take things in your stride. Its NEVER easy migrating from what was *ONCE* an industry standard in project management to the so called, much maligned Microsoft Stack. But you'll get by.
In case you have issues, you can always post here.
Hope that helped. And hope I've not offended anyone here, for that was never my intention.
Cheers.
Lord Horn