How MOSS 2007 integrates with other Microsoft products

July 9, 2009


MOSS and Office 2007

The Microsoft Office 2007 applications are based on open XML standards, enabling SharePoint to integrate with them more easily.

Outlook 2007: SharePoint contact management, task management, email management, and event/meeting management is fully integrated into Outlook, including full two-way synchronization.  Outlook can also be used to take SharePoint lists and document libraries offline.

Excel 2007: With Excel Services (included with MOSS Enterprise), Excel workbooks can be stored in a central location, and data from these workbooks can be access from MOSS webpages.  Custom applications can be built to access Excel 2007 calculation services.  This functionality is the basis for MOSS business intelligence solutions.\

Word 2007: Tighter integration of document metadata, via Word’s Quick Parts.  Integrates with documentation management features, such as check-in/check-out, versioning.  Integrated blogging.

Access 2007: Access databases can be moved to SharePoint sites.  Access creates a front-end application for the database including forms and reports.  Access forms and reports can be accessed then from SharePoint.  Databases can be created from SharePoint lists.  Access also provides offline access to SharePoint lists.

OneNote 2007: OneNote notes can be published directly to SharePoint sites, as OneNote files or as PDF, web pages, or Word documents.

InfoPath 2007: Use InfoPath to create forms to publish to SharePoint sites. MOSS acts as a Forms Server.  (Enterprise MOSS only).  Note:  You can also create forms that are accessible via Blackberry.

MOSS and Office Communicator 2007

With Office Communicator 2007, MOSS allows you to see inside of SharePoint what users are online and allows you to chat with them.

MOSS and Exchange 2007

You can directly email document libraries.  Email can be archived in a records repository.  Email retention.  Instead of attaching a document to an email message, users can link to the document in the message.   Outlook Web Access web parts.

MOSS and Active Directory

Users can be authenticated through Active Directory.  Information from AD can be pulled into SharePoint (job titles, departments, email addresses, contact details, organization structures).

MOSS and SharePoint Designer 2007

Use SharePoint Designer to edit SharePoint sites, page layouts, and appearances.  Add and configure custom controls and web parts.  Incorporate custom workflows and data-driven forms.

MOSS and Project Server 2007

MOSS itself contains Project Server as part of the Enterprise version.  If you already have Project Server 2007, though, MOSS can integrate Project Server with the Windows Workflow Foundation, document libraries, search capability and team work site orientation.  MOSS’s list feature “Project Tasks” is unrelated to Project Server.

MOSS and Groove Server 2007

Integration with MOSS allows Groove users to manage Groove spaces by team and make SharePoint’s document libraries accessible as Groove data with the same security.

Do you have any other integrated features to add to the list?


The Office 2007 Kick-Off

June 19, 2009


We’re planning to have an Office 2007 Kick-Off for all users, previous to any training or deployment.  I’ve found some valuable resources from trainer Tiffany Songvilay‘s OfficeOverEasy blog:

These resources could, of course, apply to MOSS 2007 or any other new software deployment.

Office 2007 Training on a Budget

June 19, 2009

In case you can’t afford the thousands of dollars a day it takes to bring in a trainer for on-site training, here are some alternatives to help you do Office 2007 training in-house.

Use Microsoft’s FREE resources:

Use Microsoft Software Assurance Benefits (if you have Software Assurance).

Use FREE online webinars

Quick Reference Guides

More resources to come!

Pricing for On-Site Training for Office 2007

June 18, 2009


This fall we are deploying Office 2007.  We’re planning on doing some internal training, focusing on the differences between Office 2003 and Office 2007, but for the nitty-gritty of the training, we are considering bringing someone in.   I’ve acquired quotes and information from several well-known and lesser-known IT training companies, and the pricing varies.  Below is a table of costs for six different vendors:

5 days 7 days 10 days 15 days Cost Per Day
$9,750 $13,650 $19,500 $29,250 $1,950
$19,500 $27,300 $39,000 $58,500 $3,900
$26,500 $37,100 $53,000 $79,500 $5,300
$7,500 $10,500 $15,000 $22,500 $1,500
$19,000 $26,600 $38,000 $57,000 $3,800
$10,000 $14,000 $20,000 $30,000 $2,000

Pricing is based on 10-20 students per class.   Each vendor offered both full day one session training and half day two session training.  This includes materials and travel costs, but does not include providing computers for hands-on work.

I wanted to share this info in case there is anyone out there wondering what the costs are like for on-site training.  Basically – around $1,500 to $5,000 per day, or $7,000 to $10,000 per week.