Access 2010/ sharepoint help..

I working on adding a filter to a exsisting report in Access 2010 in a Sharepoint enviornment.  Whats the best way to go about adding this feature, since im under the impression sharepoint does not support code modifications.
IT_newbie01Asked:
Who is Participating?
 
Richard DanekeConnect With a Mentor TrainerCommented:
If you are trying to apply a filter to present the filtered data, Access can work with a Sharepoint list as a linked table (like it can with Excel, SQL, or other lists).   Here you can filter the data and export the list back to Sharepoint site.

or  any user can run the Access program to filter and work the data in a small Access program

or you can use Access 2010 to create a web-based Access environment to filter without having Access installed on each users' workstation.
0
 
IT_newbie01Author Commented:

or you can use Access 2010 to create a web-based Access environment to filter without having Access installed on each users' workstation.

This is exactly the option i want to employ.  Do you have an example of how to do this??
0
 
Richard DanekeTrainerCommented:
You can create a web database from a template.
Here is an MS link:
http://office2010.microsoft.com/en-us/access-help/publishing-to-access-services-HA101862691.aspx

How well do you know your sharepoint environment?  Access  Web services have been available in the Sharepoint environment in 3.0, 2007 and 2010.   Which Sharepoint environment are you using?  Office365 Sharepoint includes the Access Web services.
0
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
IT_newbie01Author Commented:


I'm using Access 2010 (from what i read Office 365 is just another name for this suite) and i know very little about the sharepoint enviornment.  I'm familiar with Access 03 but see 2010 has changed considerably!  Not to sound like a noob but i was looking for picture and heavy descriptive documentation.  
0
 
aikimarkCommented:
Access2010 and Office365 are two different animals
0
 
IT_newbie01Author Commented:
Maybe this should be a new question: What's the best to publishing an Access report to the web that's filterable (drop-down list)??? I'm reading alot that suggest a lookup table.  Is creating a drop-down list even possible when dealing with Access  Web services???

THANKS IN ADVANCE!!!
0
 
IT_newbie01Author Commented:
Ok, apologies i misread.  I'm using sharepoint 365.  
0
 
Richard DanekeTrainerCommented:
You should open a web template in Access 2010 and see if you can publish the sample database to your SharePoint site.  If you have Office365, the sharepoint includes Access Web services.

Since you have Office2010, another option is to save your list as an Excel table with autofilters.   This would permit your users to filter as necessary.  
0
 
IT_newbie01Author Commented:

Ok, I actually only have Access 2010.  Are you suggesting not attempting to use Access/ Access Web services to create a filterable table????  But suggest using Excel table with auto-filters?? If so why?? What would be the disadvantages/ advantage??
0
All Courses

From novice to tech pro — start learning today.