SharePoint 2010 Access Services
Another SharePoint Server 2010 feature which cannot go unnoticed is the Access Services. Access Services is a service in SharePoint 2010 that allows administrators to view, edit, and configure a Microsoft access application within a Web Browser. Access Services settings support backup and recovery, regardless of whether there is a UI setting in Central Administration. However, backup and recovery only apply to service-level and administrative-level settings; end-user content from the Access application is not backed up as part of this process. Access Services has Windows PowerShell functionality that can be used to provide the service that uses settings from a previous backup; configure and manage macro and query setting; manage and configure session management; and configure all the global settings of the service.
Key Benefits of Access Services
Easier Access to right tools: The enhanced, customizable Ribbon in Access 2010 makes it easy to uncover more commands so you can focus on the end product. The new Microsoft Office Backstage™ view is yet another feature that can help you easily analyze and document your database, share, publish, and customize your Access 2010 experience, all from one convenient location.
Helps build database effortlessly and quickly: Out-of-the box templates and reusable components make Access Services the fastest, simplest database solution available. It helps find new pre-built templates which you can start using without customization or select templates created by your peers in the Access online community and customize them to meet your needs. It builds your databases with new modular components. New Application Parts enable you to add a set of common Access components, such as a table and form for task management, to your database in a few simple clicks. Database navigation is now simplified. It creates Navigation Forms and makes your frequently used forms and reports more accessible without writing any code or logic.
Create Impactful forms and reports: Whether it’s an inventory of your assets or customer sales database, Access 2010 brings the innovative tools you’d expect from Microsoft Office. Access Services easily spot trends and add emphasis to your data. It quickly create coordinating database forms and reports and bring the Web into your database.
Obtain a centralized landing pad for your data: Access 2010 offers easy ways to bring your data together and help increase work quality. New technologies help break down barriers so you can share and work together on your databases, making you or your team more efficient and productive.
Add automation and complex expressions: If you need a more robust database design, such as preventing record deletion if a specific condition is met or if you need to create calculations to forecast your budget, Access 2010 empowers you to be your own developer. The enhanced Expression Builder greatly simplifies your expression building experience with IntelliSense®. With the revamped Macro Designer, it’s now even easier for you to add basic logic to your database. New Data Macros allow to attach logic to your data, centralizing the logic on the table, not the objects that update your data.
Key features of Access Services 2010
o Access database content through a Web browser: Newly added Access Services on Microsoft SharePoint Server 2010 enables you to make your databases available on the Web with new Web databases. Users without an Access client can open Web forms and reports via a browser and changes are automatically synchronized.
o Simplify how you access the features you need: The Ribbon, improved in Access 2010, helps you access commands even more quickly by enabling you to customize or create your own tabs. The new Microsoft Office Backstage view replaces the traditional File menu to provide one central, organized location for all of your document management tasks.
o Codeless navigation: Use professional looking web-like navigation forms to make frequently used forms and reports more accessible without writing any code or logic.
o Easily reuse Access items in other databases: Use Application Parts to add pre-built Access components for common tasks to your database in a few simple clicks. You can also package common database components, such as data entry forms and reports for task management, and reuse them across your organization or other databases.
o Simplified formatting: By using Office themes you can create coordinating professional forms and reports across your database. Simply select a familiar and great looking Office theme, or design your own, and apply it to your database. Newly created Access objects will automatically match your chosen theme.
Now you must be thinking how to create a new Access Services Web database from a template. Follow the below procedure
Open the SharePoint Central Administration Web site.
o Choose Site Actions.
o Choose New Site.
o On the Create site page:
a) Select Web Databases
b) Select the template you wish to use.
c) Type a Title that closely matches the site’s intended use.
d) In the URL Name box, type a short version of the title you specified above.
e) Click More Options.
f) In the Description box, type a brief description of the site’s details.
g) Select Use same permissions as parent site.
h) In the Navigation section: Select Yes.
i) In the Navigation Inheritance section: Select Yes.
o Click Create.
Thus, if this feature of SharePoint 2010 interests you, try using it as per your requirement!
Take advantage of SharePoint Access Services and other useful features of SharePoint 2013 hosting, SharePoint 2010 hosting SharePoint Foundation hosting or SharePoint Server 2010 – with shared or dedicated hosting by Apps4Rent. Also see feature by feature comparison of SharePoint Foundation vs Server 2010. We offer free SharePoint with our hosted exchange plans. Microsoft Office SharePoint Server 2007 or MOSS 2007 is also available.