Microsoft office access 2007 a rich client for windows sharepoint services 3 0
Download
1 / 13

Microsoft Office Access 2007 A rich client for Windows SharePoint Services 3.0 - PowerPoint PPT Presentation


  • 83 Views
  • Uploaded on

Microsoft Office Access 2007 A rich client for Windows SharePoint Services 3.0. Mark Bower Senior Consultant Microsoft UK http://blogs.msdn.com/bowerm. Challenges. Trend towards Web applications Centralised and Managed vs. Decentralised and ad-hoc Collaboration & Sharing

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Microsoft Office Access 2007 A rich client for Windows SharePoint Services 3.0' - landen


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
Microsoft office access 2007 a rich client for windows sharepoint services 3 0

Microsoft Office Access 2007 A rich client for Windows SharePoint Services 3.0

Mark Bower

Senior Consultant

Microsoft UK

http://blogs.msdn.com/bowerm


Challenges
Challenges

  • Trend towards Web applications

  • Centralised and Managed vs. Decentralised and ad-hoc

  • Collaboration & Sharing

  • MSDE & SQL Express


Introducing access 2007
Introducing Access 2007

Allows end users to easily track information, build quick business applications, and collaborate via Windows SharePoint ServicesGives professional developers and IT easy to customize and manage business applications that combine the best of the client and server

Pro Developers / IT

Power Users

Whole new class of apps integrated with WSS

Rich and reach interfaces

Server-side manageability

Utilize managed code

Confident upgrade path

End Users

WSS for collaboration

WYSIWYG authoringfor forms and reports

“Codeless” macros

Outlook data collection

Much easier to use

Out-of-the-box apps

Easy to add a field, form, and report


Better together
Better Together

  • Microsoft Office Access 2007

    • Rich visualizations

      • Easy to build

      • Easy to use

    • Use multiple data sources

    • Collect data via e-mail

    • Use the application offline

  • Windows SharePoint Services 3.0

    • Collaboration and workflow

    • IT Managed data source

      • Security

        • Web permissions

        • List item permissions

      • Archived

        • IT archives the server

        • Version history

        • Recycle bin

Build and deploy, reliable, IT managed applications easily


Let s build a solution
Let’s Build A Solution

  • A Sales pipeline (An Opportunity tracker)

    • Lists

      • Opportunities

      • Employees

      • Customers

    • Views

      • Multiple forms and reports


Where do we begin
Where Do We Begin?

  • Start anywhere

    • On the client with local data

      • Easy to use move and link wizard for SharePoint

      • Publish your views

    • On the server with SharePoint lists

      • Create your lists and link to them in Access

      • Create views as you go along


Deploying our solution
Deploying Our Solution

  • Today

    • Client / File share

  • Office 12

    • Deploy/ publish the latest version using the site

      • End-Users would get updated copies of the solution

    • Use out of the box or customized entry points to launch the solution

    • Enable design collaboration or lock down your application using SharePoint permissions



Recap
Recap

  • Deploying Access Solution to WSS

  • Creating a new Access solution from WSS

  • Using WSS as datastore

    • Conflict resolution

  • Offline

  • Data Collection in Email

  • Versioning and Recycle Bin


Raising the bar
Raising The Bar

  • Add external data

    • Using the client to fetch data from other sources

  • Using workflow

    • Process enforced on the server

    • Reported by the client

  • Set up reminders for reports

    • Create them on the client

    • Distribute them using the server



Why would i be interested
Why Would I Be Interested?

  • We’ve built an application that was

    • Easy to build, deploy, use

    • Managed by IT

    • Has rich and robust visualizations

    • Used multiple data sources

    • Multi user with workflow

    • Used offline

  • Key scenarios

    • Departmental Solutions

    • Small-mid market


ad