Home > Articles

  • Print
  • + Share This
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 2Figure 2 To keep score for a corporate competition, you can use a form to enter data into an Access table.

Figure 3Figure 3 A click event calculates the results and launches a PowerPoint presentation in slide show mode that projects the results.

  • + Share This
  • 🔖 Save To Your Account