I have an Access 2007 database which imports Microsoft Project data via an Excel spreadsheet. There is now a push to use Microsoft Project Server to manage the data and to create reports. Not having any experience with Microsoft Project Server, I have a few questions:
1) Is there the flexibility to create custom reports, as is the case with Access? If so, are they created using Microsoft Project itself or are there other tools within Project Server that are used to customize reports?
2) I have heard that SQL server has some type of connection with Project Server. Is the data in Project Server stored within SQL?
3) What is the best way to get up to speed with Project Server?