Microsoft® SharePoint® 2007 for Office 2007 Users

Chapter 7. Microsoft Office Access 2007

In this chapter, you will work with Microsoft Access 2007 both from the desktop and from the server. For those who may be new to Access 2007, you will start of with a quick review of what's new with this application and how you can use the new features to help you get the job done. You will see how Access can enable you to build interfaces to your list data, take data offline and synch to the server later, and how to create reports using Access 2007. You will also see how you can incorporate data held on a SharePoint Server with applications created solely using Access 2007.

Microsoft Access is perhaps the most widely used desktop database in the world, used by professional developers and general PC users to store information, ask questions of information, and report on information. One of the most frequently asked questions when working with Access applications is "Can I get this on the Internet?" In terms of SharePoint, the answer is absolutely. Do you need to be a technical genius to do it? A resounding no. Microsoft Access is used for a large number of different things, from keeping small lists of data to full-blown desktop applications that run entire businesses. It can be used for things as simple as keeping a record of your DVD collection to running a material-processing operation for a small business. You can interact with Word to produce letters and mail merge, you can interact with Excel to produce complex statistics based on the ...