Topics for the final Access test

Sharing Data
• import data from Excel (no field titles)
• import data from Excel (with field titles)
• export data to Excel
• export data to a Word table
• import data from / export data to a delimited text file

Data Validity
• input masks
• validation rules
• lookup fields

Data Access Pages
• create a data access page using the wizard
• change data or add a field in Internet Explorer using a DAP

Relational Databases
• import data from Excel
• create relationships among field in several tables
• create a report with data from several tables
Note: The test will NOT cover Ex. 4, Step 8 (Enforcing Referential Integrity, Cascade Update Related Fields, Cascade Deleted Related Fields).

Powering Up Powerpoint (Part 5) -- YouTube Videos in PowerPoint

YouTube Add-in for PowerPoint 2003

As you take the above tutorial, you will be asked to place a .ppa file in your PowerPoint folder. You can find the file in the Pickup folder.
Also in the Pickup folder is a copy of the file named beemovie.mpg, in case you have trouble downloading it.

Powering Up Powerpoint (Part 4) -- Playing movies from video files

Play movies in Microsoft Office PowerPoint® 2003 and control how they start and how long they play. As an extra, create buttons to run them.

Everybody likes movies. In PowerPoint, take your audience away with a dramatic movie clip that helps get your point across. Or play film of a dynamic speaker. Or, play something fun just to engage people. There's nothing like the entertainment value and flash of a multimedia show.

In this lesson, work with movie files so you know how to insert them, play them, and set other options for them. For visual impact, create buttons that play, pause, and stop a movie.

After completing this lesson you will be able to:

* Insert a movie, start it the way you want, and work with various movie options.
* Play a movie full-screen and keep it from showing on the slide.
* Create buttons to run a movie.
* Ensure that a movie plays when you present.

Play movies in Microsoft Office PowerPoint® 2003
Note: If you have trouble downloading the sample movie file named "beemovie.mpg," you can get a copy from the Pickup folder.

Powering Up Powerpoint ( Part 3) -- Playing sound

Note: You will need earphones to work with sound on the school computers. You may also wish to bring a music CD to experiment with.

Make a sound file play when you want it to, even over several slides, in a Microsoft Office PowerPoint 2003 presentation. Also learn how to play a CD with your show.

This lesson tells you how to play sounds in a presentation—how to start them and make them play when you want, for as long as you want. Make a sound repeat, and get tips on hiding the sound icon on a slide.

You'll also see how to hit just the right note by playing music from a CD with your slide show.

After completing this lesson you will be able to:

* Insert a sound file and play it continuously in a slide show.
* Play a CD for a slide show and set its tracks.
* Change how a sound starts, make it repeat, and hide its icon.
* Guarantee that your sound will play when you present.

Playing sound in PowerPoint 2003

Powering Up Powerpoint ( Part 2) -- Animation with time delays - using t

Working with motion paths and timelines is a lot of fun, so do the tutorials and the practice file (The timeline.ppt), be creative and experiment for yourself.

All you need to add to your existing Powerpoint presentation (e.g. Ppt_HannahM.ppt) are two more slides.

• a slide with two animated objects with one of them timed to begin "with previous" and delayed by 1.0 seconds
  
• a slide with three animated objects - use the Advanced Timeline
  
  Be sure to give each slide a descriptive title, such as "Three animated objects - using the Advanced Timeline" and put your name on each slide.
  

In the earlier animations lessons, you learned to control animation timing by playing effects together or one after the other. You also used speed settings such as Fast and Slow. This lesson discusses additional ways to start animations, mainly by using time delays. A time delay allows you to start an effect a certain number of seconds after another effect has started, and before it finishes. The result is an overlap of effects—they don't have to be completely simultaneous or sequential. Also, you will learn to use the Advanced Timeline to synchronize animation timings and set animation speed. After completing this lesson you will be able to: * Create overlapping effects by using time delays. * Learn different ways to create time delays, and explore other timing options. * Use the Advanced Timeline to get a new view of an animation sequence and adjust how effects play together. Animations III: Time delays and other options – the timeline

Powering Up Powerpoint (1) -- Custom Animation with Motion Paths

Expand your animation horizons in Microsoft® PowerPoint® with motion path effects. Discover types of paths from preset lines, curves, and shapes to custom paths that let you scribble freely. You'll learn good uses for paths, how to edit them, and about options and tricks available for them.

Take Microsoft's tutorial at Custom Animation with Motion Paths

Powering Up PowerPoint -- Refresher on basic animation in Powerpoint

Do you need to refresh your knowledge of basic animation in PowerPoint (making text and pictures fly in, bounce, zoom out, etc)? Microsoft has a good tutorial at
Animations I: Preset and custom animation

---

Powering Up Powerpoint -- the agenda for this unit

The final test of the year will be on MS Word and will take place next week, after several fields trips are over.

We begin this week with some advanced features for Powerpoint. Then we will do a review of MS Word.

The advanced techniques for Powerpoint that we cover may include:
• Animation with motion pathsDiscover uses for motion paths and apply both preset and custom types. - Use paths to move text around on a slide and create a custom entrance effect. - Become skilled at manipulating and editing paths on your slides. - Know about options and tricks you can use with paths.
  
  
  
• Animation with time delays - using the Timeline - Create overlapping effects by using time delays. - Learn different ways to create time delays, and explore other timing options. - Use the Advanced Timeline to get a new view of an animation sequence and adjust how effects play together.
  
  
  
• Playing sound - Insert a sound file and play it continuously in a slide show - Play a CD for a slide show and set its tracks - Change how a sound starts, make it repeat, and hide its icon. - Guarantee that your sound will play when you present.
  
  
  
• Playing movies - Insert a movie, start it the way you want, and work with various movie options. - Play a movie full-screen and keep it from showing on the slide. - Create buttons to run a movie. - Ensure that a movie plays when you present.
  
  
  
• Linking to live YouTube videos
  
  
  
• Downloading and converting YouTube videos to use in your presentation
  
  
  
• Packaging your presentation An easy way to package your presentation files and carry them to present elsewhere or give them to someone else to view. Bundle your presentation, all the files that link to it, related files of your choice, and the PowerPoint Viewer onto a CD or into a shared folder.
  The viewer, which runs presentations on a computer without PowerPoint, is optional. If you don't have a CD burner, package all your files to a folder instead, and copy the folder to a system that has a CD burner, or share it on a server.
  
  We will cover as much of this as we have time for.
  
  For a complete list of Microsoft's excellent PowerPoint 2003 tutorials, go to Microsoft PowerPoint 2003 tutorials
  

Databases - review & first topic on MS Access 2003

This week we begin our study of databases, using Microsoft Access 2003 as our main example.

If you did not take the grade 9 BTT1O1 course, you will need to learn the basics of creating a table in Access and adding data to it. There is a review document on http://bta.posterous.com/ and therea re video demos on the Jarvis website at http://tinyurl.com/jd5w.

Our first Access topic this year is sharing data between various programs. There are instructions in your yellow booklet, as well as in a document on http://bta.posterous.com/.