Section 8 - Software Notes      Return to Home Page

1.  PKZIPPIN across Multiple Disks 
2.  ASCII Text Files into DBASE 
3.  Editing in dBASE
4.  File Types by Extension Listings (3)
5.  Xtgold Hot Keys and Extras
6.  Xtgold - Inserting Control Characters
7.  Link a Worksheet to a Word Document
8.  OnTime Program Printing Fix
9.  AOL Software Secrets
10.  MS Office Secrets

Subject: PKZIPPING to Multiple Floppies

To zip files across multiple floppies..... (using PKZIP204g/250)

    PKZIP A:\<FILENAME>.ZIP -& C:\<DIR>\*.*

To unzip the files....

    PKUNZIP A:\<FILENAME>.ZIP C:\<DIR>

        it will ask you to insert the last disk just for a moment

Rough guess: a PCX file 2.7meg  took 2 1.44 disks, 3.9m /3 disks, 10.8m /6 disks
----------------
To add a little excitement to your zip files, include your own
header file. First create an ASCII text file with your info in it.
Here we will call it "zipinfo" and it is located on the D: drive.
The header file should begin and end with two carriage returns.
Next add a couple of new switches and your file name;

PKZIP -Z A:\<FILENAME>.ZIP C:\<DIR>\*.* <D:\ZIPINFO
---------------

If you include the "-Z", but forget the "<", it will stop and ask you to type in a comment.

When the zipped file gets unzipped, your header file will be displayed.

C:\ZIP>pkunzip 111

Searching ZIP: 111.ZIP - 
******************
º    Welcome to the     º 
º Wizard's Wonderful  º 
º    World of stupid     º 
º      ZIPped files!        º 
******************
Inflating: 01.BMP, etc, etc . . .

------------------
Other Options: I use this to backup the Good Book

rem ZIPH.BAT
del c:\goodbook.zip
set pktmp = e:\
pkzip c:\goodbook.zip -rp -x*.exe -x*.zip -x*.dwg h:\*.*

set temp = lets me use a RAM Drive (faster)
-rp = lets you also zip the sub-directory structure
-x = exclude these files (*.exe)

Go to Top

Subject: Sucking ASCII Text Files into dBASE


1. View file in Xtree, count exact digits + following spaces to next column.

2. Build dBASE file using the counts you got in #1.

3. At the dot prompt;

    .Append from ______.txt type sdf (file must be .txt)

Go to Top

Subject: Editing in dBASE

Create the following two line file and call it something like SETUP.PRG

SET FUNC 9 TO "MODIFY COMM ONE.PRG;"
SET FUNC 10 TO "DO ONE;"

Substitute the program name you are working on in both lines where it says ONE.

When you first start dBASE you can do one of two things: If you use
the dot prompt just ".do setup". Or if you start dBASE with a BAT file
make it say "dbase setup" and it will automatically load the program.

What this does it give you a nice little editor for your program (in this
case - one.prg). All you have to do is press F9 to bring your prg file
up in the editor. When you're done press F10 to run your prg file.

Go to Top

Subject: File Types by extensions (3 Tables)

----------  Table One  ----------

Executables: COM, EXE, BAT (Command, Execute, Batch)

Temporary and backup: BAK, TMP, CHK, SYD

Compressed: ZIP, ARC, LZH, ARJ

Graphics: FXR, FXS, IPG, PM4, PM5

EPS (Encapsulated Postscript Files) PS Print files.

Driver: BIN, DRV, SYS, 386 (Configuration: CFG)

Word Processing: TXT, ASC, INF, WP, WPM, STY (Word: DIC, DOC, DOT, RTF)

True Type Fonts: TTF, FOT, FON

Spreadsheet: WKS, WK1, WK3, WK4, WK5 (Excel: XLA, XLM, XLS, XLT)

Database: DBF, DB, NDX, IDX, (Access: LDA, MDB)

Language: ASM, BAS, CBT

Overlays: OVL

Windows: (Write: WRI) DLL, INI, PIF


----------  Table Two  ----------

 Multimedia File Types

 AVI (Audio Video Interleaved) Video with a sound track. Accessible through
Windows' Media Player.

BMP (Bitmap) Graphics. Accessible through Windows' Paintbrush.

CDR (Coral Drawing R________) Coral Graphics.

CGM (Computer Graphic Metafile) 16-Color Graphics. International standard for exchange. Accessible through Corel Draw.

FLC,FLI (Flick) Animation. Autodesk format used by many programs.

GIF (Graphics Interchange Format) CompuServe Graphics.

ICO Windows Icon graphic.

JPG (JPEG: Joint Photographic Experts Group) Photos. High quality photographic using special compression format.

MFF (MIDI File Format) Music. MIDI formatted music file.

MID (MIDI) Abbreviated MIDI format designed for MS Windows. Accessible through Media Player.

MOV (Quicktime) Video. Format from Apple now works in Windows

MPG (MPEG: Motion Picture Experts Group) Video. Highly compressed DOS format requiring special hardware and software.

PCD (Photo CD) Photos. Kodak format.

PCX Graphics. Popular format used by most graphics programs.

TIF (TIFF: Tagged Image File Format) Graphics. Made popular by Aldus PageMaker. 

VOC (Creative Voice) Sound. From the Sound Blaster folks.

WAV (Waveform) Sound. Windows' preferred format for storing recorded sounds.

WMF (Windows Metafile Format) Graphics.

----------  Table Three  ----------

.aif Macintosh-developed sound file
.asm assembly language file
.ats OpenScript file
.avi Video forWindows video file
.bas BASIC language source code file
.bat batch files
.bmp bitmap graphics file
.c C language source code file
.cal Calendar system resource file
.cgm vector graphics metafile
.chk lost cluster file produced by the chkdsk command
.clp Clipboard system resource file
.com command file
.cpf clip library file
.crd Cardfile system resource file
.cur Cursor system resource file
.dbf dBase and FoxPro database files
.dib device independent bitmap graphics file
.dic dictionary file
.dif data interchange format file
.dll dynamic link library file
.doc word processor file
.dot MicrosoftWord template file
.drv device driver file
.drw Micrografx Designer or Draw file
.dwg AutoCAD native drawing file
.dxf AutoCAD two-dimensional graphics file
.eps encapsulated PostScript file
.exe executable file
.flc Autodesk Animator file
.fli Autodesk 3-D Studio file
.flm FilmStrip video file
.flx Tempra Animation Editor video file
.frm Visual Basic form
.gif CompuServe image format files
.grp group files (Windows)
.h header files in a C program
.hgl Hewlett-Packard graphics file
.icb Truevision Targa graphics file
.ico icon graphic used with controls
.iff Macintosh-developed sound file
.igs interplatform CAD graphics file
.img GEM Paint graphics file
.ini initialization file
.jif JPEG image file
.jpg JPEG image file
.Ibm Deluxe Paint graphics file
.Izh LHArc compressed file
.mac MacPaint-developed graphics fiie
.mak Programming language project file
.mid MIDI synthesizer file
.mmm Macromedia -video file
.mnu Menu system resource file
.mov QuickTime video files
.msp Microsoft Paint graphics files
.ndx index settings file 
.out index log file
.ovd Borland ObjectVision file
.pal Palette system resource file
.pas Pascal language source code file
.pcd Kodak Photo CD image file
.pcx Windows graphics file
.pic Apple Macintosh PICT graphics file
.pif program information file
.pld Adobe Premiere Library image file
.plt AutoCAD graphics file
.ppj Adobe Premiere Project image file
.ppt PowerPoint presentation file
.psd Adobe Photoshop image file
.psq Adobe Premiere Sequence image file
.qtw QuickTime for Windows video file
.rdi resource interchange file format device-independent bitmap file
.ras Sun raster graphics file
.rec Recorder system resource file 
.rle run-length encoded bitmap graphics file
.sam AmiPro word processor file 
.sbf Superbase 4 database file 
.sbk ToolBook system book 
.snd Macintosh-developed sound file 
.sst Super Show & Tell presentation file 
.sys system files 
.tbc cache file on a hard disk 
.tbk ToolBook file 
.tga Truevision Targa graphics file 
.tif tagged interface file format graphics file
.trm Terminal system resource file 
.ttf TrueType font file 
.txt ASCII text file 
.vbx custom control file for use withVisual Basic,Delphi,etc.
.vda Truevision Targa graphics file 
.vst Truevision Targa graphics file 
.wks Lotus 1-2-3 spreadsheet file 
.wmf Windows metafile 
.wpg DrawPerfect graphics file 
.wri Write system resource file 
.xbm Unix bitmap graphics file 
.xlc Excel spreadsheet file

Go to Top

Subject: Xtree Extras from - OFFICIAL XTREE, 3RD EDITION

F5 - collapses two levels (91)   (page reference number)

F6 - collapses all directories (92)

Exclusionary File Spec (everything but), use a minus (109)

Control+S (from root) - displays all tagged files (181)

Control+S (Showall/Global) - Finding text in all tagged files (114)

Comments (Labels) - use ":", File Spec - Docs only: .doc (128)

Alt+O (Open) - executes program less command line (135)

ALT+Q - Quits to highlighted directory (156)

ALT+Z - Quits but holds tag info (156)

ALT+T - tags by attribute (180)

ALT+F8 - Partial un-tag (183)

Gather - dumps highlighted <text> to new file (188)

dump to "PRN" to print highlighted area (189)

Graft - Cut and paste directory (73)

To update a zip file, just use zipped name (311)

Multiple File Specs in Xtpro - use comas (109)

LH Xtgold - Can be loaded high (135)

Listing of Xtgold files by use (347)

Go to Top

Subject: Inserting and Escape Character or a Form Feed   from Jim Beard

To insert an Escape Character (backards arrow):

In Xtree Editor;

Type any character (unique) where you want the escape
^Q to bring up options
select G
FIND: (type unique char)
REPLACE: ALT+027 (will give you [, just hit return)
select yes


To insert a form feed (symbol for a female):

In Xtree Viewer;

View area
Hit H for Hex
change bit to 0C
hit RETURN to save.
hit M for Mask to view or go into regular editor

Go to Top

Subject: Link a Worksheet to a Document

You're creating the annual stockholders report in your word
processor. The pages are laid out beautifully, you've found just
the right font, and your prose is witty and upbeat. But you need
something else: the FY96 Market Share chart from the Budget
worksheet, inserted right into the middle of your text. You could
simply cut and paste the information from one program to another,
but then your document will be out-of-date the next time someone
changes the worksheet.

The trick is to link your worksheet to your document. A link is
like a window into your word processing file created by another
program. Here's how to do it .

1. Because CELL ADDRESSES can change, you should name the Excel 
range that you want your Word document to display. Open the worksheet
and highlight that range. Select Insert, Name, Define, enter a name
like ToWord, and press <Enter>.

2. Select Edit, Copy

3. Enter Word and open your document. Place the cursor where you want
the view of your worksheet to appear.

4. Select Edit, Paste Special

5. In the resuldug dialog box, click the Paste Link option, and in
the As list, choose Microsoft Excel Worksheet Object to insert a
graphic object, or Formatted Text (RTF) to create a Word table
containing the data. Click OK to complete the link. The Worksheet 
Object will look like a piece of your spreadsheet stuck in a
resizable box inside your document, while the Formatted Text will 
look like (and actually become) a part of the document itself.

Go to Top


Subject: Ontime Scheduling Program and newer Laserjets

To make Ontime Software work correctly with HP Laserjet 4 and
above, modifiy the file OT.EXE. Change the value at location
39B74 from 6C to 61.

Go to Top


Subject: AOL Software Secrets

1.      To transfer your AOL to another computer.  There are two options.

  1. Install the same version on your new computer.  This will install the needed drivers and make the needed Registry Changes.  Rename the AOL directory to something else.  Copy your old AOL directory over and name it what the newly installed AOL directory was.  When you run AOL the first time it will auto-detect your modem or ISP connection.  If you had your passwords stored, you will have to restore them in Perferences.
  2. You can copy over your AOL\Organize directory files to the current AOL installation and re-install AOL which will align everything (want to try also copying the MAIN.IDX from the IBD sub-directory).  A re-install will reward you with several updates the first several times you log off.
  3. If you have AOL installed on two or more computers and you add or delete a screen name and what it to update CORRECTLY on another computer so you can assign an automatic password logon, just delete and restore a screen name, this will cause all screen names to update

2.      To store a password check the first box, not the second.  Second box will lock you of of your Filing Cabinet.

3.      To get AOL to work properly on Windows 95, download from Microsoft and install DUN 1.3 Update (Dial Up Network).  Upgrades it to Win98 functionality.

4.      If having problem with things like Mail Controls, move this file to the recycle bin, AOL will create a new one.

C:\AOL\IDB\MAIN.IND

      Do not delete the Main.idx file, it will crash AOL

5.      If have browser problems, delete the cache files through IE.

6.      For weird problems delete in Network Delete the AOL Adapter and the AOL Dial Up Adapter.  AOL will re-create when it starts.

If either you don’t get an option to remember the Password or the Screen Name doesn’t show up in the drop down sign on list then you need to refresh the MAIN.IDX file which holds the screen names and passwords near the bottom of the file.  To do this, add, delete, or restore a name.

Go to Top


Subject: Microsoft Office Secrets

Cool things learned at New Horizon’s Classes

 Configuring Office and Tricks for Windows

Tricks:

 1.  To resize a window, such as Explorer, size the window to how you want it, then hold the Shift Key down when you close the window.

2. Drag “My Computer” to the bottom tool bar next to the clock.  Will give you two double arrows to the right.  Clicking here will give you instant access to your folders, files, and anything else you’ve added to this folder.

 3.  Right clicking in a blank area on the lower tool bar will let you open two Vertical Windows.  Office only lets you open two Horizontal Windows. 

4.  If you use WinZip, you can treat a zipped file like any other folder.  Drag and drop files on the zipped file to add or replace files within the zipped file. 

5.  This one is really cool.  Ever get a window where the top bar is off the screen and you need to drag it down to close it?  Hit ALT + Space Bar, the down cursor and ENTer.  Now the cursor keys or mouse movement will control movement of the window.  Just hit ENTer again to return normal control to the mouse. 

6.  Anytime you open a new toolbar and you get a mini bar which floats on the page, you can move it to where the rest are by double-clicking on the title bar. 

7.  Tired of having Recycled directories on all your drives?  Then stop it!  Right click on your Recycled Bin, choose Properties, the choose “Configure Drives Independently”.  Choose to delete files immediately on all drives but C, then it won’t create those Recycled directories. 

8.  Get 2.6 Megs on a floppy by adding DriveSpace to it. Open My Computer, Right Click on Floppy Drive, choose Properties.  Pick Compression Tab, then Compress drive.  Don’t have the tab?  Do this to add Compression abilities:  Control Panel, Add/Remove Programs, Windows Setup Tab, System Tools, Details, check Disk Compression Tools (don’t uncheck anything or it will delete those items), OK. 

Configuring Office 97 and Office 2000: 

Office changes some Windows normal effects and settings.  This will undo these annoyances. 

1.  To let you see changes as you drag edges and move the text with the slide bar.  With Office closed or minimized, right-click on the Desktop, choose Properties, then the Effects Tab, and then check the last box, “Show window contents while dragging” 

2.  To stop auto-highlighting of an entire word when you highlight just a few letters, click on Tools, Options, Edit Tab, un-check the last box in the right column, “When selecting, automatically select entire word”.  (Even though you’ve done this in Office, Outlook has it’s own setting for this;  Tools, Options, Other, Advanced Options, second box). Also works in version 6 – WFW3.11 

3.  To add tool items or an entire custom tool bar to the top bar, go to; Tools, Customize, Commands, Click on New, then drag it to the top tool bar.  You can rename it, and change the Icon.  For a Tool Bar, click on Toolbars instead of Commands, and click new. 

4.  Spelling Options:  Tools, Options, Spelling, choose your options.  Outlook has it own options, same path to get there. 

Configuring Office 2000: 

1.  To see the full normal menus, click on Tools, Customize, Options, and un-check the second box, “Menus show recently used commands first”. 

2.  In Word, Microsoft has combined both toolbars into one.  There are a couple of ways restore the toolbars to normal.  You can do it from menus, or manually:  Tools, Customize, or right click on toolbar, choose customize at bottom.  Click Option Tab, first box, Standard and Formatting Toolbars Share One Row, uncheck to get the standard two toolbars.  Manually:  click on the raised bar to the left of the Floppy in the top tool bar, and drag it straight down.  Both normal tool bars will appear.  Reverse to merge back into one.  You can slide them side to side, or over each other to place one on top or under the other.  You can even drag to the right side of the screen, to place it vertically. 

Power Point Tricks: 

Hit F1 while show is running for a menu of all the secret stuff Power Point can do!  Control+A gives you a pointer, Control+P gives you a pen.  Just E will erase pen drawing, B will give you a black board with a white pen, W for a white board with a black pen, an so on.

 Excel Tricks learned in Word Class!

 1.  To merge horizontal cells into one cell for text:  Highlight cells.  Format, Merge Cells

2.  Autosum:  Put cursor where you want total.  Click the Autosum symbol on the toolbar, looks like a backwards 3.  If OK, hit enter, otherwise highlight correct range to sum, hit enter. 

Windows 98 and Windows 2000 Tricks:

 To add a program to the startup sequence:  Right-click on Start, choose Open.  Double click Programs, drag program to Startup Folder.

Ever hit the Caps Lock key and not know it?  Go to the Control Panel, Accessibility Options, Keyboard Tab, check last option: Use ToggleKeys.  Then you’ll get a short tone when you hit the Caps Lock, or Num Lock keys.

 Desktop Folder:  Learned from classes, and might make it much easier for new users.  Move or create “My Documents” and “My Downloads” on the Desktop.  Does away with learning the tree and leaves all documents at an easy place for new users to access. 

To remove Icon from tool bar at any time, hold down the ALT key, and drag icon down off all toolbars.

 Keyboard Shortcuts – F2=Rename Selected Item, F3=Find Files, F5=Refresh View.  Shift +Delete deletes items without sending them to the Recycle Bin.  Hold down Shift key while inserting a CD bypasses Auto-Start.  Alt+Enter= properties.  Alt+Tab=Switch between Windows. 

Windows 2000 Notes:

For those of you who use the ALT+ keys, the default in Windows 2000 is to NOT underline the key letters until you press the ALT key once.  To turn these underlines on all the time, right-click on the Desktop, choose Properties, then the Effects Tab, and then check the last box, “Show _____” 

Other Tricks not from classes, but they keep coming up:

 Tired of typing www.name.com?  Then knock it off.  Just type the “name” and hit Control+ENTer and IE will automatically add the rest.

 To put a shortcut to a web site on your Desktop, resize IE so you can see your desktop.  Drag the Icon in front of the ULR to the Desktop, and presto; you got a shortcut.

 Ever add a new a new piece of hardware or load new software it have it totally trash your system?  If you’re running Windows 98 there is built in help.  You can restore up to 5 days previous configuration/registry setting (step back in time to what your PC was setup to

BEFORE you ran into trouble).  Boot to DOS (hold down F8). 

At the DOS prompt ENTer:     SCANREG /RESTORE     and follow the instructions.

 

Cool things learned in Beginning Word 2000…. 

Highlighting:  move the mouse to the left margin until the cursor goes from the I-Beam to an arrow.  A single click highlights the line, a double click highlights the paragraph, and three click highlights entire document.  Once a line in highlighted you can use the cursor keys to add more lines.

 If you use the Office Assistant, by right clicking on the paper clip, you can change it to a number of things including a dog, cat, transformer, and more (to turn on/off go to Help, Show Office Assistant). 

If you prepare a document for sharing on Computers, you can add a nice color background by going to Format, Themes.

 There is a lot you can do with Tabs.  To remove a tab, just click on it and drag it down off the ruler.  To Add a tab – Click on the little box in the upper left corner, it will cycle through all the tabs (Left, Center, Right, Decimal Point, Line).  You know left and Right.  Center will center all items under it, the decimal point will line up all the decimal points no mater how large or small the number.  The line will draw a vertical line all the way down the page with every new line.  Also you can use Format, Tabs to use “leaders”.  These will fill the area between the text and the tab stop with dots (table of contents) or solid lines (to create hand filled in forms). 

AutoText is a useful tool seldom used (Insert, AutoText).  Click on the hand.  Here you can add sentences you use a lot or words you have trouble spelling (avoid starting sentences with common words such as “The”).  Once added, as soon as you type the first four letters, the word or line will pop up in a box, just hit ENTer to insert the text. 

AutoCorrect is also useful (Tools, AutoCorrect).  If you type a paragraph or a large body of text often, then you will like this.  Just type your text, then highlight it.  Open Tools, AutoCorrect, and there will be your text on the right.  On the left put the three code letters you want to use.  The instructor suggested using the first letter of the first three words. And click OK.  Now anytime you type those three letters the paragraph will appear. 

More cool stuff learned in Intermediate Word:

 Vertical Highlighting – ALT key, then click and drag (works in Word only).

 Control + click on any word in sentence, highlights entire sentence (or until first period). 

Control + Shift + End – highlights from where you are to end of document.

 Don’t want the automatic hyperlink created when you type a ULR or email address?  Right after you type it, hit Control +Z or click on undo to remove the hyperlink.

 Double clicking on the page number at the bottom of the page will give you a box where you can jump to any page in a multiple page document (shortcut to Edit, goto).

 You can use bookmarks and hyper-links within word to help navigate, even better, read next

 If you type four short lines, click on Styles, assign the three Styles to Auto-Format Titles, Subject, Heading, BEFORE you type a large document or book, then you can create a Table of Contents that will create itself automatically WITH hyper-links.  Could save you hours! 

More cool stuff learned in Advanced Word: 

  1. Control+Y  Repeat last command – good for changing text titles, etc.
  2. Type 3 – (or _,=,~) and hit RETurn to get a line across the page.
  3. Points:  (Vertical Spacing) 6= ½ space, 12= full space, 72= one inch
  4. Word:  Use Shift, and Shift-Tab to set sub-items in an Outline type document.
  5. Styles…(pre-define fonts and sizes, next to box that shows current font).
    1. Style affects paragraphs, so just click anywhere on line, no need to highlight. (Same with Center, Right, Left, Both)
    2. Two ways to create or change a Style.

                                                               i.      Format, to Style

                                                             ii.      Format font how you want, add Borders and Shading, etc. (under Format)  Then click on style name – probably says “Normal”, type new Style name, and hit return.

    1. To change text to a Style, just click on line, use Style drop down and select Style you want.
  1. Create you own Custom Style Title Format (MyTitle)
    1. Type your title, center it, bold it, etc.  Color it, put a border around it, whatever (Format, Borders and Shading).  When done…
    2. Highlight new Title.
    3. Click once on the Style box (usually says “Normal”), just type “MyTitle” (no spaces), and hit enter.  It is now created.
    4. If you change MyTitle format, and what the old ones to update, once new MyTitle is made, click on it and hit ENTer.
  2. Share Custom Styles with other Documents
    1. Format, Style, Organizer
    2. Must get second document in right box.  On right click close file, then open file (same button).  Browse to new file (may need to click on all types of files).
    3. Just highlight the style you want to copy and click copy.
    4. You can copy to Normal.Dot to make available in all new documents.  Be careful, you might want to back up Normal.Dot before playing with it….
  3. Auto Table of Contents / Document Map
    1. Must use Style Headings 1,2,3
    2. Go to View, Document Map (gives left side Hyper-Links) Click Document Map again to stop
    3. To make auto-TOC

                                                               i.      Go to the top (Control+Home)

                                                             ii.      Insert Page Break (Control+Enter)

                                                            iii.      Go to the top (Control+Home)

                                                            iv.      Type Title (Table of Contents)

                                                              v.      Insert, Index and Tables, Table of Contents Tab, Format (pick style), click OK.

  1. Benefits of Using Outline View
    1. Will automatically assign Heading Styles. 
    2. Outline Toolbar:  Use Arrows to Promote/Demote.  Use numbers to see just Titles/Sub-Titles
    3. +/- signs collapse/expand text, leaves just title
    4. Create Sub-Documents for separate editing, then insert edited version (buttons on Tool Bar).  Main Document called Master Document
    5. Use Tab and Shift-Tab to Promote/Demote.
  2. Compare Documents OR Track Changes
    1. Tools, Track Changes, Compare Document (open second doc),
    2. You can also set as default so you can see changes made as they are made.  Go to Track Changes, Compare Document, Highlight Changes
    3. Accept/Reject Changes
  3.  Tables
    1. Advantages of using an Excel table over Word Table

                                                               i.      Auto updates (linked to active spreadsheet)

                                                             ii.      Charts, Graphs

                                                            iii.      Easier to set Borders

                                                            iv.      Formulas

                                                              v.      Clear an entire sheet at once (use Control + Enter after typing “none” or a space in the first cell, then highlighting all fields)

    1. Build in tables have Auto-Format (under Format)

                                                               i.      Create Table

                                                             ii.      Under Tables, use Formula for simple functions

                                                            iii.      Go to Tables, Auto-Format (not as rich as Excel Auto-Format)

    1. To link to an existing table..

                                                               i.      In Excel, Highlight what you want to show, copy, go to Word, Paste Special (under Edit), Paste Link:, Formatted-text (RTF).

                                                             ii.      Or from Word, Insert, Object, Create from File Tab, Click Link to file box, browse to file, double click on file.

    1. Using a table created in Excel (use Wizard in tool bar) will be easier to re-use over the long run than a table created by Word.  Using an Excel table will allow you to clear all fields at once (use Control + Enter after typing “none” or a space in the first cell, then highlighting all fields).
  1. Using Forms Toolbar
    1. Turn on toolbar:  right click on toolbar, check Forms.  This will give you a small toolbar, double click on title and it will jump below other toolbars.
    2. You can also go to Tools, Customize, Toolbars Tab
  2. Pre-made fill in the blank, check boxes form letters, memos, Docs.
    1. If using a date, be sure to check the Update automatically box.
    2. Use Form Toolbar, define which areas can be typed in, use tab to jump to each area.  You can do this inside of a table!
    3. Add boxes and drop-down boxes.  (change box size with 3rd icon).
    4. Lock Document (last icon on toolbar).
    5. Save document AS Template, will show up under new document type.
  3. Toolbar Macro (create an icon that will insert today’s date Wednesday, March 28, 2001)
    1. Tools, Macro, Record new Macro
    2. Type title “InsertDate” (no spaces), click Toolbars
    3. Click Commands Tab
    4. Drag the Icon on right up to top toolbar next to “Help” (DON’T HIT CLOSE!)
    5. Click Modify Selection
    6. Choose “Default Style” (gets rid of text, leaves icon)
    7. Click Modify Selection
    8. Pick an Icon to replace default now on toolbar
    9. Click Close (notice REC on bottom toolbar now on)
    10. Go to Insert, Date and Time
    11. Pick desired format
    12. Check the box: “Update Automatically” is checked by default.  Uncheck this if you do not want your dates to update to current day every time you open a document.
    13. Click OK
    14. Hit Return once
    15. Click Stop Macro (Square solid box)
    16. All Done…
    17. To remove Icon from tool bar at later time, hold down the ALT key, and drag icon down off all toolbars.
  4.   Watermarks.  Add water marks to Headers and Footers, not to main text.  For two reasons:  It will then appear on all pages, and you can get to it to edit it once it is behind text (which you can’t do from the main text area).
  5.   Cool things you can do with the FORMS toolbar.  Right click on tool bar, click on Forms.  Double-click on mini toolbar title bar to put tool bar above text area.
    1. Insert boxes that can be checked (box icon with check in it).  To change size, click on forth icon.
    2. If you want a document for people to use on their computer and want to protect your text, but give them an area to respond:

                                                               i.      The first icon “ab|” will give you an area for typing (will auto expand)

                                                             ii.      The third icon will give you a drop down box for them to make a selection.

                                                            iii.      Once done, click the lock to lock all your text and make the shaded areas active.

  1.   Drawing toolbar.  Right Click on toolbar, choose Drawing, puts tool bar on the bottom
    1. Just like PowerPoint, start playing

Outlook Express is just the mail part of Outlook (includes scheduling and shared information done through the Exchange Server).

 My Briefcase

 This is an interesting little program that is actually useful if you like to carry your files between home and work.  Once set up you just transfer “My Briefcase” between your PCs and a floppy.  The briefcase only shows up on the PC where it is active.  It keeps a copy of the data on both PCs so that if the floppy get corrupted you don’t loose the data.  To install go to Control Panel, Add/Remove Programs, Windows Setup Tab, Accessories, Details, check Briefcase (don’t uncheck anything or it will delete those items), OK.  To use just drag files on to the Briefcase, then drag the Briefcase onto your floppy…

System File Checker

This program can save your butt, if…  You run it first before you get into trouble.  It checks all your Window’s system files.  It logs or verifies the file dates and sizes.  If your PC starts having trouble, run this again and it will tell you what file is back and help you restore it.  To get to it go to Start, Accessories, System Tools, System Information (or run MSCONFIG), tools, System File checker.

 Disk Clean Up

 A nifty little built-in program that helps you get rid of old files that clog up your hard drive.  Go to Start, Accessories, System Tools, Disk Cleanup.  Then check which files you want deleted.  It would then be smart to do a Scandisk and a Defrag (turn off any running program such as virus scanners or screen savers first).


Go to Top                    Return to Home Page