Putting together an educational slide show doesn’t have to be labor intensive. Using PowerPoint’s Photo Album tool, you can quickly assemble a series of screen shots and text slides for distribution as a training resource or as part of an informational package.

Trying to schedule training sessions for end users can be practically impossible — and attendance is never a sure thing, either. One good solution is to put together a series of annotated screen shots that illustrate a procedure or set of features or usage scenarios and create a PowerPoint presentation using those images. You can then distribute the presentation via e-mail, put it on the company intranet, share it on CD, or periodically host a brown bag lunch and run the slide show for those users who can make it.

It takes a certain amount of thought to grab the most useful screen shots and make sure your instructions are clear — but of course, that’s true of any training material or documentation you produce. At least you don’t have to worry about spending a lot of time creating the presentation. PowerPoint’s Photo Album feature makes that part of the process a breeze. Let’s run through the process.

Note: This information is also available as a PDF download.

First steps

Figure A

1. In the Photo Album dialog box (Figure B), you’ll find options for choosing the desired pictures.

Figure B

1. Click the File/Disk button to open the Insert New Pictures dialog box (Figure C).

Figure C

1. Locate and select the images you want to use and then click Insert. As Figure D shows, PowerPoint will place them in the Picture In Album List. You can use the up and down arrow buttons to reorder the images, if necessary.

Figure D

is cialis over the counter

1. By default, the Picture Layout option is set to Fit To Slide, which is what we want for this example. But with this setting selected, you can’t make any other design changes here. So go ahead and temporarily choose 1 Picture from the Picture Layout drop-down list to activate the other options.
2. Choose a Frame Shape option if desired — we’ll go with Beveled. Then click Browse and locate the design template you want to apply to your presentation. (This is optional, but you’ll probably want to improve the readability and appearance of the slides, and this is the easiest way to do it.)
3. There are various ways to add the instructions that will go along with your images, but to keep things simple we’re going to add a separate slide to hold the explanatory text that will precede each screen shot. To set this up, click the New Text Box button as many times as necessary, matching the number of images in your presentation (Figure E).

Figure E

1. Change the Picture Layout setting back to Fit To Slide and then click Create.

Final setup

The rest of the process is simply a matter of arranging the slides and entering/formatting the text. Figure F shows our sample presentation in Slide Sorter view. As you can see, all the text box slides are at the end of the presentation, so we’ll start by clicking on each one and dragging it to the correct spot.

Figure F

Once the slides are all in place, we can double-click each text slide to display it in Slide view, enter the instructions that will introduce the screen shot that follows, and format the text, if necessary. In this case, we selected the heading text (Step 1, Step 2, etc.) and made it 48 points. Then, we formatted the body text to be 32 points. Once we edited the title slide (which PowerPoint creates automatically for photo albums), the job was complete. Figure G shows the results.

Figure G

Tweaks

This is a somewhat quick-and-dirty way to pull together a training presentation, and you may want to make various refinements. For instance, you might decide to include your instructions on the same slide as its corresponding screen shot, or you may want more than one image per slide. But even with the bare-bones approach we’ve outlined here, you’ll find that you can convey a set of instructions quite effectively with a presentation like this.

PowerPoint also offers the advantage of portability, making it easy to distribute and share your presentation. Just choose Package For CD from the File menu to create a CD that contains all the necessary files, along with the PowerPoint Viewer. (Prior to PowerPoint 2003, this feature was called the Pack And Go Wizard.) You can also export the package to a selected folder instead of putting it on a CD.

When you need to know what objects are being created for a database, you can run generic soft tabs cialis a query against an Access system table to generate a list of all current reports and queries.

Ever wonder exactly what reports and queries are being created for a database? As an administrator, you may need a quick way of determining what reports and queries are being run against a database. Fortunately, Access stores the names of all the top-level database objects in a system table called MSysObjects. You can run queries against MSysObjects just as you would any other table in the database.  Follow these steps:

Figure A

1. In Design view, right-click the first list box and select Properties.
2. Under the Data tab, right-click the RowSource property box and select Zoom.
3. Enter the code as shown in Figure B and click Close.

Figure B

1. Right-click the second list box and select Properties.
2. Under the Data tab, right-click the RowSource property box and select Zoom.
3. Enter the code as shown in Figure C.

Figure C

When you run the form, Access outputs all current reports and queries for that database to the respective list boxes (Figure D).

Figure D

To access other object types, use their type value. For example, to list all the tables in the database, enter 6. To list forms, enter -32768. To list macros, enter -32766.

It’s useful to include some basic information in Access report footers, such as the name of the person who prepared the report. Here’s a simple way to prompt for the user’s name and insert it in the page footer.

Since a report is just a snapshot of a database at a certain date and time, generic cialis review it is helpful to include that information in the report printout. In addition to a time and date stamp, it’s also nice to have the preparer add his or her name to the end each report page. Follow these steps:

1. Click the Text Box control tool and then click and drag in the Page footer section of the report.

1. Select the text in the Label control, type Prepared by:, and format it as desired.

1. Click in the text box and enter the formula below, as shown in Figure A:

=[What is your name?]

Figure A

When you run the report, you’ll see the dialog box shown in Figure B.

Figure B

After the preparer enters his/her name, the report will output with a page footer like the one shown in Figure C.

Figure C

You can make your PowerPoint presentations far more engaging with a little animation sleight of hand. Susan Harkins walks through the process and shares a sample presentation to demonstrate the results.

An easy way to bring a presentation to life is to imply growth or movement. Insert a few AutoShapes, perform a bit of animation magic, and a simple graphic takes on a life of its own. Your message will stick with the audience long after you shut down the system and turn off the lights — and that’s what you’re after. Once you’re familiar with the process, you’ll find unlimited possibilities for adding a bit of life to your presentations.

Note: This information is also available as a PDF download, along with the sample  presentation used to demonstrate this technique.

An overview

The process for simulating growth or movement is simple. You string together a number of frames, similar to the process that creates cartoons. The graphic in each frame changes just enough to suggest growth or movement. Animation properties string the frames together, allowing the graphic to morph from one frame to the next. The simplest animation can require as few as three or four frames. As a general rule, the slower the process, the more frames you need.

Suggesting movement

There are a number of ways to suggest change by using movement to make a point. You could help a flock of birds soar into the sky or send a rocket into space. We’ll work with a much simpler example — we’ll make a frowning face smile!

This example requires three frames: A frowning face, a neutral face, and a smiling face. You could add more to make the change smoother, but three is enough for our purposes and it keeps the example simple and easy to follow. To begin, use AutoShapes to create the frowning face. Specifically, use three circles from Basic Shapes and an arc from Lines. That’s the first frame.

The second and third frames are even simpler. Off to the side (in the same slide) create a straight line and a second arc to fill the neutral frame and the upturned smile frame, respectively. Keep in mind that the size of all three smiles must be relatively the same. The easiest way to create the upturned smile is to copy the frowning smile and rotate it. That way, the smile is the same size as the frown. When creating the neutral frame, you’ll just have to eyeball it.

Once you have created all three frames, as shown in Figure A, you’re ready to animate them. Notice that the second and third frames contain only the parts that move. That won’t always be the case. Sometimes, each frame contains a complete picture, but work with as few pieces as possible when you can.

Figure A

generic cialis professional border=”0″ alt=”frown” title=”frown” width=”500″ height=”425″ />

Use three frames to simulate turning a frown into a smile.

The animation settings determine how PowerPoint displays each frame. In this case, PowerPoint displays the frowning face as a whole picture. As the frown fades, PowerPoint fades to the neutral frame. As the neutral frame fades, PowerPoint displays the upturned smile frame. Complete this animation as follows:

Once you’ve animated each frame, stack them as shown in Figure B. That way, the three smiles fill the same space as the frames fade in and out. Now, save the presentation.

Figure B

 Stack the frames so they seem to occupy the same space.

To preview the animated slide, press [F5]. The effect isn’t visible online so be sure to download the demo presentation for a complete picture.

The first frame (the frown) doesn’t have an Entrance effect, and the last frame (the smile) doesn’t have an Exit effect. That means the frown is present from the beginning — it doesn’t fade in. Similarly, the smile doesn’t fade. You can change both, if it suits your purposes.The fading entrance and exit properties and the speed between those fades simulate movement between the three faces. That movement creates mood. Make sure the mood fulfills or supports your message. You can alter the entrance and exit effects and speeds to customize the general mood of the animation.

The smiling face example uses a combination of With Previous and After Previous settings. There are three possible settings:

• On Click: You must click the slide to start the animation.
• With Previous: Animation begins as the previous item ends.
• With After: Animation begins immediately after the previous item is finished.

Remember, these properties determine how PowerPoint displays and subsequently hides each frame. The frown fades after its animation is complete. The neutral frame fades in as the frown fades out. Each frame repeats this structure. You can change those effects, slow them down, speed them up, and even combine them. You could also move several pieces in each frame. For instance, you could change the shape of the eyes or even let the face wink.

The one problem with this particular example is that PowerPoint can’t replicate a natural smile. That natural process is too smooth. You can add more arcs to make the process smoother, but you can’t truly blend one frame into the next. You can only give the illusion of doing so. Don’t try to imitate life, just allude to it You’re after the sentiment, not a realistic rendition.

Suggesting growth

The technique for implying growth is the same as for movement. Only the essence of the message and the result differ. This time, the example graphic, a red heart, grows a bit, making it seem to pulse.

First, you need the frames. The three hearts shown in Figure C increase in size. Use the instructions from the last example to apply the same animation scheme, except for the speed. Use Medium speed instead of Fast.

Figure C

Animating three different-size hearts suggests a growing and pulsing heart.

After applying the animation settings, stack the hearts in the center of the slide, as shown in Figure D. You can’t tell it, but the two smaller hearts are under the largest heart. To view the animation, press [F5]. The timing is a bit slower this time, but the frames fade into one another as the previous example did. The slower fades seem to give the heart a pulse.

Figure D

Stack the three frames and watch the heart grow.

To life!

Liven up a presentation with a little movement or growth. At first, the process requires some experimentation, but the more you work with animation settings, the more intuitive they will become. Remember, anytime you engage the audience in a fun and meaningful way, you influence those viewers in a positive way.

• Date: December 2nd, 2008
• Author: Mary Ann Richardson

You can update your combo boxes on the fly with the help of an Access shortcut. generic cialis overnight Mary Ann Richardson explains how it works.

Combo boxes let you type an entry into a field and select the entry again whenever you need it for another record. However, Access runs the query to the combo box only when the form is opened. If you add a new entry to the field, it will not appear in the list until you reopen the form. Fortunately, there’s a quick way to update your combo box without having to open and close the form.

For example, say you are entering data for a number of employees whose zip code is 07056. You enter the code for one employee. Then, when you enter the next one, you find that zip code is not on the list (Figure A).

Figure A

Follow these steps:

1. Press Shift + F9.

This is the Requery shortcut, which takes you back to the first record. When you click on the combo box to update any record, 07056 is now displayed, as shown in Figure B.

Figure B

You can use the Requery key to update any control based on SQL data.