by Oscar
3. February 2009 23:18
Not many people actually use this built-in functionality. But one can easily edit data in bulk using Access 2007 and create useful reports against that data using Excel 2007 or Access 2007.
Getting Started
To do this, first go to your existing Properties List, and click on Actions > Open with Access
A dialog comes asking if you would like to Link to the SharePoint List, select Link to data on the SharePoint Site, this will keep your Access 2007 database in synch (bi-directional).
Now you can add/edit/delete data offline/online. Once you are happy with your changes, you can synch back by right-click on the Properties List, select SharePoint List Options > Refresh List.
You can verify your changes took effect by simply browsing to the SharePoint List (on my test, it did in fact create my sample test record pictured below)
Happy editing!
-O
by Oscar
1. February 2009 23:12
I used to use Visio 2007 for wire frames, but it was a daunting task to update those wire frames! Now I am using Mockups by Balsamiq.com
It is quite amazing how fast you can prototype pages, basically in minutes you can have several pages mocked up. This tool is perfect for working sessions with business users to quickly get on the same page in terms of page elements and functionality.
Just look at the difference!
FIGURE 1 – Visio 2007 page wireframe
FIGURE 2 – My Portal Home Page done in Mockups
This tool is good for prototyping the UI of any application!
O
Subscribe