Free Microsoft Office Training and Tutorials Blog




    



56 Microsoft Access Tips

Tony's Microsoft Access Tips web site offers 56 useful tips and techniques for using Access correctly and squeezing more functionality out of its features.

Most accessed tips

Tips

Troubleshooting and errors


357 Microsoft Access Tutorials, Tips, and Techniques

The Access Web offers 357 excellent learning articles and tutorials to help you master the features and functions of Microsoft Access. Below is the listing of all the tutorial articles, tips, and techniques covering Access on this website, grouped by topics.

357 Microsoft Access Tutorials, Tips, and Techniques


APIs
Bugs
Date/Time
Forms
General
Modules
Queries
Reports
Resources
Strings
Tables


» APIs

  1. Call the standard Windows File Open/Save dialog box
  2. BrowseFolder Dialog
  3. Enumerating Local and Network Drives
  4. Shell and Wait
  5. Return a unique filename in a sequence
  6. Search for a file
  7. Find out if an application is currently running
  8. Get Login name
  9. Get computer name
  10. Return temporary, system, and installed directories
  11. Play MIDI/Avi/Wav files
  12. System Metrics
  13. Get Class name of a running app
  14. Return a temporary unique file name
  15. Read a value from the registry
  16. Exit Windows
  17. Retrieve Locale Info
  18. Start an app with ShellExecute
  19. Manipulate Access Window
  20. Get Short and Long file names
  21. Make code go to Sleep
  22. Remove Close button from maximized forms
  23. Find the associated EXE file
  24. Daylight Savings Time & PreciseDateDiff
  25. Close another Application
  26. Copy a database
  27. hWnd of Controls
  28. Change cursor while editing
  29. Detect Available Resolutions
  30. Interrupt running code
  31. Access/Office and AddressOf Operator
  32. Drag and Drop from Explorer
  33. Enumerating System Fonts
  34. Detect Application Activate/Deactivate
  35. Put an image in Access window
  36. Track IntelliMouse's Wheel
  37. Suppress the "Printing" Dialog
  38. Suppress the "Loading Image" dialog
  39. Retrieve NT Server's Time
  40. Retrieve Current User's NT Domain
  41. Preventing multiple instances of a database
  42. Copy an image to the Clipboard
  43. Put a custom icon in the form's caption bar
  44. Displaying a custom Mouse icon
  45. Subclassing form for SysTray functionality
  46. Replacement for Sendkeys
  47. Enabling Full Row Select in a ListView
  48. Enabling Full Row Select in a Treeview
  49. Copy variables/control contents to memory
  50. Rotate Text
  51. Read/Set Internet Explorer URL from code
  52. Determining Combobox's Dropped state
  53. Drawing images on an Access form
  54. Retrieving a Special Folder's location
  55. Retrieving Operating System Name
  56. Changing button captions in GetOpenFileName dialog
  57. Removing Min/Max/Close buttons from a report's Preview Window
  58. Enumerating user accounts in a NT Domain
  59. Changing Access's Priority under NT/Win2000
  60. Calling Windows Choose Color Dialog
  61. Calling Windows Choose Font Dialog
  62. Return the UserID currently logged on a remote machine
  63. Close the VBE window in Access 2000
  64. Change the ForeColor and Bold properties of a selected node in Treeview
  65. Get Version of Office Exes (detecting Office patches)
  66. Get full name of the user currently logged in to the system
  67. Perform IP Lookups and resolve addresses
  68. Bypassing Autoexec
  69. Find out if the database container window is currently visible

» Bugs

  1. Common Functions like CurrentDB, str$, Mid$ fail to work
  2. Automation Error error messages, unable to change/save/delete a database object
  3. Cannot Start Data Access Object error message
  4. Numlock key keeps turning off
  5. Access minimizes to Windows 95/NT toolbar instead of closing
  6. Database name isn't an index this table
  7. Run-Time Error 429: ActiveX component can't create object
  8. Solving Access IPFs with /Decompile
  9. Error registering Comcat.dll in registry during Install
  10. Error 3014 - Can't Open Any More Tables
  11. Mailmerge starts new instance of Access
  12. Bookmark Bug
  13. License problems
  14. Office SR1 does not work in Win 98
  15. Report returns more records than query
  16. Access bugs fixed by Office 97 SR2
  17. Couldn't Find Installable ISAM
  18. Hyperlink with "mailto:" tag opens two windows
  19. Error 53 when calling functions from custom DLL
  20. Compile Error in Hidden Module
  21. Maximum length strings crash Access Security Wizard
  22. Solving VBS Error '800a01ad' on CreateObject in ASP/IIS
  23. Code changes are lost during a recompile of code
  24. TransferDatabase Causes Page Fault If Object Exists
  25. Undefined Function in Expression (Error 3985)
  26. Form_Resize fires after Form_Close on maximized forms
  27. Database Won't Open
  28. Access 2000: Compile Error in converted database
  29. WebBrowser control: Run-Time error '438'
  30. No read Permissions on "MsysModules2"
  31. Access 2000: Type Mismatch or User Defined Type Not Defined
  32. Access 2000: Can't Open/Convert Access 97 MDEs
  33. Access 2000: Setup Flags
  34. Access 2000: Formatting MsgBox's with '@'
  35. To Hide or Not To Hide
  36. Access 97 fails to start after Access 2000 Uninstall
  37. Access 2000: Corrupt VBA Project message during conversion
  38. Using Group by along with NZ results in unreadable characters
  39. How to Install Access 97 and Access 2000 on the Same Computer
  40. Access 2000 ADPs: Memo field corruption
  41. Database password appears to be set
  42. Access 2000: DeleteObject code doesn't work
  43. Image Control may cause a GPF when browsing between records
  44. Access 2000: Differences between Jet Compact and Access Compact
  45. Jet 4.0 SP3: Text IISAM does not work without txt file extension
  46. Access 2000: Changes made to code in referenced databases are not saved

 

» Date/Time

  1. Calculate Age of a person
  2. Return a date in the future from a given date
  3. Calculate differences in time
  4. Return Dates in US #mm/dd/yyyy# format
  5. Calculate Number of Working Days
  6. Various Date manipulation functions
  7. How to handle midnight in calculations
  8. Time, adding and subtracting time and timesheets
  9. Determining Average Time
  10. How many Sundays between two dates
  11. Doing WorkDay Math in VBA

» Forms

  1. Use Variables in SQL behind forms
  2. Find out if a form is open
  3. Cycle through controls with common names
  4. Enumerate all controls on a form
  5. Have the form move to the record selected in List/Combo box
  6. Return Strings from Option Groups
  7. Use Multi-Select List boxes as query parameters
  8. Grab what the user has typed in a control (uncommitted value)
  9. Fill Fields automatically on form based on a control's value
  10. Detect new record in a form
  11. Move cursor to the end of text in a textbox
  12. Carry current value of a control to new records
  13. Form doesn't open as Modal even though Modal property is set to true
  14. Suspend code until a popup form is closed
  15. Add item to combo box using OnNotinList event
  16. Disable PgUp/PgDown keys in a form
  17. Determine name of parent form
  18. Resolve #Name error in a form/report
  19. Use ControlTipText to display textbox value
  20. Make a label flash
  21. Delete current record
  22. #Error when the Subform has no records
  23. Cannot ApplyFilter on SubForm
  24. Colors and Continuous forms
  25. Refer to Controls on a tabbed form
  26. Duplicate "Record x of y"
  27. Ask before saving record
  28. Limit content of combo/list boxes
  29. Hide a subform if no records present
  30. Handle/Display images in forms/database
  31. Refer to Form and Subform properties and controls
  32. Create a clock on a form
  33. Determine selected records in datasheet view
  34. Open a form in an external database
  35. Set defaults for Find Dialog box
  36. Form only allows new records to be entered
  37. OnMouseOver Effect
  38. Control Arrays in Access
  39. Tooltips don't seem to work on certain controls
  40. Close all open forms and "For Each" syntax
  41. Make Numeric and Date fields respond to Plus or Minus keys
  42. Move and Resize form windows from code
  43. Adding "All" to a listbox or combobox
  44. Displaying photos in a form
  45. Adding a Search form to a database
  46. Display a dialog box for a specified duration
  47. Changing the Background Color of the Current Record in a Continuous Form
  48. First Control in a ReadOnly subform retains focus
  49. Callback function for a Multi Column List box
  50. Mini Calendar
  51. Clock From Around The World
  52. Calendar Month View
  53. Shaped Forms
  54. TSI Subforminator!
  55. Solid Block Font for use on continuous forms
  56. Update All Open Forms

» General

  1. Convert Access databases to Executables
  2. Automatically resize forms to current screen resolution
  3. Access, Office and Year 2000
  4. Determine name of sub/function where error occurred
  5. Prevent Access from closing
  6. Reset Autonumber field in Table
  7. Path and Folder location for databases
  8. Importing Excel spreadsheets from code
  9. Send Fax/Email from Access
  10. Run Word 97 MailMerge
  11. Some common Access specifications
  12. Commonly used naming conventions
  13. Why CompactCurrentDatabase doesn't work from code
  14. Learn about the new Acecss Virus
  15. Run Dos Batch files from Access
  16. Cannot open Access databases in previous versions
  17. Automation object doesn't close automatically
  18. DLookup Usage Samples
  19. Use LIKE in queries and code
  20. Inputbox and Password Masks
  21. How to create Shortcuts on Desktop
  22. How to duplicate VBA code in Perl using OLE
  23. Generic Name Structures in Access
  24. Troubleshoot conversion to Access 97 problems
  25. Use Autonumbers properly
  26. Connect your database to the web
  27. Runtime command line argument doesn't work
  28. Run wizards from code
  29. Replace the Access splash screen
  30. Reading a drive's Volume Label
  31. Show/Hide database window from code
  32. Email/Export Charts from Access
  33. Jet 4.0 Replication
  34. Who's logged in?
  35. Copy CommandBars and Import/Export Specifications to a new database
  36. Displaying IP Addresses by using an Input mask
  37. What was that password again?
  38. Bits and Bitmasks
  39. Access 2000: Hiding Replace Tab in Find/Replace Dialog
  40. Securing AllowBypassKey

» Modules

  1. Convert Currency ($500) into words (Five Hundred Dollars)
  2. Use variables to call functions
  3. Read Word Document Properties (Author, Last Print Date etc.)
  4. Return a concatenated list of sub-record values
  5. Opening another database in the same instance
  6. Sample Excel Automation
  7. Run Excel Macros through Automation
  8. Concatenate fields in same table
  9. Check to see if a File or Directory exists
  10. Filter a recordset
  11. Disable Shift key
  12. Domain Aggregate Functions Replacements
  13. Use Class modules to return Dir and File names
  14. Check if an object exists in the database
  15. Use FTP
  16. Conquer RunCommand Constants
  17. VB Switchboard Utility
  18. Import Outlook 98 messages
  19. Send Email using CDO/Outlook 98
  20. VB5 Compact Database utility (Access 97)
  21. Maintain a history of changes
  22. References Wizard
  23. Class Builder Wizard
  24. Compile Project
  25. PrivDBEngine and Startup Properties
  26. Forms Wizard
  27. Bill Of Materials
  28. Using WithEvents to get saved filenames
  29. Access Downsizer
  30. Access 97 Compactor Addin
  31. Code Comment Builder Wizard
  32. Class Information Wizard
  33. TSI Synchronizer
  34. Creating a reference to a Class in a Library database
  35. Transferring Records to Excel with Automation
  36. Specify UserName & Password for new Access instance
  37. Internet Data Transfer Library
  38. Determining who has Word Doc file open
  39. Getting the Decompile and Compact context menu options
  40. CodeWriter 2.0
  41. VBA Developer's Handbook - Replacement for functions in Chapter 12
  42. Scheduler Utility
  43. Opening a new Word document based on a template through Automation
  44. Determining the number of dimensions for an array
  45. Backup Wizard
  46. Exporting an Excel worksheet as a CSV file
  47. Spelling number, in many languages (PolyGlot Number Speller)
  48. Rotate Label ActiveX Control
  49. TSI Xpression 9.0
  50. TSI Form/Report to Data Access Page Wizard
  51. File Search and Properties Object
  52. Using DAO code in ADPs
  53. File Change Notification Component
  54. Implementing a custom Rounding procedure
  55. LDB Viewer Form
  56. Search Wizard
  57. Reading Text Files
  58. Text Export Class
  59. Class for sending emails through GroupWise
  60. File Slice Wizard
  61. TSI Word to the Wise
  62. Automating Internet Explorer 5

» Queries

  1. Use a parameter to return all records if Null
  2. Return database object names
  3. Open Parameter queries from code
  4. Have query return highest/lowest value in a field
  5. Use a variable in a field's criteria
  6. Have a query return every nth record in a table
  7. Find Unmatched records between two tables
  8. Find Duplicate key values
  9. Solving problems with Dates in SQL
  10. Create a query that returns Top n records
  11. Create a query that returns Random records
  12. Turn off the default Action query confirmations
  13. Too few parameters, expected n
  14. Simplify action queries in code
  15. Handling floating-point, Currency, and Decimal Datatype in SQL
  16. Finding all X having all required Y
  17. Fixed column name and crosstabs
  18. Continuous sequence, maximum length (stroke)
  19. Quartiles, Percentiles
  20. Getting a related field from a GroupBy (total) query
  21. Merging sequences
  22. Jet-MSDE: DELETE * FROM Table1; Incorrect syntax near '*'
  23. BOM, with Joe Celko Nested Sets

» Reports

  1. Printout Multiple copies of a report
  2. Print only the current record to a report
  3. Handle reports from a modal form
  4. Show totals at bottom of report
  5. Use Multiselect listbox to limit records in report
  6. Close report automatically if no data found
  7. Handle Null values in fields
  8. Send a report via EMail
  9. Change printers from code
  10. Variable Grow Box Report
  11. Open a report in an external database
  12. Printing First and Last Page Numbers for Report Groups
  13. Use a recordset as report's datasource
  14. Bring up Print Dialog from code
  15. Count the Number of Groups on a Report
  16. Printing Page Numbers on multi column report
  17. Displaying timelines on a report
  18. Lines/Graphics not retained in Word/RTF Export
  19. Custom Zoom in Reports

» Resources

  1. Books and Magazines
  2. Downloads: Index
  3. Related Access/VBA sites
  4. Access Related Patches
  5. Products
  6. Technical Papers

» Strings

  1. Parse one field's data into multiple fields
  2. Extract characters from a string containing both numbers and characters
  3. Parsing character separated string into individual components
  4. Replace a character with another within one string
  5. Capitalize first character of every word automatically
  6. Convert all text to Upper/Lower case
  7. Increment Numeric portion of a string
  8. Names with Mixed cases

» Tables

  1. How to find out if a table exists in a database
  2. "Too many fields defined" error message
  3. Referential Integrity between databases
  4. Hide a table in Database Window
  5. Have Autonumber field start from a value different from 1
  6. How to perform Seek on Linked Tables
  7. Retrieve linked database namepath
  8. Create Hyperlink Field from code
  9. Relink Access tables from code
  10. Relink ODBC tables from code
  11. Oracle Synonyms
  12. Relink tables from different datasources
  13. Sub-classing Entities
  14. Creating DSNs from code
  15. Synchronization without Replication
  16. Creating an AutoNumber field from code
  17. Lookup Table Manager

Free Microsoft PowerPoint Training Course

Kidzonline.org offers this free Microsoft PowerPoint training course giving you the following 12 Lesson Modules. These are all delivered in a video format via Windows Media format. Kidzonline.org is a federally-funded, nonprofit organization, which combines the concept of peer-to-peer training with a web-based content delivery system.

Free Microsoft PowerPoint Training Course:
http://www.kidzonline.org/TechTraining/video.asp?UnitQry=PowerPoint


Introduction

Powerpoint: Project Setup [2:32 ]:

http://www.kidzonline.org/teachit/ppt/pptsetup/frames.html
PowerPoint is a great tool for teachers and students to organize and present information. This series includes videos demonstrating different skills needed to create PowerPoint presentations.


Powerpoint Basics

Powerpoint: Introduction [3:53 ]:

http://www.kidzonline.org/teachit/ppt/pptintro/frames.html
This series will explore features of PowerPoint. PowerPoint is a tool used to create multimedia presentations. You can include text, images, sound, video – you name it. Also, it is very user friendly.

Powerpoint: Basic Powerpoint Skills [7:41 ]:
http://www.kidzonline.org/teachit/ppt/basics/frames.html
This video will show you the basics of PowerPoint. PowerPoint features in this video will be presented in a few parts. Getting Started, Adding text, Adding images, Color and Design, Adding motion and Viewing the show.

Powerpoint: Tips for Designing Good Presentations [4:43 ]:
http://www.kidzonline.org/teachit/ppt/design/frames.html
Now that you know how to make a presentation in PowerPoint lets take a minute to look at some tips for making a good presentation, such as how to spell check.

Powerpoint: Presentation Tips [4:40 ]:
http://www.kidzonline.org/teachit/ppt/tips4presentation/frames.html
Now that you have a polished PowerPoint presentation, let’s talk about tips for presenting. For example always make sure to always speak clearly and loudly.

Powerpoint: Plugins [3:37 ]:
http://www.kidzonline.org/teachit/ppt/PPTplugins/frames.html
Often times when you are using PowerPoint or other software programs you will be required to execute a type of software called a Plug In.

Powerpoint: Adding Links to Your Presentation [5:36 ]:
http://www.kidzonline.org/teachit/ppt/PPThyperlinks/frames.html
In Microsoft PowerPoint, a hyperlink is a connection from a slide to another slide, a Web page, or a file.


Powerpoint Advanced

Powerpoint: Embedding Movies [4:29 ]:
http://www.kidzonline.org/teachit/ppt/embedding_movies/frames.html
In this video we will be exploring another excellent, multimedia feature of PowerPoint, embedding a movie or animated GIF to a slide.

Powerpoint: Adding Action Buttons [3:52 ]:
http://www.kidzonline.org/teachit/ppt/PPTactionbuttons/frames.html
Basically an action button is a ready-made button inserted into your presentation, allowing the presenter or viewer to connect to another slide, document, or Web site.

Powerpoint: Producer [11:47 ]:
http://www.kidzonline.org/teachit/ppt/PPTproducer/frames.html
Microsoft Producer is a free add-on for PowerPoint version 2002. Producer allows the user to capture, synchronize, and publish their video, audio, and still images from a Web camera, a camcorder, or from their computer screen.

Powerpoint: Online Broadcasts [7:09 ]:
http://www.kidzonline.org/teachit/ppt/onlineBroadcasts/frames.html
Microsoft has built in a feature to the newer versions of PowerPoint allowing users to broadcast a presentation, including live video and audio narration, over the Web.

Powerpoint: Project Summary [3:46 ]:
http://www.kidzonline.org/teachit/ppt/PPTWrapUp/frames.html
PowerPoint is a versatile tool, which is easy to learn and includes exciting multimedia elements. Once you have learned the basics of PowerPoint you can begin to create slideshow presentations for work, school, or fun (i.e. a family trip).

Web Page Creation with Microsoft FrontPage Video Training Course

Kidzonline.org offers this free Microsoft FrontPage training course giving you a total of 22 Lesson Modules. These are all delivered in a video format via Windows Media format. Kidzonline.org is a federally-funded, nonprofit organization, which combines the concept of peer-to-peer training with a web-based content delivery system.

Web Page Creation with Microsoft FrontPage Video Training Course:
http://www.kidzonline.org/TechTraining/video.asp?UnitQry=Web%20Page%20Creation


Introduction

Frontpage: Overview [2:47 ]:

http://www.kidzonline.org/ram/teach/Frontpage/FP_00_GeneralOverview.wvx
Watch this skill video to see a tour of FrontPage features and tools. This video will help you to become familiar with the standard toolbars and menu options.

Frontpage: Monitor Setup [2:19 ]:
http://www.kidzonline.org/ram/teach/Frontpage/setup.wvx
In this video you will learn how to work in Frontpage as you view your video lesson.


Overview and Text Basics

Frontpage: Intro to Interface [7:01 ]:

http://www.kidzonline.org/ram/teach/Frontpage/FP_01_IntrotoInterface.wvx
This video will go over the general interface of frontpage. Here you will learn the essentials to navigating in Frontpage.

Frontpage: Creating a Web [4:29 ]:
http://www.kidzonline.org/ram/teach/Frontpage/FP_02_CreatingaWeb.wvx
This Teach It will go over what a "web" is and how you can create your very own unique "web".

Frontpage: Add Text and Formatting [2:52 ]:
http://www.kidzonline.org/ram/teach/Frontpage/FP_03_TextandFormatting.wvx
Learn the difference between font formatting and paragraph formatting along with tips for web text in this skill video.

Frontpage: Bullets or Numbering [2:18 ]:
http://www.kidzonline.org/ram/teach/Frontpage/FP_04_BulletsAndNumbering.wvx
Avoid using lengthy paragraphs. Use this video to learn how to add bullets and numbers to make more pleasing pages.


Working with Images

Frontpage: Understand Digital Images [4:10 ]:

http://www.kidzonline.org/ram/teach/Frontpage/FP_07_UnderstandImages.wvx
Have you ever used a software program to draw or paint? If so, you created your own digital image. Digital images can include graphics, pictures, or clip art.

Frontpage: Insert Images [4:01 ]:
http://www.kidzonline.org/ram/teach/Frontpage/FP_08_InsertImages.wvx
If you would like to add a little excitement to your project then inserting images would be a great solution. This video teaches how to insert images, resize images and more.

Frontpage: Create an Image Map [2:22 ]:
http://www.kidzonline.org/ram/teach/Frontpage/FP_09_ImageMap.wvx
Watch this video to learn how to create image maps in FrontPages. Image maps allow you to have a single image link to multiple pages.


Working with Hyperlinks

Frontpage: Add an E-mail Address [1:37 ]:

http://www.kidzonline.org/ram/teach/Frontpage/FP_10_Email.wvx
This short video explains how to add an email link to your page. Having an e-mail address on your page allows people to get in touch with you for feedback or other purposes.

Frontpage: Add Internal and External Hyperlinks [2:31 ]:
http://www.kidzonline.org/ram/teach/Frontpage/FP_11_InternalExternal.wvx
A hyperlink is a connection from one page to another destination such as another page (external) or a different location on the same page (internal).

Frontpage: Create Links Within A Page [2:47 ]:
http://www.kidzonline.org/ram/teach/Frontpage/FP_12_CreatLinksWithinaPage.wvx
Frontpage Bookmarks are links within your webpage for example, when you see a page that says RETURN TO TOP. This video will show you how to create your own.


Working with Tables

Frontpage: Create a Table of Contents [1:54 ]:

http://www.kidzonline.org/ram/teach/Frontpage/FP_13_TableOfContents.wvx
A table of contents can be a very effective navigation tool for your webpage. There are many different styles and different positions you can put your table of contents and this video goes over a basic style.

Frontpage:Creating Tables [2:38 ]:
http://www.kidzonline.org/ram/teach/Frontpage/FP_14_Tables.wvx
This skill video explains how to add tables to your page. Tables allow you to organize the information on your page, and can also be used to create more complex webpages.

Frontpage: Cell Properties [2:02 ]:
http://www.kidzonline.org/ram/teach/Frontpage/FP_15_CellProperties.wvx
Each cell of any table can be treated like a regular page in FrontPage. You can change the background colors, insert background, and vary the alignment, among other things. All of these features can be accessed from the “cell properties� option.


Include Pages

Frontpage: Include Pages [2:13 ]:

http://www.kidzonline.org/ram/teach/Frontpage/FP_16_IncludePages.wvx
This Teach It will discuss including pages within other webpages.

Frontpage: Scheduled Include Pages [1:54 ]:
http://www.kidzonline.org/ram/teach/Frontpage/FP_17_ScheduledInclude.wvx
Learn how to make scheduled include pages. Scheduled include pages allow you to create changes and edits and postpoine them for a special time.


Publish your Webpage

Frontpage: Publish Your Site [5:39 ]:

http://www.kidzonline.org/ram/teach/Frontpage/publish.wvx
Now that you're done creating your webpage its time to publish it so that everyone can view it.

Microsoft Office: Webpage Wizard [2:42 ]:
http://www.kidzonline.org/teachit/frontpage/wizard/frames.html
Using the built in wizard in Microsoft Word can be a great and easy way to start making your very own webpage.


Microsoft Office Documents

Microsoft Office: Converting Word Documents [3:32 ]:

http://www.kidzonline.org/teachit/frontpage/word/frames.html
If you believe converting Word Documents into Html is extremely hard then we have news for you. Watch this video to learn how to convert your Word documents to HTML without having a nervous breakdown.

Microsoft Office: Converting PowerPoint Presentations [2:04 ]:
http://www.kidzonline.org/teachit/frontpage/ppt/frames.html
Sure converting Microsoft Word documents into HTML is a cinch, but how easy can it be to do the same with your PowerPoint presentations? Make sure you're sitting down for this… it's just as easy.

Microsoft Office: Links in PowerPoint and Word [3:22 ]:
http://www.kidzonline.org/teachit/frontpage/ppt/frames.html
Creating both internal and external links makes it easier for people to navigate through either your PowerPoint presentation or Word document. Plus you can have a lot of fun making them, if you're into that sort of thing.

Free Course: The Power of PowerPoint

This free course, The Power of PowerPoint, will teach such basics as creating a new presentation to more intermediate features like links to external files. Each lesson will provide step-by-step instructions to accomplish common tasks. At the end of this course you will be able to create a presentation that includes text, images, animation, and links. You will also be able to view and create a "portable" presentation. Note: This course will reference PowerPoint version 2000. However, the features of other PowerPoint versions are very similar.

Free Course: The Power of PowerPoint

Lesson 1: The Basics of PowerPoint
Why use PowerPoint over a slide projector and poster board? Who uses PowerPoint? These and other questions regarding the effective use of...
Why use PowerPoint?
PowerPoint books, help resources, and web links
Ready, Set, Here we go!
Help Features to the Rescue
View, Toolbars, and O.C.S.
Bibliography for Lesson 1

Lesson 2: How to Create the Core of Your Presentation
The heart of your presentation contains the text and images. We will learn how to add text and images. We'll also work on text formatting including...
Basic Components of a PowerPoint Presentation
How to Add Text and Lists
How to Add Clip Art and Images
How to Modify Text Font, Size, and Impact
How to Modify Images
Spell Check and Slide Sorter
Bibliography for Lesson 2

Lesson 3: How to Create Links, Transitions and Print
Learn how to link to Internet resources, other files, and to other slides within your presentation....
The Power of Links, Transitions, and Printing
Links to Word and Excel Files
How to View your Slide Show
Speaker Notes and Printing
Bibliography for Lesson 3

Lesson 4: Pump Up the "Power" of Your Presentation
You have created a basic presentation and now it is time to add flare. We'll look at animation and media features in this lesson....
Powerful Tools in PowerPoint
Animation and Media Features
More Cool Links to PowerPoint Resources
Make Your Presentation Portable
Discussion Questions
Bibliography for Lesson 4
Create Your Own Presentation

Course Wrapup


Page :  1 2 3 4