When solicitng ideas from a team of people and then gauge the team’s interest in each of the ideas, you can now avoid a lot of this back-and-forth email by using Microsoft Access 2010 and Access Services on SharePoint. “With these tools, you can build a social-media-like system that is available to your colleagues via a browser, letting them enter their ideas as well as “rate up” the ideas they like,” revealed Microsoft.
“To demonstrate this capability to their Microsoft colleagues, three members of the Access product team created a Valentine’s Day-themed system, dubbed “AccessLove.” The database allowed Microsoft staff to enter their ideas for their perfect Valentine’s Day gift or activity, and to “rate up” the ones they thought were the best.”
As a result of that response, the creators of AccessLove decided to present a “how we did it” session to show how easily anyone could build a similar system from scratch — and recorded videos of that session, you can watch the videos embedded below and follow along with the procedures on Office.com! linked under this post.
You’ll learn some great tips for designing a professional-looking form, creating a data macro, and publishing to Access Services.
- Part I: Building the database
- Part II: Formatting the form and adding logic
- Part III: Publishing to Access Services
- Next Steps
You can follow the complete walkthrough