- Charge Up Your Audience
- PowerPoint as a Scoreboard
- Automating the Process
- How Did We Do That?
- How It Works
- The Grand Finale
Like this article? We recommend
Like this article? We recommend
Like this article? We recommend
So far, all you need to do is create a simple PowerPoint chart slide, insert the data you want, and animate the process. But what if you just want to punch the data into an application, and create a PowerPoint slide based on the result? That's where Office automation comes in, and you need to conceptualize an "application" that will keep score, and that can control PowerPoint. While Excel can do the job, so can Access, and what I decided to do for The Ketter Group, which wanted an Olympic medal ceremony theme, was to construct a simple database to keep score for various corporate competitions—you can find these kinds of exercises in books like Scannell and Newstrom's Games Trainers Play (McGraw-Hill has a whole series of them).
In Figure 2, an Access table holds information that's entered into a form. When the Present button on the form is clicked, the scores for the event are calculated and the medal ceremony is displayed, with the correct teams receiving bronze (third place), silver (second place), and gold (first place) medals for that event (see Figure 3).
)
Figure
2 To keep score for a corporate competition, you can use a form to enter
data into an Access table.
)
Figure
3 A click event calculates the results and launches a PowerPoint
presentation in slide show mode that projects the results.