Solved

Converting from Access Microsoft Project Server

Posted on 2011-02-15
7
466 Views
Last Modified: 2013-11-15
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?

thanks.
0
Comment
Question by:newbie46
  • 4
  • 3
7 Comments
 
LVL 15

Expert Comment

by:dbase118
ID: 34896754
newbie,

1.) Project Server does have the capability to produce reports and to some extent customize them but it is not fully customizable in the way that a database application like Access has a full-blown report builder. The Project Server Report Pack does contain many useful reports but if you anticipate doing a lot of work with custom fields you might be limited by the reporting features out of the box.

2.) Yes the Project data can be stored in SQL when you use Project Server. This would allow you to write your own SQL queries and do reporting in a third party application if you needed more customizable ability.

3.) As far as getting up to speed on Project Server, I always preferred a hands on training session to learn something new because you get to see and touch it vice just reading about it in a book. THere are others that can get a reference book and just go to town. I guess it partly depends on your background and how much exposure you have had to it in the past.

If you are looking for a reference book recommendation. I think the following book on Amazon is a good entry level reference.
Microsoft® Office Project Server 2007: The Complete Reference

Hope this helps
0
 

Author Comment

by:newbie46
ID: 34896837
dbase 118,
Thanks for the information.
So, you are saying that custom fields can be created in Project Server?
If I store the Project data in SQL, can I use Access to create the reports?
I also learn best with hands-on training. What do you recommend to be able to 'see and touch it'?
Is it just a matter of learning Microsoft Project? Where does the custom field formatting and reporting capabilities lie, within Microsoft Project itself  or within Project Server?

thanks.
0
 
LVL 15

Expert Comment

by:dbase118
ID: 34897188

Both local and enterprise custom fields can be created in Project Server. The built in reporting, however uses only Standard fields.

I haven't done it myself but I don't see any reason why you couldn't use Access to pull the SQL data. If you are writing SQL to pull data anyway you might be able to get the reports you need without exporting though. Hopefully someone else can chime in with real-life experience on interfacing Project to Access.

As far as training there are probablly hundreds of options. Just do a web search for Project Server 2007 training and you will get a listing of seminars, training centers, web based instruction or even CBT options. Cost can range from couple hundred dollars for a CBT to a couple thousand for a week long boot camp. Again I think it depends on what your current level of comfort is and what roles you need to learn. If you are going to administer as well as use them more training is probablly required.
0
Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

 

Author Comment

by:newbie46
ID: 34897360
dbase118,
This information is very helpful. One last question from above:
Is it just a matter of learning Microsoft Project? Where does the custom field formatting and reporting capabilities lie, within Microsoft Project itself  or within Project Server?

0
 
LVL 15

Accepted Solution

by:
dbase118 earned 500 total points
ID: 34897544

Certainly knowing MS Project first would be helpful, but there will be additional  learning involved with the Project Server. Custom field formatting and reporting is a part of both pieces. If you are going to use the SQL reporting services and Project Server report pack though you will want to be comfotable with setting up custom fields in Project Server. Particularly if you anticipate using Enterprise custom fields which would be available in all Projects set up on the server.

If you anticipate managing multiple projects with similar fields then establishing your custom fields on the server would prevent you from duplicating effort and recreating them which you would end up doing in the front end application.

0
 

Author Closing Comment

by:newbie46
ID: 34897672
Thank you.
0
 
LVL 15

Expert Comment

by:dbase118
ID: 34897681
Glad to help. Good luck with it!
0

Featured Post

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

The System Center Operations Manager 2012, known as SCOM, is a part of the Microsoft system center product that provides the user with infrastructure monitoring and application performance monitoring. SCOM monitors:   Windows or UNIX/LinuxNetwo…
Online collaboration is quickly becoming embedded in the workplace, and its benefits are tangible. See what the current landscape looks like and what the future holds for collaboration tools and the future of work.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
This is used to tweak the memory usage for your computer, it is used for servers more so than workstations but just be careful editing registry settings as it may cause irreversible results. I hold no responsibility for anything you do to the regist…

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now