January 2007
Beginner
53 pages
1h 26m
English
Overview
Access 2007 is tightly integrated with SharePoint. This Short Cut provides readers with everything that they need to know about working with Access 2007 and SharePoint. Topics covered include why SharePoint is important to an Access 2007 developer, how to move your database to a SharePoint site, and how to open and work with SharePoint lists from within Access 2007. It also covers how to integrate with the SharePoint workflow, how to work with SharePoint services off-line, and how to map Access data to SharePoint data. All of these topics are necessary when integrating Access 2007 and SharePoint.
Alison Balter has been writing about Access since Access 95. She has written eight books, co-authored two books on Access, and has written one book on Microsoft SQL Server 2005 Express. Her books include Essential Access 95, Alison Balter's Mastering Access 95 Development, Alison Balter's Mastering Access 97 Development, Access 97 Unleashed, Alison Balter's Mastering Access 2000 Development, Alison Balter's Mastering Access 2002 Desktop Development, Alison Balter's Mastering Access 2002 Enterprise Development, Alison Balter's Mastering Office Access 2003 Development, Access 2003 In-a-Snap, Access 2003 in 24 Hours, SQL Server Express in 24 Hours.
Alison has over 13 years of practical experience working with Access and Access applications. Her clients’ projects range from small end-user projects through enterprise-wide applications. Clients include Archdiocese of Los Angeles, Southern California Edison, Accenture, Prudential Insurance, and the International Cinematographer's Guild.
Her Access skills are not limited to writing and programming. Alison has also been teaching Access and speaking at conferences for more than 12 years. Her training has included everything from end-user training to corporate training, in both the United States and Canada.
Table of Contents
Section 1: What is SharePoint Server 2007 and Why Integrate It With Your Access Applications?
Section 2: The Access 2007 (accdb) File Format and SharePoint
Section 3: Exporting Data to a SharePoint Site
Section 4: Publishing Data to a SharePoint Site
Section 5: Opening Access Forms and Reports from a SharePoint Site
Section 6: Linking to and Importing from SharePoint Lists
Section 7: Taking SharePoint Lists Offline with Access
Section 8: The Basics of Working with SharePoint
Section 9: Re-establishing Links When a SharePoint Site has been Moved
Section 10: Modifying the Design of an Access Database Stored on a SharePoint Server
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.