Microsoft® SharePoint® 2007 for Office 2007 Users

Published by
Wiley Publishing, Inc.
10475 Crosspoint Boulevard
Indianapolis, IN 46256
www.wiley.com

Copyright © 2009 by Wiley Publishing, Inc., Indianapolis, Indiana

Published simultaneously in Canada

eISBN : 978-0-470-54929-2

Library of Congress Cataloging-in-Publication Data

Reid, Martin W. P.

Microsoft SharePoint 2007 for Office 2007 Users/Martin WP Reid.

p. cm.

Includes index.

1. Microsoft SharePoint (Electronic resource) 2. Intranets (Computer networks) 3. Web servers.

I. Title.

TK5105.875.I6R47 2009

004.6’82 — dc22 2009004112

No part of this publication may be reproduced, stored in a retrieval system or transmitted in any form or by any means, electronic, mechanical, photocopying, recording, scanning or otherwise, except as permitted under Sections 107 or 108 of the 1976 United States Copyright Act, without either the prior written permission of the Publisher, or authorization through payment of the appropriate per-copy fee to the Copyright Clearance Center, 222 Rosewood Drive, Danvers, MA 01923, (978) 750-8400, fax (978) 646-8600. Requests to the Publisher for permission should be addressed to the Permissions Department, John Wiley & Sons, Inc., 111 River Street, Hoboken, NJ 07030, (201) 748-6011, fax (201) 748-6008, or online at http://www.wiley.com/go/permissions.

Limit of Liability/Disclaimer of Warranty: The publisher and the author make no representations or warranties with respect to the accuracy or completeness of the contents of this work and specifically disclaim all warranties, including without limitation warranties of fitness for a particular purpose. No warranty may be created or extended by sales or promotional materials. The advice and strategies contained herein may not be suitable for every situation. This work is sold with the understanding that the publisher is not engaged in rendering legal, accounting, or other professional services. If professional assistance is required, the services of a competent professional person should be sought. Neither the publisher nor the author shall be liable for damages arising herefrom. The fact that an organization or Web site is referred to in this work as a citation and/or a potential source of further information does not mean that the author or the publisher endorses the information the organization or Web site may provide or recommendations it may make. Further, readers should be aware that Internet Web sites listed in this work may have changed or disappeared between when this work was written and when it is read.

For general information on our other products and services please contact our Customer Care Department within the United States at (877) 762-2974, outside the United States at (317) 572-3993 or fax (317) 572-4002.

Trademarks: Wiley, the Wiley logo, Wrox, the Wrox logo, Wrox Programmer to Programmer, and related trade dress are trademarks or registered trademarks of John Wiley & Sons, Inc. and/or its affiliates, in the United States and other countries, and may not be used without written permission. Microsoft and SharePoint are registered trademarks of Microsoft Corporation in the United States and/or other countries. All other trademarks are the property of their respective owners. Wiley Publishing, Inc., is not associated with any product or vendor mentioned in this book.

Wiley also publishes its books in a variety of electronic formats. Some content that appears in print may not be available in electronic books.

This book is dedicated to my father,
William Robert Reid
16 September 1931-21 December 2008.

“I’m a part of old Ardoyne-And Ardoyne is me
I’m a part of the old ways-A part of the old days
I’m a part of Ardoyne-And Ardoyne is me.”

About the Author

Martin W. P. Reid is a systems analyst for Queen’s University in Belfast, one of the leading universities in the United Kingdom. He is in the process of implementing a 30,000-user Microsoft Office SharePoint 2007 Services rollout. Previously he worked with end users teaching Microsoft Office applications, database design, programming, and web development. He has authored 13 technical books since 2002, including Professional Access 2007 published by Apress. Martin is particularly interested in using SharePoint as a tool to help information workers get the job done without having to wade through technical manuals. Martin is a regular contributor to the Microsoft Office SharePoint blog Get the Point (http://sharepoint.microsoft.com/blogs/getthepoint).

Credits

Acquisitions Editor
Katie Mohr

Development Editor
Brian Herrmann

Technical Editor
Todd Meister

Senior Production Editor
Debra Banninger

Production Editor
Kathleen Wisor

Copy Editor
Foxxe Editorial Services

Editorial Manager
Mary Beth Wakefield

Production Manager
Tim Tate

Vice President and Executive Group Publisher
Richard Swadley

Vice President and Executive Publisher
Barry Pruett

Associate Publisher
Jim Minatel

Project Coordinator, Cover
Lynsey Stanford

Proofreader
David Parise, Word One

Indexer
J & J Indexing

Acknowledgments

A lot of authors begin their acknowledgements by saying, “You can’t write a book on your own.” As this is a single-author book, to tell the truth, I did write this book on my own — at least the first draft of every chapter. Once that was done, other people then came on board and helped craft the book you have in your hands now. Without these people, this book would not exist. To those people I extend grateful thanks: to Katie Mohr, who believed in the project; to Brian Herrmann, who guided me through the development process and provided an endless amount of suggestions and improvements to this text; and to the technical editor, Todd Meister, for his effort and suggestions.

But that’s just the book. Lots of people are involved in everyone’s experience, and I would like to thank all those individuals on the Internet who give freely of their time and effort to teach the rest of us how to use SharePoint in all its forms.

I would also like to thank Queen’s University Belfast. Particularly the management of the Learning and Teaching division, who granted me permission to use their MOSS installation for many of the examples in this book. Without this access, the book would not have been written.

Finally, I would like to thank my family (even Grumpy) for their patience and support when writing this book, especially for being there when my father died. I am proud of this book; it took time and effort to write, especially toward the end stages of the project. This book is for my father, who never used a computer in his life. I miss you!

Introduction

Microsoft Office SharePoint Server, or simply SharePoint, is the new buzzword around Microsoft software. I first used SharePoint some years back simply to store documents and access them from home via the Web. Over time, I came to realize that this software offered an opportunity to totally change the way I work with documents in that it blurred the distinction between the local PC and the Internet. But, being honest, I was an amateur user of SharePoint and it quickly became simply an extension of the usual file server I used every day.

When I was using the beta of Microsoft Office 2007 was the time that I really sat up and looked at SharePoint, and at MOSS 2007 in particular. I realized that simply using Microsoft Word 2007 and a few mouse clicks I could make information available via the browser to whomever I wanted to, with no need to use third-party software to upload files to the web. Just use the software I was already familiar with and the job was done. Not only that, but security of the information was taken care of for me. Now SharePoint has really taken off and is perhaps one of the biggest-selling products in the Microsoft stable.

This book is designed to teach you how to use SharePoint and Microsoft Office 2007 integration features to get your job done in this new environment. So why did I write this book? I have written and contributed to several books, and each time I always say to myself that I will never do it again. There is no money in books — not for the author anyway. I wrote this book on SharePoint and Office 2007 because I discovered that there is very little in the way of user materials available to the average SharePoint user. Most of the materials available on the web, for example, are aimed at the technical user or aimed at a user who would possess high-level permissions within a SharePoint environment. It’s highly unlikely that the majority of SharePoint users would ever be given such permissions. I wanted to write a book that you could leave on your desk and refer to when required, a book that would show you, in basic, nontechnical terms, how SharePoint and Office 2007 fit together. For example, I wanted to show you how to save a document directly into your SharePoint site from any of the Office 2007 applications and have all interested parties emailed with details of the upload.

Who This Book Is For

I hope anyone using Microsoft SharePoint would find something of value in this book. The book is written for those actively using SharePoint, either those new to the software or existing users of the previous version. I assume nothing at all about your experience with SharePoint and its interaction with Microsoft Office 2007 and cover everything from that standpoint. You can feel free to read the book cover to cover or dip in and out for information as you need to.

How This Book Is Structured

This book is structured into two distinct areas: Microsoft Office SharePoint Server and Microsoft Office 2007. I did this because, in order to take full advantage of the features in SharePoint, you do need to understand how it works and what exactly is available within SharePoint. SharePoint is a huge bit of software and does take some time to learn all of the available features, not counting all of the add-ins and extras you can have installed. Chapters 1-5 deal with SharePoint-specific areas, while Chapters 6-13 look more at integration with Microsoft Office 2007. In a book like this, it’s difficult to decide when to introduce specific topics — there is a lot of “chicken and egg” about working with SharePoint. In the end, I think I have succeeded in breaking this topic up in a way that you can get the most out of the software without repeating myself too much.

However, ultimately, all SharePoint really is is a tool to help you get your work done in as efficient a way as possible without wading through heaps of technical manuals and web sites to try to work out the easy way to do something. This is something I think that many technical gurus forget. To the majority of users, software is only a tool used to get their work done, and I hope this book helps you do that. If you are comfortable with SharePoint, you can skip the first five chapters, but I would advise you to check them out anyway. Given the nature of this software, it’s always possible to miss some small feature that you might need, and you might find out something you don’t already know. What follows is a brief preview of each chapter in the book.

• Chapter 1: Microsoft Office SharePoint Services 2007 (MOSS) — This chapter provides you with some background on SharePoint, what it is, and what it is used for. It is aimed at new users to SharePoint, but existing users may want to read over it because there is always something to learn with SharePoint.

• Chapter 2: Sites and Workspaces — This chapter begins to explore SharePoint in terms of its sites and site structures, taking you from a beginner’s position to having a fully working team site running within the browser. You will examine and create various types of sites within SharePoint, and be introduced to how permissions work in this application. At the end of the chapter, you will have an appreciation of the various types of objects that can be created for you. This chapter also delves a little bit into site design and how you can use free templates from Microsoft to enhance your team sites to meet various business conditions.

• Chapter 3: Lists and Libraries — This chapter introduces you to the fundamental objects within SharePoint: lists and libraries. You will look at the lists and libraries available to you, how they are created and managed, and how you can create custom lists of your own. The chapter also introduces you to the world of SharePoint workflows and how they are created and executed.

• Chapter 4: Web Parts — This chapter discusses the basic building block of SharePoint web sites, the Web Part. You will work with almost all the built-in Web Parts available to you in SharePoint, including those used for searching.

• Chapter 5: SharePoint and You — Chapter 5 takes you into the world of SharePoint personalization, using the MySite feature in SharePoint to create your own personal SharePoint sites. You will also look at how to manage your personal site and how you can create a personal view of a standard SharePoint team site.

• Chapter 6: Microsoft Office Word 2007 — This chapter starts to explore the interaction between the Office 2007 applications and SharePoint, beginning with Word 2007. You will see how documents are published to a team site, how to create and manage metadata associated with your documents, and how the documents themselves are enhanced by SharePoint functionality.

• Chapter 7: Microsoft Office Access 2007 — This chapter discusses and demonstrates the integration between Microsoft Access 2007 and SharePoint. You will discover how to link your Access database to SharePoint, use Access 2007 to report on SharePoint list data, and work offline using Access 2007 as the client.

• Chapter 8: Microsoft Office Outlook 2007 — This chapter discusses how Outlook 2007 is used with SharePoint, again looking at offline access to SharePoint data, and working with calendars both from Outlook 2007 and from within SharePoint itself.

• Chapter 9: Microsoft Office Excel 2007 — This chapter looks at using Microsoft Excel 2007 to work with data — both from within Excel and directly from SharePoint — using the Excel Services.

• Chapter 10: Microsoft Office Groove 2007 — This chapter introduces you to another new product, Groove, a client-based tool used for collaboration and integrated into SharePoint. The chapter provides you with a solid grounding in this software, including how to take SharePoint data offline and initial discussions regarding security. As well, the chapter discusses other areas of Groove 2007 that can assist you in your work.

• Chapter 11: SharePoint Add-Ins — This chapter outlines some of the more useful add-ins I have personally used to enhance SharePoint in my own installation.

• Chapter 12: Sharepoint Designer 2007 — This chapter discusses SharePoint Designer and how it also can be used to enhance your SharePoint sites. The chapter provides grounding in using this tool to change the design of a standard site and also looks at creating workflows from the design surface and attaching them to lists within your team sites.

• Chapter 13: Records Management — This final chapter discusses what records management is and how it works in the SharePoint world. At the end of this chapter, you will have a solid understanding of how to use records management to your benefit from day to day, and how to enable it within your team sites.

What You Need to Use This Book

You will need either access to Microsoft SharePoint Server 2007 or Windows SharePoint Services version 3. To follow along with some of the examples, you will also need Office 2007. Office 2003 users shouldn’t be put off by this, as there is still a fair degree of interaction between Microsoft Office 2003 and MOSS 2007. Some menu options may not be available to you in the Office applications, but the basic functionality is there, so you too will get something out of this book.

Conventions

To help you get the most from the text and keep track of what’s happening, we’ve used a number of conventions throughout the book.

Notes, tips, hints, tricks, and asides to the current discussion are offset and placed in italics like this.

As for styles in the text:

• We highlight new terms and important words when we introduce them.

• We show keyboard strokes like this: Ctrl+A.

• We show filenames, URLs, and code within the text like so: persistence.properties.

• We present code in two different ways:

We use a monofont type with no highlighting for most code examples.

We use gray highlighting to emphasize code that’s particularly important in the present context.

Errata

We make every effort to ensure that there are no errors in the text or in the code. However, no one is perfect, and mistakes do occur. If you find an error in one of our books, such as a spelling mistake or faulty piece of code, we would be very grateful for your feedback. By sending in errata, you may save another reader hours of frustration, and at the same time you will be helping us provide even higher quality information.

To find the errata page for this book, go to www.wrox.com and locate the title using the Search box or one of the title lists. Then, on the book details page, click the Book Errata link. On this page, you can view all errata that has been submitted for this book and posted by Wrox editors. A complete book list, including links to each book’s errata, is also available at www.wrox.com/misc-pages/booklist.shtml.

If you don’t spot “your” error on the Book Errata page, go to www.wrox.com/contact/techsupport.shtml and complete the form there to send us the error you have found. We’ll check the information and, if appropriate, post a message to the book’s errata page and fix the problem in subsequent editions of the book.

p2p.wrox.com

For author and peer discussion, join the P2P forums at p2p.wrox.com. The forums are a Web-based system for you to post messages relating to Wrox books and related technologies and interact with other readers and technology users. The forums offer a subscription feature to email you topics of interest of your choosing when new posts are made to the forums. Wrox authors, editors, other industry experts, and your fellow readers are present on these forums.

At http://p2p.wrox.com you will find a number of different forums that will help you not only as you read this book but also as you develop your own applications. To join the forums, just follow these steps:

1. Go to p2p.wrox.com, and click the Register link.

2. Read the terms of use, and click Agree.

3. Complete the required information to join as well as any optional information you wish to provide, and click Submit.

4. You will receive an email with information describing how to verify your account and complete the joining process.

You can read messages in the forums without joining P2P, but in order to post your own messages, you must join.

Once you join, you can post new messages and respond to messages other users post. You can read messages at any time on the web. If you would like to have new messages from a particular forum emailed to you, click the Subscribe to this Forum icon by the forum name in the forum listing.

For more information about how to use the Wrox P2P, be sure to read the P2P FAQs for answers to questions about how the forum software works as well as many common questions specific to P2P and Wrox books. To read the FAQs, click the FAQ link on any P2P page.

Part I: Microsoft SharePoint Server 2007

The first part of this book looks in detail at Microsoft Office SharePoint Server 2007 and how you can use it to help you organize and control the huge amount of information you are faced with each day. This part is also aimed at those of you who are not using Microsoft SharePoint Server (MOSS) 2007 but perhaps using Windows SharePoint Server (WSS) version 3. Much of the content in this section and the following section will also apply, so do not be put off if you don’t have MOSS.

From Microsoft Word documents to dealing with large corporate database systems, everyone is increasingly inundated with information, and it is becoming harder to organize and classify this information, not to mention simply find it when you need it. You are also faced with increasing legal requirements for the safeguarding and retention of information, and this can also be a difficult process to manage, not only on your own PC but also across corporate networks. This is where collaboration software such as Microsoft SharePoint comes in. It can help you organize, communicate, and share information and data across and outside your organization.

For the Microsoft Office 2007 user, SharePoint can be a huge program to come to grips with, and it can take some time to understand all of the features available to you. Not only that, but you then need to learn how it all fits together with Microsoft Office 2007 and perhaps Microsoft Office 2003. Again, this can be a confusing experience for many people. This part of the book focuses on those areas of SharePoint that you will need to understand in order to make full use of the software from within Microsoft Office 2007 in particular. For Office 2003 users, much of the interaction is the same, but the ease of use you will get with Office 2007 is just not there.

Using SharePoint

In this first section of the book, you will read about SharePoint and all of its various features, including working with and creating team sites, lists, and document libraries, and interacting with corporate data. Each area of the software is discussed, and many of the basic objects you need to understand will be demonstrated with lots of practical walkthroughs to help you understand how they work. Chapters have been designed to take you from the basics of understanding SharePoint to personalizing the software to bring the information and data you need to the front by using the highly customizable interface available to you.

Part 1 begins by looking at SharePoint, providing you with a detailed overview of the software, how it is structured, the features available, and more general information about the skills you will need to develop to take advantage of its many features. You then move on to look at each of the core areas in Microsoft SharePoint Office Server 2007 and Web Parts: what they are, how they can be configured, and how to use them to present information and documents to yourself and your colleagues. Each core feature is introduced to provide you with a general view of what’s available when you start using SharePoint.

Following this, many of the core features are examined in greater detail in the next four chapters. You create your first SharePoint team site, examining and working with its many features. You will look at the basic structure of the sites, including lists and libraries, providing you with a solid understanding of not only what they are but also how they can be used to help you in your work. Chapter 4 brings you into the world of SharePoint Web Parts. Every core Web Part that you will find in SharePoint is discussed and demonstrated with full working examples and walkthroughs, ensuring that you have a full understanding of how they work and when they are used — again, central to your understanding of SharePoint.

Finally, Part 1 of the book ends with a deep dive into SharePoint and customization — how you can configure the various areas of SharePoint to provide information directly of use to you, from creating personal views of SharePoint web sites to working with your own personal web space on the SharePoint server. You will also look at using SharePoint Designer 2007, which will enable you to extend and enhance many areas of SharePoint, including how you can begin to design the interface to your sites and access corporate information held in database systems. You will look at the additional workflow features of SharePoint Designer and how they can be used within your business environment to improve and enhance the software.

You will look at some of the social networking aspects of SharePoint and how they work in a business environment, such as how SharePoint will suggest associations between people you interact with in the SharePoint site.

All these areas are covered and plenty of walkthroughs are provided to give you some hands-on experience in trying out the various features.

Later in the book you will learn how to customize the basic design of your sites and work with SharePoint Server’s record management features to help you meet your auditing and legal requirements in terms of document auditing and retention. Straightaway, SharePoint will do a fair job in the record management area, but with additional free downloads available from Microsoft, it can become the record management repository for an enterprise, doing more than helping you meet your legal responsibilities. The chapter on record management will provide you with a great start in setting up and managing this area of the software.

SharePoint is a huge program, but sense this book, and specifically the way in which it is structured, will help you out on the road to learning how SharePoint works and how it fits together with Microsoft Office 2007. One of my favorite sayings is “from desktop to Internet:” the ability to take a document or other file and simply save it into the Web. SharePoint 2007 and Office 2007 make this a reality. I say throughout this book that no third-party software is needed to take your documents from the desktop to the Internet, and, indeed, that is the case within the SharePoint environment. All that is required is a simple File ⇒ Save As for your Office 2007 application, and you’re done. True integration between your desktop application and the Web.

For the programmers out there, it will also help to get a user’s view of how this software actually works and is used on a day-to-day basis by the people that matter: the people who have to use it. For the IT professional, SharePoint provides a huge opportunity to build applications that meet business needs; that is, the tools required by you to do your work. SharePoint provides almost all the tools you need within a business environment when you first install it but is extensible by professional development teams to be almost anything required to specific needs.

1

Microsoft Office SharePoint Services 2007 (MOSS)

According to some web sites and blogs, MOSS is the fastest-selling Microsoft software released in many years. Large numbers of blogs and support sites have grown up over the web, and many companies are now investing in this cure-all software.

Reviews of MOSS on the web range from the best thing to hit the IT industry in years to the worst bit of viral software in the world. From an IT perspective, MOSS is a little bit of both. Improperly planned and implemented it can be a huge problem to business, as web sites and portals can easily grow out of control. However, with proper planning and control it can be used with great effectiveness within almost any business. In this chapter, you will discover what MOSS is and how it works, and by the end of the book you will have a firm grasp of how to take full advantage of its capabilities.

The book is divided into two parts. Part 1 provides you with information on SharePoint, looking at many of its features. In Part 2, you will be concentrating on interaction with Microsoft Office 2007. MOSS also works with earlier versions of Microsoft Office, so don’t be put off if you are an Office XP or Office 2003 user. MOSS can still provide you with some great tools and applications to help you in your day-to-day work.

Two of the best sites for end user support are http://sharepoint.microsoft.com/blogs/GetThePoint/default.asp and www.endusersharepoint.com. Both sites provide lots of useful information and tips aimed at the amateur SharePoint user.

Why All the Hype?

Microsoft Office is perhaps the most widely used desktop application package in the business world. It’s available on virtually every desktop in every business. Over the last couple of years, there has been a general move toward making information available without regard to its location, and the access vehicle of choice for this has been the Internet. For example, Google Documents and Google Apps can be accessed via a browser. In the Microsoft world, Office Live allows you to save and store information, with the browser being the tool of choice to provide the interface to these web storage locations.

In the business world, documents and other information tend to be stored on file servers to which staff are given access, emails contain a huge amount of corporate information in terms of both content and file attachments, USB keys are widely used as a storage medium, and of course the hard drives of the PCs are in use every day. All of these spaces and devices contain useful business information that, by their nature, they lock away.

This wide variety of document and information storage locations also makes it difficult to see the whole range of information available within a company. Not only is information hard to find, but there are many legal requirements with respect to business documents, and it can be difficult if not impossible for a company to meet its responsibility with regard to data regulations when information is spread all over the place with few controls over its management in place. For example, how do you ensure that documents required to be retained by your company for legal reasons are actually stored centrally? How do you find all the required documents if you are subject to litigation? When documents are stored in a multitude of places, it is difficult to get a global picture of any particular activity, as the information could be located on a hard drive, in an email, or even on a USB stick. Software like SharePoint is an attempt to pull all of these diverse storage locations together and allow you to get a picture of all the information about a particular topic or organization. To SharePoint, it doesn’t really matter that you have information stored on file servers, other hard drives within an organization, or inside large databases — SharePoint, once configured, can discover it all.

Lesen Sie weiter in der vollständigen Ausgabe!

Lesen Sie weiter in der vollständigen Ausgabe!

Lesen Sie weiter in der vollständigen Ausgabe!

Lesen Sie weiter in der vollständigen Ausgabe!

Lesen Sie weiter in der vollständigen Ausgabe!

Lesen Sie weiter in der vollständigen Ausgabe!

Lesen Sie weiter in der vollständigen Ausgabe!

Lesen Sie weiter in der vollständigen Ausgabe!

Lesen Sie weiter in der vollständigen Ausgabe!

Lesen Sie weiter in der vollständigen Ausgabe!

Lesen Sie weiter in der vollständigen Ausgabe!

Lesen Sie weiter in der vollständigen Ausgabe!

Lesen Sie weiter in der vollständigen Ausgabe!

Lesen Sie weiter in der vollständigen Ausgabe!

Lesen Sie weiter in der vollständigen Ausgabe!

Lesen Sie weiter in der vollständigen Ausgabe!