Microsoft Gold Certified

Microsoft Office SharePoint Server 2007

Office SharePoint Server 2007 is a new server application that is part of the 2007 Microsoft Office system. Your organization can use it to facilitate collaboration, provide content management features, implement business processes, and provide access to information that is essential to organizational goals and processes.

By using site templates and other features in Office SharePoint Server 2007, you can can quickly and efficiently create sites that support specific content publishing, content management, records management, or business intelligence needs your organization may have. For example, it is possible to create enterprise-level sites, such as organizational portal sites or Internet presence sites, or specialized sites, such as content repositories or meeting workspaces. These sites enable you to collaborate and share information with others, whether they are inside or outside of your organization. In addition, you can use Office SharePoint Server 2007 to conduct effective searches for people, documents, and data, to design and participate in forms-driven business processes, and to access and analyze large amounts of business data.

Among other things, you can use Office SharePoint Server 2007 to:

  • Collaborate effectively with others in your organization. For example, you can use calendars to see when team events are occurring, or use document libraries to store team, divisional, or organizational documents. You can also discuss issues by using blogs or capture and retain information in Wikis, which are user-managed knowledge bases.
  • Create personal sites, where you can manage and share information with other users. For example, you can create your own My Site portal, where you can view and manage all of your documents, tasks, links, Microsoft Office Outlook 2007 calendar, colleagues, and other personal information from a central location.
  • Find people, expertise, and data in business applications. For example, by searching the My Sites on your intranet, you can find someone who has a specific skill or interest, even if you don't know their name. You may also be able to find data in a corporate database or enterprise business application, such as a Customer Relationship Management (CRM) application.
  • Manage documents, records, and Web content. For example, your organization may develop a process for retiring or expiring documents after a certain amount of time has elapsed.
  • Host XML-based business forms that integrate with databases or other business applications. For example, if you work for a local government agency, you might design permit applications forms inMicrosoft Office InfoPath 2007 and host them Office SharePoint Server 2007 so that users can then fill out forms directly in a browser. The data entered into the form can be submitted to a database in the government's network.
  • Easily publish reports, lists, and key performance indicators (KPIs) by linking to business applications, such as SAP, Siebel, and Microsoft SQL Server 2005.

SharePoint Server 2007 and Microsoft Office

Office SharePoint Server 2007 is designed to work effectively with other programs and servers in the 2007 Microsoft Office system. The following list includes examples of what is possible.

  • If you use Microsoft Office PowerPoint 2007, you can create a library of PowerPoint slides that can be shared with other users on a Office SharePoint Server 2007 site.
  • If you use Microsoft Office Access 2007, you can take a SharePoint list offline and use the reporting features in Office Access 2007 to view the data and create reports. If you are traveling, for example, you can maintain a local copy of a SharePoint list on your laptop computer, where you can edit and query the list as though it were any other table in Office Access 2007. Forms and reports that use the SharePoint list are fully interactive — and Office Access 2007 can later synchronize the local list with the online list when you bring your laptop back online.
  • If you use Office Outlook 2007, you can take document libraries offline. SharePoint folders show up just like other Outlook folders.
  • If you use Office InfoPath 2007, you can design browser-compatible form templates, publish them to an Office SharePoint Server 2007site, and enable them for use in a Web browser.
  • If you use Microsoft Office Excel 2007, you can save worksheets on a SharePoint site so that users can access them by using a browser. You can use these worksheets to maintain and efficiently share one central, up-to-date version, while helping to protect any proprietary information, such as financial models, that are embedded in the worksheet.
  • If you use Microsoft Office SharePoint Designer 2007, you can customize Office SharePoint Server 2007 sites and workflows an intuitive, what-you-see-is-what-you-get (WYSIWYG) environment. You can tailor SharePoint sites to your needs and set brand requirements using the latest ASP.NET technology, established Web standards such as Extensible Hypertext Markup Language (XHTML) code, and cascading style sheets (CSS). For example, if you're a business analyst, you might be asked to build and customize a new Office SharePoint Server 2007 site that will be used for collaborating on the development of videotaped customer case studies. In this scenario, you can use Office SharePoint Designer 2007 to creates a brand-new Office SharePoint Server 2007 site where writers, videographers, and marketing team members can collaborate on the development of video case studies.
  • In many 2007 Office release programs, you can update properties for a server document in a Document Information Panel, which appears as a set of editable fields at the top of a document. For example, in a Word document, you might be required to edit properties for author name, date of creation, and document type. This ultimately makes it easier for you to find what you're looking for on the server. For example, you can quickly find all press releases where the customer property matches the name of a particular customer.
  • In many 2007 Office release programs, you can initiate or participate in workflows, which is the automated movement of documents or items through a specific sequence of actions or tasks related to a business process. Workflows can be used to consistently manage common business processes, such as document approval or review.