Testing Access Services

This is part of my series on testing SharePoint service applications: http://matthewchurilla.blogspot.com/2012/02/testing-service-applications-in.html

There is a good article on MSDN for setting up a basic web database using Microsoft Access: http://msdn.microsoft.com/en-us/library/ff402351.aspx.  This article will walk you through the basics of creating a few access tables, publishing your database to SharePoint and then adding data into the database.  The site even has a sample database you can use to do your testing(http://archive.msdn.microsoft.com/Release/ProjectReleases.aspx?ProjectName=odcac2010h2&ReleaseId=3921).  I like to use this sample database as a starting point for my testing once I have started with this database I like to perform the following actions on the stock database just to get a better test of the available functionality.

1. Use web form to add a supplier: Microsoft
2. Use web form to add a supplier: Apple
3. Use web form to add a supplier: Google
4. Use web form to add a part for supplier: SharePoint, Microsoft
5. Use web form to add a part for supplier: Office, Microsoft
6. Use web form to add a part for supplier: Windows, Microsoft
7. Use web form to add a part for supplier: iPhone, Apple
8. Use web form to add a part for supplier: iPad, Apple
9. Use web form to add a part for supplier: GSA, Google
10. Use web form to add a part for supplier: AdSense, Google
11. Use web form to add a part for supplier: Blogger, Google
12. Switch back to Access and ensure that data is populated back into the database.
13. Create a new report to test reporting.

1. Show all fields from all tables
2. Add "Supplier Name" to the report
3. Remove Column "Supplier"
4. Remove Column "ID"
5. Add a Group on "Supplier Name"
6. Your final report should look like this.
7. Synchronize the report back to the web
14. View the report in SharePoint

At this point you have performed a basic test of Access Services.  If everything outlined here worked you can be fairly confident your service is installed and working properly.  We will keep the database site published for now we might use it in future articles.  

Testing Service Applications in SharePoint 2010

So you've taken time and built a farm, but you still wonder how do I test all of this?  Well stay tuned this week I  am going begin writing a series on how to test each and every service application that ships with SharePoint 2010.  I hope that this will become a good resource for those of you, who like myself, would like to be able to test their farm and ensure it is running properly before releasing it to end users.  I will update this post as I release new articles in this series with links to each article.

Before testing applications setup a secure store: http://matthewchurilla.blogspot.com/2012/03/configuring-secure-store.html
Testing Access Services: http://matthewchurilla.blogspot.com/2012/03/testing-access-services.html