Jean Paul's Blog

There are 2 types of People in the World, One who Likes SharePoint and..

    Advertisements
  • Microsoft MVP

  • MindCracker MVP

  • CodeProject MVP

  • eBook on SharePoint 2010

  • eBook on Design Patterns

  • eBook on Windows Azure

  • NLayers Framework @ CodePlex

  • MSDN Forums

  • .Net vs. Java

    Due to Public Demand
  • Advertisements

Web Database Templates

Posted by Paul on April 26, 2012


There are many site templates included in SharePoint 2010.  In this article we can explore web database templates included in SharePoint 2010.  The 5 web database templates are:

1.      Assets Web Database

2.      Charitable Contributions Web Database

3.      Contacts Web Database

4.      Issues Web Database

5.      Projects Web Database

What is a Web Database Template?

Web Database Template provides Site Templates for Browser based interaction to an MS Access application.   Thus web database templates provide Centralized Access for the database file, Flexibility in working with Access application without having MS Access installed in the client computer etc.

SharePoint 2010 is having some pre build Web Database Templates for ready use.  These templates provide solutions to the respective area as their name denotes. 

Under the hood SharePoint has Access Service Application running to support the web database templates.  You can configure the service applications & services through Central Administration.

Advantages of Web Database

Following are the advantages of using Web Database:

·         Supports uploading of Access Application into SharePoint

·         Access Application can be accessed through a Browser

·         Centralized database storage for Access Application

·         Flexibility in downloading the application file and working offline

Note: There are thousands of users having created their own MS Access solution involving Tables, Forms and Reports.  The Access Service application allows them to Publish these solutions to the SharePoint site.


Pre-Requisites for Web Database

As the web databases are using Access Service Application and Access Services, following are the pre-requisites:

1.      Access Service Application has to be created and started in Central Administration

clip_image002

 

2.      Access Database Service has to be started in Central Administration

clip_image004

Is MS Access needed in Client Machine?

MS Access is not needed to work with Web Database site templates.  But having MS Access enables more flexibility in working as it allows opening server database file in the client side.

Using MS Access with Web Database

You can use the Open in Access action to edit the web database file.

clip_image005

Assets Web Database

The Assets Web Database provides a site template for managing Assets in an organization.  It provides Assets management through creating Current Assets, Retired Assets and Reports.  The Owner of the Asset can be managed through the Users interface. 

We can create new Assets Web Database template using Site Actions > New Site > Assets Web Database Template.

clip_image007

Following is the initial site instance screen:

clip_image009 

Charitable Contributions Web Database

The Charitable Contributions Web Database provides a site template for managing Charity Contributions activities.  The site provides pages to manage Donors, Campaigns, Users, Upcoming events and Reports.

We can create new Charitable Contributions Web Database template using Site Actions > New Site > Charitable Contributions Web Database Template.

clip_image011

Following is the initial site instance screen:

clip_image013

Contacts Web Database

The Contacts Web Database provides a site template for managing Contacts information.  The template provides Contact Entry Forms to capture Name, Email, Address, Phone details and Reports.

We can create new Contacts Web Database template using Site Actions > New Site > Contacts Web Database Template.

clip_image015

Following is the initial site instance screen:

clip_image017

Issues Web Database

The Issues Web Database provides a site template for managing Issues and Problems.    The template provides Issue Creation forms, Prioritizations and other screens to track the progress of fixing issues.

We can create new Issues Web Database template using Site Actions > New Site > Issues Web Database Template.

clip_image019

Following is the initial site instance screen:

clip_image021

Projects Web Database

The Projects Web Database provides a site template for managing Projects.  The template provides screens to manage Projects, Tasks, Customer, Assign Tasks and generate reports.

We can create new Projects Web Database template using Site Actions > New Site > Projects Web Database Template.

clip_image023

Following is the initial site instance screen:

clip_image025


 

Site Settings & Site Permissions

As the web database template instances are still Sites, we can use the Site Settings and Site Permissions options on them.

To access the Site Settings, choose the Options menu item from the title area.

clip_image026 

To access the Site Permissions, choose the Options menu item from the title area.

clip_image027

References

http://tinyurl.com/sp2010-accser

Summary

In this article we had an overview of the 5 web database templates in SharePoint 2010.  You can use the associated video to get more detailed information on them.  Although not widely used, the knowledge of these templates should be helpful in creating rapid solutions or reusing existing solutions around MS Access.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s