The purpose of this session is to provide cost free solutions for five scenarios. The main thing learned here was that there is some new functionality in Access that can be used to quickly handle some of the problems shown below.
- Using MS Access as a front-end for SQL Server. Can empower the users to create their on solutions. Would be for power users only.
- Scenario 1 - Access RESTful data such as Twitter and Amazon.
Can use the REST technology which is an API. Write very minimal code and the item is parsed as XML. Code will be posted on the TechEd site. Can create forms from the table using the form features on the create menu.
- Scenario 2 - Ad hock querying and reporting
Use Access as a front-end adhoc report writer
Create specific reporting tables, stored procedures or functions and then create read access to all with an ODBC data source. They would then link to them. There is a new common table expression in SQL Server 2008.
SQL Pass-Through Query inside of Access – is a regular access query that has an ODBC connection. You have to provide a valid T-SQL to SQL Server. Can execute SQL Server store procedures this way.
- Scenario 3 - Scalable data entry with Table value parameters (TVPS)
Must use a SQL Pass-Through Query
Code sample is out on the TechEd site.
- Scenario 4 – Sharepont Integration
Performing analytics on the data in Sharepoint.
Run ad-hoc queries on a Sharepoint Lists. Go to external data and select sharepoint lists.
- Scenario 5 - Agile Prototyping Tool
Some neat stuff here, but might find some resistance by the developers because this is not their expertise.
Posts
Is this with Access 2007? How is this different from today? I guess it's easier somehow?
ReplyDeleteEven if the developers never use this approach (which is fine), it is always useful for others in the IS-Apps group to have this in their bag of tricks wrt #2 and #5. Thanks for going to this session.