You can use your favorite social network to register or link an existing account:
Or use your email address to register without a social network:
Sign in with these social networks:
Or enter your username and password
Forgot your password?
Yes, please link my existing account with for quick, secure access.
No, I would like to create a new account with my profile information.
Today’s guest writer is Barath Balasubramanian —a Design Engineer in the Access test team.
As the excitement about the 2010 world cup in South Africa intensified, I set out to build an application to gather predictions on the results of the tournament from my team mates. Since all of my team mates have access to a SharePoint server, I decided to build the application using Access 2010. In less than two hours I was able to create a cool looking application that can not only track the 2010 FIFA world cup predictions, but can also be customized to fit any tournament format and runs in IE, Firefox and Safari.
The application has simple UI to perform the following tasks:
· A form to make predictions and to create brackets.
· A continuous form to list all predictions.
· A datasheet form to expose the raw data (this can be used to export data to external reporting tools)
Creating the bracket:
Using combo box controls, text box controls and UI Macro actions, I was able to quickly stitch together a simple UI to create tournament brackets. Since the data is driven via tables, it is very easy to re-use this form to track any tournament.
Once you pick the 1st/2nd place teams the first column in the bracket tree will automatically be filled out, then you can click the team you think will win in order to fill out the bracket tree.
Once you fill out the tree you simply click save.
Tracking the Brackets:
Once people start filling out the brackets, they can be tracked via this continuous form, which provides a ‘View’ button next to each bracket. A UI Macro action hooked to the ‘View’ button, navigates he page to show details of a specific bracket.
Exporting Data for further processing:
Depending on what tournament is being tracked, one may want to export the data into other systems like Excel charts/Power Pivots and hence a datasheet view of the Raw Data is provided via the UI.
Create your own:
To help jumpstart customization of this template, I added a form with instructions to download and to play around with the application.
Here is a link to the template.
You can either open in via Access 2010 client or directly instantiate the template via Office SharePoint Server 2010. There are multiple other ways to create this template and I would love to hear how you customized this template to suit your needs. Feel free to ping me at Barath.Balasubramanian@microsoft.com
This a great application for getting predictions.
This is great especially to us football fans.
There was an issue with the link requiring a liveID... just updated it so it should work now.
Is there a version for Access 2007?
@IT RN: This application is using some of the new features in Access 2010 like the Navigation Control, UI Macro actions, etc which are not available in the previous versions.
Is it mandatory to have Office 2010 RTM to get this work? Its giving following error in Office 2010 Beta: Template 'TournamentBrackets.accdt' could not be instantiated. This template's objects are saved in a format that requires a newer version of Access.
@Kamlesh: Yes, you need to instantiate this template using Access 2010 RTM. You may use the trial version available for download from http://www.office.com