[abcomputers] ABC~All 'Bout Computers, Vol. 6: Access Queries Explained,Hal's Review of Windows XP, and Lots More!

  • From: Linda Johnson <linda@xxxxxxxxxxxxxxxxxxxxxxxxxxx>
  • To: ABCfreelists <abcomputers@xxxxxxxxxxxxx>
  • Date: Fri, 03 May 2002 22:00:48 -0400

ABC ~ All 'Bout Computers
Volume 6; November, 2001 - mailed to 1598 subscribers

If you would prefer to read the online Web-azine, which includes
pictures and screenshots and is, basically, more user-friendly, follow
either of these links: http://personal-computer-tutor.com/ABC.htm
(frames) http://personal-computer-tutor.com/vol6.htm (no frames)

or, scroll down to the Contents where you can click on over to any
individual article

For definitions of any terms you do not understand, visit the GeekSpeak
Translator: http://personal-computer-tutor.com/capn3.htm
**************************************************
This is not spam.  You are receiving this newsletter because you (or
someone using your email address) subscribed to it voluntarily.   If you
would like to remove yourself from ABC, please see SUBSCRIPTION
MANAGEMENT at the bottom of this newsletter. Using the "Reply" function
will not unsubscribe you!

My subscriber list is NOT made available to other companies or
individuals. I value every subscriber and respect your privacy.
***********************************************************
xxxxxxxxxxxxxxxxxxxIMPORTANTxxxxxxxxxxxxxxxxxxx
***********************************************************
WATCH FOR ANY LINKS THAT WRAP TO MORE THAN ONE LINE!
These will have to be copied and pasted into your web browser's Address
Bar as one line in order for you to access them.
***********************************************************
To view this text newsletter best, maximize your email window to FULL
screen.
***********************************************************
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
***********************************************************
***********************************************************
ANNOUNCEMENT!!!!!
EXCLUSIVE OFFER FOR ABC SUBSCRIBERS!!!!
WIN FREE SWISH SOFTWARE!!!!

Yep, that's right.  It's TOTALLY FREE and only available to ABC
subscribers.

So, here's the deal:
Go to my contest page and there's a link to SWISH where you
can download a FREE, fully-functional, 15-day trial version. Then use
the trial version to make your own SWISH creation. Then export it from
SWISH as an html file and email the html file, along with its
accompanying swf file and I will judge them all.

Winners will be announced in the next issue of ABC, and their creations
will be posted at my website for all to see. The top 5 will then receive
a FREE, FULLY LICENSED, LEGAL COPY OF SWISH from Ben.

So, come on, all you budding web designers, give it a shot.
And have fun!
http://personal-computer-tutor.com/contest.html
***********************************************************
***********************************************************
CONTENTS
(all links below these items take you to the non-frames Online versions)
(items with *** behind them include pictures and are viewed better
online)

1.  Important How-To Message From Linda
http://personal-computer-tutor.com/vol6.htm#HowTo

2.  Linda's Thought of the Month (and animated gif!)
http://personal-computer-tutor.com/vol6.htm#thought

3.  Linda's Soapbox ~ EMAIL ETIQUETTE:=A0
Why I Ruffle Feathers http://personal-computer-tutor.com/linda6.htm

4.  What's New at Linda's Computer Stop
http://personal-computer-tutor.com/newabc6.htm

5.  Subscribers' Exclusive Tip ~ HOW TO OPEN .SWF FILES
http://personal-computer-tutor.com/newabc6.htm#tip

6.  GeekSpeak Translation from the Cap'n
http://personal-computer-tutor.com/capn3.htm

***********************************************************
***********************************************************
7.  THIS MONTH'S FEATURE

James's Database=A0***
~ ACCESS QUERIES:
=A0The Backbone of a Great Database ~
http://personal-computer-tutor.com/james6.htm
***********************************************************
***********************************************************

8.  Kathleen's Spider Web ~=A0WEB ACCESSIBILITY, Part 3:
=A0ABC, Volume 6 Passes Bobby's Test!
http://personal-computer-tutor.com/kath6.htm

9.  Chas' Word World ~ HEADERS AND FOOTERS:=A0
And How They Work ***
~~Charles Kyle Kenyon, J.D. http://personal-computer-tutor.com/chas6.htm

10. FrontPage News ~=A0GUEST WRITER THIS MONTH!
David Coons=A0=A0=A0=A0=A0=A0=A0=A0
DESIGN ABOMINATIONS:
15 Mind-Numbing Things To Avoid on Your FP Site
<<Tina WILL return next month!>>
http://personal-computer-tutor.com/dave6.htm

11.  Hal's Hardware Haven ~=A0WINDOWS XP IS HERE!:
Hal's Review of Microsoft's Latest ***
http://personal-computer-tutor.com/hal6.htm

12.  Jack's Internet Connection
(see archives for previous articles)
http://personal-computer-tutor.com/abcomputersarchives.htm
<<Jack's on vacation, but will hopefully return to us soon!>>

13. Parker's Mailbox ~=A0KEEPING YOUR OUTLOOK DATA SAFE:
How To Back Everything Up ***
http://personal-computer-tutor.com/parker6.htm

14. Chad's Macro Mania ~=A0ORGANIZING SPREADSHEETS:
Using VBA to Create a Table of Contents in Excel
http://personal-computer-tutor.com/chad6.htm

15. Corey's Network Corner ~=A0HOME NETWORKING, PT. 5:
Testing Your Home Network ***
http://personal-computer-tutor.com/corey6.htm

16. Vic's Registry RoundUp & DOS Den ~=A0
EXTRACTING CAB FILES:
The Easiest Way To Get Windows' Files Off the CD
http://personal-computer-tutor.com/vic6.htm

17. Anna's Safety Belt
<<Anna has had major computer problems and will, hopefully,return next
month>>

18. GuitarMan's Outlook Express Tips ~=A0
ORGANIZING YOUR INBOX:
Making Folders to Clean Things Up
http://personal-computer-tutor.com/gman.htm

19.  NightSneak's Snoop Scoop ~=A0
PROTECTING YOUR PRIVACY ON THE INTERNET
~ from Master Links 4 Master Investigators
http://personal-computer-tutor.com/ns6.htm

20. GUEST ARTICLE ~ AFFILIATE PROGRAMS:
What They Are & How They Work, by Christian Taylor
http://personal-computer-tutor.com/chris6.htm

21. Subscription Management

22. Contact Information

*** includes pictures in the online version
**********************************************************
******************STATION BREAK***********************
**********************************************************
If you find this newsletter and/or my website at all helpful and would
like to give me a hand here, I am now accepting donations through
PayPal.  To make a donation, go to Linda's Computer Stop and look for
the PayPal link in the left sidebar.
http://www.personal-computer-tutor.com
Thanks in advance to all who do this!!
(NOTE: no one receiving this should feel obligated in any way to do
this.....this is a FREE newsletter!) Linda, editor
**********************************************************
**********************************************************
(1.)  IMPORTANT HOW-TO MESSAGE

If you decide to go to the Online "Web-azine" version, go here first for
navigation instructions:
http://personal-computer-tutor.com/vol6.htm#HowTo

***********************************************************
***********************************************************
(2.) LINDA'S THOUGHT OF THE MONTH

I am so glad new computers are coming with Windows XP
installed instead of Windows Me.  It was beginning to damage
my self esteem every time I said "I Hate Me".

CLICK HERE FOR THIS MONTH'S ANIMATED GIF:
http://www.personal-computer-tutor.com/vol6.htm#thought
(just rightclick on the gif and choose "Save Picture As...")
***********************************************************
***********************************************************
(3.)  LINDA'S SOAPBOX
~~Linda F. Johnson, Editor

Email Etiquette
Why I Ruffle Feathers

Boy oh boy, it sure ain't easy writing email when you are a blunt,
straightshooter like me.  It seems my email gets me in more trouble than
anything else these days.

I belong to many email computer discussion groups where we exchange
advice and help each other keep our computers running up to snuff.  I
also get lots of private email asking me questions.  Now, most of these
people don't know me or my style and when I reply to them, I often get
these nasty return replies telling me how rude or "elitist" I sound.
Sometimes I'm real busy but see a question that I can answer, so I send
off a quick reply.  No flowers or smileys....just the answer.  I think
"Good, I helped another person."  Then I run off to work.

I come home, usually fried and exhausted and find an email in my inbox
telling me "Well, excuse me for asking.  If you found my question so
stupid, why did you even bother to answer it?" And, I sit back and say
"Huh?"

An example:
Someone asked a question on a list, regarding a piece of hardware she
had removed from her computer and now she had reattached it and it was
not being recognized by Windows. She mentioned that she didn't know
where the manual was. So, I thought to myself, "This sounds like me."
When I get a new computer device, I usually put the CD software inside
the manual and stuff it somewhere, once I have installed it.  So, I
figured since she didn't know where the manual was, she probably didn't
know where the software was either and that was what she needed to get
this hardware running again.  So, I quickly fired off a reply which
said, "If you don't know where the manual is, I'm assuming you don't
know where the CD is either.  You need to find that so you can reinstall
the software." I even reread it to make sure it was clear.  And, sure
enough, I got an email from someone else in that group telling me I was
rude and elitist.  Again, my "Huh?" response was triggered.

Whenever this happens, I tend to have one of two reactions:
1.) I'm mad and decide not to even answer questions anymore or
2.) I start overcompensating all over the place and pretty soon my
emails have more LOLs and smileys than content.  I kid you not.  One
time I was trying to write to someone who I knew was really fragile and
sensitive and when I reread the paragraph I had written, it had 12 LOLs
and 4 smileys and only 11 words.  LOL

So, what's my point?  Well, I guess I'm just saying that people need to
just read the facts when they read email and stop trying to assume what
is behind the words and between the lines.  Some of us who spend a lot
of time helping others on the Internet, do not have the time to sweeten
up our messages. Is it not more important that we get you the answer
than it is that we giggle and blush as we type?

Perhaps, looking back at my reply mentioned above, I could
have replied this way:

If you don't know where the manual is (becuz you often put
it somewhere where you can't remember LOL, haha, :-),
*wink wink*), I'm assuming you don't know where the CD is either (since
I do this myself a lot and figured you might too *chuckle*, *giggle*,
*blush blush*).  You need (well, you don't NEED, but it would be a good
idea *guffaw*) to find that, so you can reinstall the software (unless
you would rather I come to your house and help you find it  <offers
helping
hand> *snicker* *snicker*, *kiss* *kiss*).

Would this have made the advice clearer?
LOL  haha  *giggle* <VBG> 8^)~~~  muah!!
***********************************************************
Linda Johnson is a college instructor of all of the Microsoft
Office=A0Programs, as well as Adobe PhotoShop and Windows. She also
teaches online distance learning classes in Access, Excel, PowerPoint,
Publisher, and Word at The Eclectic Academy.
http://www.eclecticacademy.com/index.htm

She has=A0worked helpdesk and teaches and lectures at many
local businesses and tech schools in her area. Support
this newsletter by checking out Linda's website
http://www.personal-computer-tutor.com/

and her ebook series, MS Word MAGIC!
Part I: Fonts, Fun & Formats http://newbieclub.com/wordmagic/?buntah
Part II: Table Wizardry http://newbieclub.com/wordmagic2/?buntah

AND, HER NEWEST EBOOK:
How To Get Started As a Software Trainer
http://dreamjobstogo.com/titles/djtg0036.html?10456
**********************************************************
******************STATION BREAK***********************
**********************************************************
LINDA HAS ANOTHER EBOOK!!

Yes, LINDA JOHNSON has published another eBook and
this one is called HOW TO GET STARTED AS A
SOFTWARE TRAINER http://dreamjobstogo.com/titles/djtg0036.html?10456

DO YOU LOVE PLAYING WITH SOFTWARE AND WANT
TO TRY MAKING A CAREER OF IT?

That's just how Linda started out and this book she tells you exactly
how she did it and how YOU CAN DO IT TOO.

No need for a college education!
No need for professional certifications!
No need for expensive classes!

READ THIS BOOK TO LEARN HOW TO TRAIN AND
PROMOTE YOURSELF. http://dreamjobstogo.com/titles/djtg0036.html?10456

Or, MAYBE HARDWARE IS MORE YOUR BAG?

Check out HOW TO BREAK INTO COMPUTER REPAIR
By Richard S. Harris http://dreamjobstogo.com/titles/djtg0019.html?10456

Or if you have ANY DREAM JOB in mind, check out

DREAMS JOB TO GO
http://dreamjobstogo.com?10456
All eBooks are  written by been-there/done-that authors
and sell for only $9.95, with a full money back guarantee.

**********************************************************
******************STATION BREAK***********************
**********************************************************
Free Tutorials, Free eBooks, Free Courses, Free Guestbooks, Free
Autoresponders,  Free Newsletter, Free Affiliate program and FREE
MEMBERSHIP. Wow! Did I mention it was Free? Newbies and Oldbies alike
are buzzing about the NEW Newbie Club. It's the most exciting Newbie
Site ever to hit the Web.

Join now - it's FREE!
http://newbieclub.com/?buntah

editor's recommendation:
They also have an online PC Clinic now where you can receive Computer
and Internet Technical problem solving advice 24/7 for only $29.80 a
year!  I tested the service for them with some pretty tough questions
and they found the answers every time.....some took 3 or 4 emails back
and forth, but they DID solve it and they DID respond to each of my
mails within 6 hours.

I recommend this one!
http://newbieclub.com/clinic/?buntah
***********************************************************
***********************************************************
(4.)  WHAT'S NEW at Linda's Computer Stop
http://www.personal-computer-tutor.com/

Howdy gang!

1.  Boy, have I got GREAT news for my faithful
subscribers!  Ben Liebert, the owner of SWISH software
has made me an offer I couldn't refuse.  He offered me
5 FREE COPIES OF SWISH to give away in a contest and
they are only available to my subscribers.  If you don't know what SWISH
is, you may know what Flash is.  Flash is the program that creates those
cool animations you are seeing more and more on websites.  Well, SWISH
makes them too and SWISH is WAY easier to use than Flash.

So, here's the deal:

Go to my contest page and there's a link to SWISH where
you can download a FREE, fully-functional, 15-day trial version. Then
use the trial version to make your own SWISH creation. Then export it
from SWISH as an html file and email the html file, along with its
accompanying swf file and I will judge them all. The top 5 will then
receive a FREE, FULLY LICENSED, LEGAL COPY OF SWISH from Ben.

So, come on, all you budding web designers, give it a shot.
And have fun!

SWISH CONTEST FOR ABC SUBSCRIBERS
http://personal-computer-tutor.com/contest.html

2.  Since I'm a FrontPage user, Ben also asked me to write
a tutorial on how to incorporate SWISH files into an FP web,
so I did!

ADD SWISH TO FRONTPAGE http://personal-computer-tutor.com/SwishToFP.html

3.  Another addition to my life that I would like to share with you:

The Eclectic Academy has invited me to join their staff of distance
learning instructors.  So, starting in January, 2002, I will be teaching
online Internet classes in Access, Excel, PowerPoint, Publisher, and
Word.  Enroll now and join me online to learn more about how to use
these programs. The classes are only $20 for six weeks.  How can you
beat that?

ECLECTIC ACADEMY
http://www.eclecticacademy.com/index.htm

4.  MORE RECENT ADDITIONS TO MY WEBSITE:

WINDOWS KEYBOARD SHORTCUTS ~ For those who prefer
not to use the mouse. http://personal-computer-tutor.com/keyboard.htm

DOWNLOADS ~ I've added two new FREE ones:

A beautiful patriotic screensaver for those honoring the victims of
9/11.

A great concentration game made by our own Vic Ferri.
This one makes a great stocking stuffer!  The download is
FREE and if you like it, Vic will make you your own personalized one
with pictures of your friends, family, pets, or whatever you want for
only $20 (or $10 if you resize your own pictures). It fits on a floppy
disk, so I ordered one and will be putting it in every stocking I stuff
this Christmas.  It's really a clever gift idea and the download is
free, so check it out. http://personal-computer-tutor.com/downloads.htm

RESIZING GRAPHICS ~ Since Vic is offering this great
discount if you resize your own graphics, I made a tutorial
to help you as my Christmas gift to you.
http://personal-computer-tutor.com/resizegraphics.htm

REPLACING PRINTER DRIVERS ~ Lots of times, when you get
printer errors, it's because the driver for your printer has become
corrupt.  Or, many times when you visit the website for your printer's
manufacturer, you find that there is a new version of your printer
driver that you can download for free.  So, how do you replace this
driver?  Go here for full instructions from Vic.
http://www.personal-computer-tutor.com/printing.htm

OK, that's about all that is new this month.  I hope you continue to
enjoy my website.  And, the next time you are there, scroll down to the
bottom of my homepage and sign my guestbook. I would love to meet you.

Linda
http://personal-computer-tutor.com
**********************************************************
**********************************************************
THIS ONE IS COOL!!  WIN A FREE LAPTOP!!

Bob Johnson - here's a little known guy who  actually gives away a free
Pentium Laptop every month. Scroll to the bottom of his page and click
the "Laptop Drawing" image.You just have to enter your email addy - fast
and simple.  And  there's no spam - since I've entered, almost a month
ago, all I received was one email from Bob, announcing the monthly
winner.

Don't miss this one!
http://bob.onweb.cx
**********************************************************
******************STATION BREAK***********************
**********************************************************
DO YOU WANT TO GO TO SCHOOL WITHOUT LEAVING
THE HOUSE?

It's the latest rage and it's called Distance Learning.  Most colleges
now offer Distance Learning classes because they know some people work
hard and just can't fit a classroom into their busy lives.  But,
sometimes you don't want to enroll in a full program; you just want to
take one class.

ECLECTIC ACADEMY IS YOUR ANSWER!
http://www.eclecticacademy.com/index.htm

Eclectic Academy offers a large range of classes to suit
many needs.  Go there now and check out their curriculum and roster.
Classes are only $20 for 6 weeks. HOW CAN YOU BEAT THAT?

Here's a sampling of what they offer:

*Art Courses, both digital and traditional
*Business Courses, including most of the MS Office Programs
     (many taught by none other than Linda Johnson herself) *Graphics
Courses - Flash, PhotoShop, Paint Shop Pro & more *Website Development
Courses - FrontPage, Dreamweaver,
     ASP, DHTML, Website Promotion, and on and on and on *Eclectic
Classes - Computer Maintenance, Writing Workshops,
     Feng Shui, Eating Safely - just about anything you can think of

Go to Eclectic Academy now and sign up to be notified when classes are
added or ENROLL NOW in the class of your choice. Classes starting in
January, 2002. ONLY $20 FOR A SIX-WEEK CLASS!
http://www.eclecticacademy.com/index.htm
**********************************************************
**********************************************************

(5.)  And HERE'S A TIP, presented FIRST to you subscribers

HOW TO OPEN .SWF FILES

Lately, many people have been writing to me asking me how to open .swf
files.  These files are Flash/SWISH created animations and, because they
are becoming so popular now, many people are sharing them as email
attachments.  However, what people don't know is they cannot be opened
with Flash or SWISH, but instead, must be opened with your web browser.
Because these files aren't usually associated, by default, with your
browser, you need to set that up now.

Find your .swf file in Windows Explorer and double click on
it and you will probably get the Open With box, asking you
what program you want to use to open it.  In the list of programs,
select your Web Browser (ie; Internet Explorer) and put a check in the
box at the bottom that says "Always use this program to open files of
this type."  Click OK and now all your .swf files will open just fine
for your viewing pleasure.

If you don't get the Open With box and Windows is trying
to open the file with the wrong program, go back to the
file in Windows Explorer and click on it once to select it, then hold
your shift key down and RIGHT click on it to get the Open With option in
the shortcut menu.  Select "Open With" and continue with the steps
above.

Of course, no .swf files can be viewed unless you have the Flash viewer
installed and you can download that for free here.
http://www.macromedia.com/software/flash/
**********************************************************
**********************************************************
(6.)  THE GEEKSPEAK TRANSLATOR
~~Cap'n Patt Meara

**********************************************************
Visit the Cap'n's Official GeekSpeak Database at
http://www.personal-computer-tutor.com/capn3.htm

If the word you need defined is not there, just write to me at
ABComputers-owner@xxxxxxxxxxxxxxx and I will pass it on to the Cap'n.
**********************************************************
******************STATION BREAK***********************
**********************************************************
ARE YOU LOOKING FOR A RELIABLE DOMAIN HOST
FOR YOUR WEBSITE?

Hands down, I think the one I use is the very best (Hal Cardona's been
using them for over 3 years and he turned me onto them over a year ago).

*My site has NEVER been down for more than 3 minutes!
(except once late on a Saturday nite when it was being
worked on and they warned we well in advance).

*Their tech support are the greatest and I have never had
to wait more than an hour for a good answer to any question
or problem I had!

*If you use FrontPage for your webcrafting, they are excellent with
those pesky FP extensions!

*And, the email server is non-failing!

Obviously, I am a big fan of theirs.

Their name is HOSTWAY and I believe if you try them, you will never
regret it. http://hostway.onweb.cx/

And, if you sign up, tell them you were referred by
linda@xxxxxxxxxxxxxxxxxxxxxxxxxxx That will help fund this newsletter
because they give me a free month of service for everyone I send to them
:-)
**********************************************************
**********************************************************
**********************************************************
         FEATURED ARTICLE OF THE MONTH
**********************************************************
**********************************************************
**********************************************************
EDITOR'S NOTE:  It is recommended that you read the online version of
the following article which includes pictures and might make this
clearer for you. http://www.personal-computer-tutor.com/james6.htm
**********************************************************
(7.)  JAMES' DATABASE
~~James La Borde

QUERIES
The Backbone of a Great Database

If you have been following our continuing saga of database development,
you should have a database built, populated with tables and even a form
or two to get data into your database.

=93Now What?=94 you are probably asking.

Queries are the tools used to analyze, maintain, update, delete, and
restrict data. Queries are the tools that make Microsoft Access the
better choice (over Microsoft Excel) for repetitive data storage and
analysis.=A0

The Advantages of Using Queries over an Excel Spreadsheet=A0

Many users of Excel never realize the power of an Access database with
the appropriately applied Queries. Many a spreadsheet has been used
where a report based on a query could have done the job much more
efficiently. There are some major advantages and others that are
becoming less critical.

Let=92s take a look at several of them.=A0

The biggest advantage that using queries based on a table
has over a spreadsheet is flexibility. The user is able to manipulate
the data much more easily.

Let=92s take a look at a real life example.

I used to work for an amusement park. The Rides department
kept track of all of their data in Excel spreadsheets, one for each and
every day. This sounds reasonable to your average Excel user. However,
what happens when the boss now wants a report based on weekly totals?
You now have to create a new spreadsheet pulling data from all of the
appropriate spreadsheets. Then the boss asks for a monthly report. More
work for the user, either compiling the data by hand or programming.
Now, if they were using (they are now!) an Access database with the
appropriate tables and queries, it would be a simple matter of changing
the criteria for one field to gather data for a specified time frame. We
will be discussing criteria a little later, but it is a much simpler way
of compiling the data you need than adding numerous spreadsheets.=A0
Another major advantage of using an Access query over a spreadsheet is
the fact that formulas are entered only once. Any changes to your
formulas are likewise only entered once. This means no copying and
pasting or using the Fill Down option on a formula. This is actually a
two-part advantage! First, it makes modifications to the formula easier.
Second is file size (although memory and hard drives are becoming less
expensive). An Excel spreadsheet needs to store your formula every time
you use it. In an Access query, the formula is saved once and applied as
needed for every row that shows up in your query. This doesn=92t sound
like much, but when you have several formulas in a row and several
hundred or even thousand rows, it can add up. I have personally tested
this and the Access query does use significantly fewer resources as the
amount of data increases.=A0

Types of Queries=A0

The Select Query

The Select query is the most commonly used type of query.
It is used as a source for Forms and Reports as well as to preview the
other types of queries. The Select query does just as the name suggests,
it allows the user to select the data that they choose to see. This
gives the database designer a lot of flexibility. It is what enables the
designer to further limit the data that the end user may see. Not only
can it limit what data is seen; it can allow the user to see data from
more than one table.

Let=92s look at an example, a database for a distribution center.=A0

The database has three users: a supervisor,
a data entry clerk, and a shipping clerk (all referred to here as "he"
for ease of reading only). The designer wishes to allow the data entry
person to enter all of the order info, but not see anything about the
shipping information and order fulfillment. The shipping clerk only
needs to see the items ordered, not the credit card information or order
history. The supervisor, on the other hand, needs to see all of the
data. The designer builds the form for the data entry employee from a
Select query that displays only order information. The shipping form is
based on a Select query that only pulls the items ordered from the data
entry form and displays it to him. The shipping clerk then fills in his
data (for instance, location or out of stock notation) as he fills the
order. Finally, the supervisor gets to see a report, based on a
different Select query. This Select query retrieves all of the
information from both the data entry and shipping forms, along with
other information from a product table so that the supervisor can see a
very detailed view of what=92s been happening. The Select query is also
dynamic as far as time periods; the supervisor can enter a date or date
range to get a wide or narrow view.=A0 In our example, we have used the
Select query in a number of ways. First, we used it as the basis for a
Form that allows the data entry clerk to input only a portion of the
data. Next, it is used as the basis for a form that allows the shipping
clerk to view a portion of the already entered data and to add
additional information that the first user never even saw. Then we
passed it on to a supervisor and used the Select query as the basis of a
Report. This select query not only selected specific data for the
report; it also pulled additional information from a second table to
make the report more meaningful. Not only does it pull data from two
tables, but also using the same query and report, allows the supervisor
to change the report to reflect his current needs.

The Append Query

The Append query pulls data from one source and adds it to an existing
table. One use for this can be to keep the current data in a temporary
table and then move it into an archive table once it=92s no longer =
needed.
It is also the best way to remove duplicate data from an existing table!
To remove duplicate values, go to the Tables tab and copy the table that
may have duplicates and paste it in the same area. When given the
option, select Structure Only (see Figure 1 online). This will copy the
structure of your table but not the data. Go into design mode of your
newly created table and make the field(s) with duplicates you wish to
remove your Primary Key(s). Next, create an Append query. Use your
original table as the source and your new table as the destination. When
you Bang  the query, a pop-up will appear telling you that it is unable
to append X number of records due to Key Violations, and do you wish to
Continue? As you may remember, no duplicates are allowed in Primary
Keys, and that=92s why the message about Key Violations pops up. If you
answer yes, all but the duplicates will be appended. You now have a new
table with no duplicates.

The Update Query

The Update query enables the user to change large numbers
of records at the same time. This type of query is powerful
but does have its limitations. It can update one or more fields in a
table on any number of records. The biggest limitation is that it is
generally updated to a specific value, whether that=92s a static value =
or
the value of another field in another table.

Let=92s look at a couple of real world examples.

First, a record retention database holds all of the data on all of the
records a company keeps. While retaining data is important, not all of
it needs to be kept indefinitely. The Record Retention Specialist has
123 boxes of files destroyed as their retention period has expired.
Rather than having to go in and update each record manually, the
designer gave them the option of listing all of the boxes and running an
update query to set the destruction date and status on all of them at
the same time.

Another more personal example would be with your Bank
Account. Your bank pays you dividends (or charges you fees) based on
either your Lowest Monthly Balance or your balance at month-end. If they
base it on your month-end balance, they would run an Update query to
update your month-end balance with your balance at the end of business
on the last day of the month.

The Delete Query

The Delete query is another obviously named query. It does
just what it says it does, it deletes data. This can be a very powerful,
and very dangerous, tool. This allows the user to delete all data
matching the criteria given. A word of caution: run a select query with
the same criteria you are planning on for your delete query before
running your Delete. This will allow you to see what is going to be
deleted before it is actually deleted. Remember, unlike in other Office
programs, changes in Access are done immediately. Once you run the
Delete query, the items are deleted; you do not have the option of
reverting to a saved file if there was a mistake made! Access does not
require the user to hit save to make changes to the file. A change or
newly added information is saved as soon as the row (record) it is in is
left. A delete query makes this change immediate as it goes in, makes
the deletion, and moves on to the next row. For the most part, this
=93automatic save=94 is advantageous, but it can be disastrous as well.

The Make-Table Query

A Make-Table query allows you to pull a subset of data out of your
database and make a new table out of it. One example would be for your
marketing department. Let=92s say that they want to start a campaign in
one region of the country. You wouldn=92t want to give them all of your
customer data, so you run a Make Table query to pull out just the names
and addresses of the companies for the region they are servicing. You
export that data for them, they are very happy with you, and your other
customers are happy because their data is not floating around out there
and they are not getting sales l iterature on something that does not
apply to them. This type of query can also be used to archive old data.

More Advanced Query Methods =96
Union, Cross-tab and Aggregate Queries

We have reviewed the major types of queries that will be
used most often. There are other types of queries that
are a little more advanced and less commonly used.

The first of these is the Union query. Access thinks that
this type of query is so advanced that it is not a default option. The
only way to create a Union query in Access is to type it in, in the SQL
view (To get here, click View, SQL View). A Union query allows you to
combine two queries into one. There are, of course, strict limitations.
Both queries must have the same number of columns and each column must
have the same data type. I will show you an example of a Union query at
the end of this article.

Cross-tab queries are one of the few queries that are not obviously
named. If you are familiar with Excel, a cross-tab query is similar to a
Pivot Table. It takes values from rows in your table and creates columns
out from those values and allows you to group data in this manner. If
you wish to try one of these queries, I highly recommend using the
Wizard to walk through it numerous times before you ever try doing one
on your own.

Aggregate queries are somewhat obvious. They allow you to
group your records in a variety of ways. There are several options for
each column and you can combine any number that you like. The available
options for each column are Group By, Sum, Avg, Min, Max, Count, StDev,
Var, First, Last, Expression and Where. Not only can you include any
column in this type of query; you can include it more than once. One
limitation is that a column listed as where can not be included in the
result.
**********************************************************
James La Borde works in the computer department at a Credit Union, where
he uses Access, SQL Server, VBA, and ODBC daily.
**********************************************************
**********************************************************
(8.) KATHLEEN'S SPIDER WEB
~~Kathleen Anderson, Spider Web Woman Designs

WEBSITE ACCESSIBILITY
=A0Part 3=A0

This month, we going to talk a little more about Bobby, I am going to
try and answer some of Linda=92s questions about the test results, and
you=92ll get an introduction to a few other tools you can use.

First, I want to commend Linda for volunteering the ezine for me to use
in last month=92s article. This shows that she has a concern and
commitment to making her site accessible to people with disabilities.
You go girl!  =A0

If you use this link, you can see that Linda has made some changes in
the areas where Bobby indicated there was a problem and this month's
cover page has passed Bobby's test!
http://bobby.cast.org/bobby?URL=3Dhttp%3A%2F%2Fwww.personal-computer-tuto=
r
.com
%2Fvol6.htm&output=3DSubmit

To answer her question about color, it certainly can be used
to make the page more attractive, just don=92t use it alone to highlight
text or a feature =96 someone who can=92t see the color won=92t know =
what you
are trying to point out to them. Rather than saying: =93The fields =
marked
in red are required=94, you could say: =93The fields marked with an =
asterisk
are required=94.=A0 To answer the question of =93How do I let Bobby know =
that
my tables are for layout and not for data?=94, well, that=92s not really =
how
Bobby works. The visual or manual checks that Bobby suggests you do are
there because there are certain features that Bobby cannot check
automatically.  The information is listed there so that you will do the
checks that Bobby can=92t. =A0 There are other tools available (for =
free)
that can help make your web pages accessible. If you are a FrontPage
2000 or 2002 user, you can download an addin called TP_ErrOmi.
http://www.solution-shelf.com/FrontPage/ErrOmi/EO_FAQ.htm

ErrOmi has features that help you improve the accessibility
of your site, AND it also has features that help you improve the ranking
of your site with search engines. It will automatically detect whether
or not you have a DOCTYPE statement (and in FrontPage 2002 it will add
one for you if you wish), and it checks for alt text for your images.
You can use this tool from within FrontPage; it creates a new option on
the Tools menu for you.

Also for FrontPage users, Microsoft recently announced a strategic
relationship with HiSoftware, a leading supplier of Web site
accessibility software, to provide HiSoftware's AccVerifyTM SE Web
accessibility tool for all users of FrontPage. What=92s interesting =
about
this tool is that you can program it to use either the W3C Guidelines or
the US Government Section 508 rules, which is a great feature if you are
a federal government webmaster. You can also use this tool from within
FrontPage; it adds a new item to your menu bar called =91Custom=92. You =
can
register for the download here.=A0
http://www.hisoftware.com/msacc/

Another online tool, developed by the Center for IT Accommodation
(CITA), is called =93Check Your Page=94.
http://w3.gsa.gov/web/m/old_cita.nsf/CheckYourPage

On this site, you enter your URL once, and it submits the
page to Bobby, Lynx-Me (a DOS-based browser emulator),
the WAVE (a great checking service at Temple University), Vischeck, and
the HTML and CSS Validators at the W3C. And, while you=92re waiting for
the tool to run, it presents you with other links to the major search
engines so you can see who=92s linking to your page. =A0

If you want more information about Web Accessibility, I strongly
encourage you to visit the Web Accessibility Initiative Home Page at the
W3C. http://www.w3.org/WAI/

You can learn about the Business Benefits of Web
Accessibility here:
http://www.w3.org/WAI/bcase/benefits.html

And get the answers to twenty of the most commonly-asked questions about
the Web Content Accessibility Guidelines here.
http://www.w3.org/1999/05/WCAG-REC-fact

And, of course, you are always welcome to visit our site at the State of
Connecticut and see how we=92re doing =96 our target date for 100%
compliance with the State=92s policy is January 2002.
http://www.cmac.state.ct.us/access/
**********************************************************
EDITOR'S NOTE:  To see the Bobby Seal of Approval for
the cover page of Volume 6 of ABC, click here:
http://personal-computer-tutor.com/vol6.htm
**********************************************************
**********************************************************
Kathleen Anderson is a webmaster at the State of Connecticut and chairs
their committee on web site accessibility for persons with disabilities
http://www.cmac.state.ct.us/access/
She also has her own web design company,
Spider Web Woman Designs, at
http://www.spiderwebwoman.com/
**********************************************************
**********************************************************
EDITOR'S NOTE:  It is recommended that you read the online version of
the following article which includes pictures and might make this
clearer for you.  It also includes a table of keyboard shortcuts which
are not included in this text version.
http://www.personal-computer-tutor.com/chas6.htm
**********************************************************
(9.) Chas' Word World
~~Charles Kyle Kenyon, J.D.

HEADERS AND FOOTERS IN WORD

How can I get a different header/footer on the second (and
subsequent) page(s)?

This is another way of asking "How can I get a header/footer
to appear only on the first page?"

General Information:
If you ask the Office Assistant about this, you won't get a good answer.
This is because Clippy doesn't understand the concept of second page
headers. Clippy will tell you about changing the header or footer at
different places in the document by creating new sections. That will
work because the header/footer instructions are stored in the last
paragraph marker of the section.  However, he won't point out that each
section can have up to three different headers and three different
footers.

Every document has at least one section but can have more.
The number of header/footer sets for each section is
controlled in=A0File > Page Setup > Layout (tab), by checking either or
both of the options:

- Different odd and even
- Different first page

in the headers and footers frame.=A0

If you have already set a header or footer and then check "Different
first page" the header/footer you set previously will become the
header/footer for second and subsequent pages. If you check different
odd and even, you can set yet another header/footer for the odd pages
that follow page two. You can also access this dialog box from within
the header/footer view.

Many experts (including your author) believe that using headers and
footers is the best way to construct a letterhead template, with the
letterhead itself in a header with headers/footers set for "Different
first page." (Something similar is done when setting up for preprinted
letterhead as well. Even if you will be using preprinted letterhead,
follow along, then take a look at the Letterhead Textboxes and Styles
Tutorial.)
http://addbalance.com/word/download/index.htm#LetterheadTextboxesAndStyl
esTu
torial

Step-by-Step Instructions for creating separate headers/ footers without
creating additional sections:

If your template is only one page but the document based on
it can be multiple pages, you will want to set up the header/ footer for
all pages or for the second and subsequent pages before setting a
different header/footer combination for the first page. (The
header/footer for all pages becomes the header/footer for second and
subsequent pages when you select the option for a different first page.)

To do this, first (with your template being only one page)
View > Header and Footer
The Header and Footer toolbar will pop up and your insertion point
(cursor) should be in a box with a dashed border that says "Header." (If
it says "First Page Header" don't worry, we'll get to that in a bit,
keep reading.)=A0=A0
=A0
If you were in "Normal" or "Web" view, you will be switched
to Page Layout (Print Layout) view and any text on your regular page
will either turn gray or disappear.=A0 If you hold your mouse pointer =
over
one of the buttons, a tooltip should popup on your screen to tell you
what that button does.

Create the Header for All Pages or for Second and
Subsequent Pages

If you want anything to appear in the header for all pages or for the
second and subsequent pages, put it in here (in the window designated
"Header").=A0In another part of this series, I'll discuss some of the
AutoText that you might insert using the toolbar and how to get
additional entries in this list.

Create the Footer for All Pages or for Second and
Subsequent Pages

If you want something in the footer for all pages or for the second and
subsequent pages, click on the "Switch Between Header and Footer" button
on the Header and Footer toolbar. This will take you to a box at the
bottom of the page that says "Footer."

Create a Different (or No) Header / Footer For the First Page

Click on Page Setup on the toolbar.=A0 This will display the Page Layout
Dialog Box.=A0 Check the box for "Different first page" and then click =
on
OK to close that dialog. Now the header box will say "First Page Header"
and anything you typed in the " Header" box before will be gone!=A0

Type what you want to go in the header on the first page
of your document, then click on the Switch button  and type
in anything you want in the first page footer.

Save your template!

When your template is used to create a document, if the document extends
onto a second page, the headers/footers you originally typed will appear
on the second and subsequent pages.

What If It Says "First Page Header" When I Said It Would
Say "Header" in the Box's Border?

Then type in the material for the header/footer to go on
the first page. Click the "Close" button on the Header and Footer
Toolbar and insert a manual page break. That will move your insertion
point into Page 2.=A0  If you now use View > Header and Footer, the same
toolbar will pop up but this time the caption in the dashed border of
the box will be "Header." Type what you want for your second and
subsequent page header here, switch to the footer and type that for the
second and subsequent page.  Click Close on the Header/Footer Toolbar
and use backspace to delete your page break.=A0

Save your template.

Well, I think that is enough about headers and footers and l etterhead
for one sitting! I'll be back next issue with more on letterhead and
headers and footers. In the meantime, here is some supplemental reading
for extra credit.

How to Control Page Numbering in a Word Document
(don't use Insert Page Number!)
http://www.mvps.org/word/FAQs/Numbering/PageNumbering.htm

Using Date Fields in Microsoft Word (don't use Insert Date!)
http://www.personal-computer-tutor.com/chas5.htm

Letterhead Textboxes and Styles Tutorial - preprinted letterhead
formatting and more
http://addbalance.com/word/download/index.htm#LetterheadTextboxesAndStyl
esTu
torial

Letterhead System for Microsoft Word (Letter forms
that can be easily updated)
http://addbalance.com/word/download/index.htm#LetterheadSystem

Much more on headers and footers - Microsoft Word
Intermediate Users' Guide Chapter on Sections, Section
Breaks, and Headers and Footers
http://addbalance.com/usersguide/sections.htm
http://www.addbalance.com/usersguide

This column was based on http://addbalance.com/word/headersfooters.htm
**********************************************************
Chas Kenyon is a trial lawyer concentrating in criminal defense with a
long interest (obsession?) with making word processing work well in the
law office. His websites are: http://www.addbalance.com/index.htm
http://members.aol.com/~marspd/index.html
**********************************************************
******************STATION BREAK***********************
**********************************************************
Discover How To Create Stunning Letters, Presentations, Greetings Cards,
Promotional Materials, Memos, Reports And More - Just Like The
Professionals!

Imagine using the Famous Newbie Club Easy Learning
System to create Newbie-Speak Tutorials of the World's
No. 1 Favorite Word Processing Program. What do you get?

MS Word MAGIC!
eBooklet Series
by Linda F. Johnson

Book I teaches all about the formatting of text, words, and paragraphs.

Book II is all about Tables and how to use
them to get the most out of your Word documents.

And both ebooklets come with the famous Newbie Club unconditional
guarantee:

"If, within 12 months of purchase and for any reason whatsoever, you
decide that MS Word MAGIC! is not for you, simply let us know and we'll
refund your purchase price immediately. No Questions Asked! No ifs, buts
or maybes. No hidden clauses and no small print. With us, unconditional
means unconditional!"

So...what have you got to lose?  Check out this series:

Book 1:  Fonts, Formats and Fun http://newbieclub.com/wordmagic/?buntah

Book 2:  Table Wizardry http://newbieclub.com/wordmagic2/?buntah
**********************************************************
**********************************************************
(10.)  FRONTPAGE NEWS
~ This Month's Guest Writer -
David Coons
<<Tina WILL Be Back Next Month>>

DESIGN ABOMINATIONS
15 Mind-Numbing Things to Avoid on Your FP Site

They exist.  You have seen them and so have I.  Those who create them do
not acknowledge their existence, like some sort of wicked step-father or
-mother.  They huddle in the corners of cyberspace, waiting for
unsuspecting browsers to seek their audience...and then...WHAM!... =A0

"ThE AbOMiNAbLE WeBSItE" =A0

An Abomination can be defined as "That which is abominable; anything
hateful, wicked, or shamefully vile; an object or state that excites
disgust and hatred; a hateful or shameful vice; pollution." =A0

Abominable Websites come in all shapes and colors.  They
can be personal sites set up to deseminate information to family
members.  It can be gaming sites, general interest sites or business
sites.  For every purpose to design a website, there is at least one
person who has created an abominable website for that purpose. =A0

Let me open by saying that I am in no way perfect.  No web developer is.
All we can do is do our best, share what we know, and hope that we
improve as we get on in our years.=A0
=A0
So in this article, I want to discuss 15 things that can contribute to
the abomination of a website.  I hope that this list will give you ideas
or hints that will help you.  If not, then I give you personal
permission to call my mother and complain about me.  [It's all her fault
anyways] =A0

So without further adieu, I present to you
...THE LIST...=A0

1.  TOO MANY Animated GIFs
Animated GIFs are cool.  I am in no way saying that you should not have
them.  Having excessive animated gifs on a webpage, however, is
distracting and has been known to cause cerebral hemorrhages in
laboratory rats.  Please use discretion with this tool. =A0

2.  COBWEBS in your HTML
Like an old attic, some websites look the same today as they did in 1995
when Al Gore invented the Internet.  It is important to keep your
website fresh and updated.  There are several non-labor-intensive ways
to do this, including javascript 'Quotes of the Day', time-dependent
greetings and other enhancements. =A0

3.  ADS 'R' US
Advertisements are a necessary part of most websites.  T
here is nothing wrong with them when used with discernment. These are
the areas where people usually 'abominate' their website.

- Too many ads on a single page ("It should not look like the yellow
pages")
- Non-targeted, non-related ads on a page that is geared
toward a specific topic. ("Why have dog food ads on a cat
page?")
- Ad cloning ("Like I am going to click on that ad just because it is on
the page three times in a row?")

So advertise...but advertise responsibly. =A0

4.  Puke in D Minor
With the advent of the sound card, the world of computing
has forever changed.  Backgrounding your website with
annoying midi files, though, is not one of the 'good' changes from this
renaissance.  Music is cool on a website, when it is relevant ("Scary
Music on a Halloween site to add to the mood, for example") but adding
music just for kicks is somewhat annoying, especially to those trying to
listen to their CDs while browsing.  If you do use background music,
please have the courtesy to have a TURN OFF THE MUSIC button for those
not amused by your downloads. =A0

5.  "Houston, we have a problem!"
There are a million different reasons for a website to 'blow up'. You
can get programming errors [Bad ASP or JAVASCRIPT], ISP Errors [Server
Crashes] or many other sources.  The indisputable fact, though, is that
if your site is down, you need to know that it is down so that you can
either (a) fix the problem or (b) beat the crap out of someone else to
fix the problem.  The best way to keep tabs on your site is to 'hang
out' there regularly, putting it as your START PAGE on your browser of
choice.  The sooner you know that there is a problem, the sooner your
visitors can be back on your site. =A0

6.  Thingz to avoyd
Nothing detracts from the professional website like a poor command of
the English language.  Generally speaking, unless your site is geared
towards a crowd that used poor grammar and speech-skills, you need to
make sure that your words are polished.  Run things past a few people
who you feel are educated [Start with those who use utensils when they
eat and go from there] before you post it on the net.  I have seen
several discussion threads which do nothing but make fun of a particular
sites poor grasp of the English language. Could your site handle that
kind of publicity? =A0

7.  One of the worst gifts from Microsoft
Microsoft does many good things in bringing their products to
market.    FrontPage is a good product.  Unfortunately, every
rose has its thorn.  With FP, one of the thorns is the incorporation of
Web Templates.  Although I advocate templates for the most part, several
of the FP templates are not only UGLY but they are also UGLY.  [Did I
mention that they are ugly?]  So, as a general rule, only use ugly FP
templates when absolutely necessary. =A0

8.  The Bulldog-Chihuahua Syndrome
Although marketing is part of modern business and 'spin-doctoring' is
part of marketing, there is a certain point where the BS-ometer comes
into effect.  When a small, one-person office with two poorly developed
websites making up its portfolio claims to be a 'leader in the design
industry', the BS-ometer goes 'BUZZ!'.  Any time that a webmaster toots
his horn to the extreme, it is generally BUZZed as well.  What harm
comes from BUZZing?  Mainly, it is a case of credibility and
professionalism.  Microsoft or AT&T don't make boisterous claims about
how cool and tough they are.  They let the quality of their work speak
for them. Your site and your portfolio should do the same thing. [By the
way, the title comes from the phrase, 'Your BULLDOG mouth is going to
get your CHIHAUHUA [expletive deleted] in trouble'.) =A0

9.  I think Lon Chaney did this on his website...
I don't see this online as much as I used to.  Some people
are still not comfortable with META TAGS on a webpage
and the correct methodology behind optimizing for search engines.
Instead, they decide to hide their keywords in white letters on white
backgrounds, in hopes to 'fool' the search engines into thinking those
words are on the page. I saw one site (for pets) that actually had
'Pamela Anderson Lee' hidden at the bottom of the page.  Try to come up
into the 90s folks! (Yes, I know it is 2001, but they need to take baby
steps)  :) =A0

10. "The page that never ends" [Part I]
One of the things that has always confused me is the page
that seems to scroll on forever with WHITE SPACE at the
bottom.  For no reason known to modern man, these pages
have a distinctive end and then a good 12 to 13 inches of
white GOO at the bottom.  There is no scientific explanation for this
phenomenon and I pray that it does not infect your website. =A0

11. The Four-Dimensional Website
Have you ever pulled up a page and sat back in your chair
to read it, only to find that the page was four-dimensional? What that
means is that there is no horizontal or vertical absolute.  There are
FOUR arrow buttons for the page because the designer did not size the
page according to standard specifications.  There are differences of
opinions as for what resolution you should design your web pages. No
matter whose advice you decide to take, the important thing to remember
is to keep resolutions in mind when you l ayout your page and then test
it on the different resolutions to see how the majority of viewers will
see your page. =A0

12. Netscrap vs Internet Exploder
You may have your favorite browser but it is important to
know that everyone in the world does not agree with you.
You can develop your site so that it is kickin' on Internet Explorer and
just when you think you are done, you pull it up in Netscape.  In some
cases, the differences may be minimal. In other cases, you may try to
press charges against terrorists for hacking into your webpage and
reprogramming it.  To solve this problem, you may want to use IE and
Netscape regularly DURING your development process so that you pick up
problems early.  Remember that some javascript elements only work in one
or the other browser as well. =A0

13. "The Page that Never Ends" [Part II]
Earlier, we discussed the pages that have excessive 'white space' at the
bottom.  We also need to include those pages that have so much text,
graphics and other fodder that it scrolls down forever.  This is a bad
practice for several
reasons:

- Long Download Times
- PRINT PAGE is 47-pages long
- Too much information for a person to grasp at one time

Please, keep your page length within reason. =A0

14. All Bark & No Bite
One of the challenges that a lot of sites have is that they have no real
content to offer their visitors.  The way to get people to return time
and time again is to provide them with valuable information.  Links and
graphics have their place in web design, but valuable content is by far
one of the most critical elements of a web page.  Even if the content is
'borrowed' from another site through live-feeds or the old 'cut and
paste', it is going to provide more value than a site only consisting of
links to other sites. =A0

15. FINALLY, the last abomination is...
when a webmaster does not regularly test for outdated or disconnected
links.  Nothing is more aggravating them finding a gaggle of web links
that all send you to a beautiful 'HTTP 404 NOT FOUND' error message.  To
maintain your credibility and to continue to service your visitors,
please
check links at least once a week.   =A0

I am, by no means, an absolute authority on this subject but
I hope that this list has been of some use to you.  Every site usually
has at least one of these attributes and, in reality, that doesn=92t =
make
the site an abomination.  Most of these things are acceptable when used
with discretion.  Anything in excess is unfavorable, whether you are
talking about chocolate fudge or web design. =A0

Until next time, keep it real. =A0
David =A0
**********************************************************
David Coons is a freelance writer and web designer from the suburbs of
Atlanta, Georgia.  When not spending time with his wife and three
daughters, he maintains several websites, i ncluding his current
missions-related shopping site, MyFutureMall.com. =A0
http://www.MyFutureMall.com
**********************************************************
******************STATION BREAK***********************
**********************************************************
Do you want to know the latest on FrontPage?  Do you want Tips, news,
articles, links and ebooks on FrontPage?  Well the AnyFrontPage Bytes
Ezine is the best place for your FrontPage and web crafting needs, join
up at: http://groups.yahoo.com/group/AnyFrontPageBytes

Are you looking for  resources for FrontPage?  Want to know where all
the best FP links are?  The hosts, the lists, the forums? Use AccessFP -
FrontPage Resources Centre as the start site for your FrontPage
Information facts. http://accessfp.net/
**********************************************************
**********************************************************
EDITOR'S NOTE:  It is HIGHLY RECOMMENDED that you read
the online version of the following article which includes PICTURES OF
HOW WINDOWS XP LOOKS! http://www.personal-computer-tutor.com/hal6.htm
**********************************************************
(11.) HAL'S HARDWARE HAVEN
~~Hal Cardon, PC Sleuth

WINDOWS XP IS HERE!

Hello again.  This month=92s column is on Windows XP,
Microsoft=92s new and somewhat controversial  Operating
System.=A0
(There weren=92t very many comments about last month=92s article, so I
assume it was too geeky.  Sorry.  I tried to make it understandable, but
it can be difficult to translate from geek to English.)=A0

What is Windows XP?

Windows XP is a PC operating system that Microsoft has
been working on for years.  It is the first time they have managed to
combine the stability of their Windows NT based l ine (NT, 2000) with
the compatibility of the 9X line (95, 98, 98SE and ME).=A0

You=92ve probably heard people on the Internet saying that
their Windows 2000 machines never crash, well they=92re right, Windows
2000 has been Microsoft=92s best operating system to date; it is very
reliable and fast.  The downside has been a lack of compatibility for
both hardware and software, also Windows 2000 hardware requirements are
quite a bit higher than for the 9X line.  I had to wait over 6 months
from the release date of Windows 2000 for drivers for my favorite TV
Card.  If you wanted to run Windows 2000 for its reliability, most
people make their machines dual boot with Windows 98 so that they can
play all of their games.=A0The strength of Windows 9X has always been =
its
compatibility.  Just about every piece of hardware on the market has
drivers for Windows 9X.  You can run almost any program you want under
the 9X line, even Windows 3.1 and DOS programs.  The down side is that
it isn=92t as robust as 2000, it crashes more, it has problems with the
system resources issue I discussed in my third column, and there is
virtually no security.The strengths of Windows 2000 are the weaknesses
of Windows 9X.  The strengths of Windows 9X are the weaknesses of
Windows 2000.

Microsoft has done their best to combine these different operating
systems and they=92ve done a very good job.  But, there are a couple of
flies in the soup called Passport and Windows Product Activation, along
with a few others.

Versions

Microsoft has released 3 versions of Windows XP so far,
with server versions to follow.  In this article, I will discuss Windows
XP Pro and Home. I won=92t be covering the 64 bit version which is only
available for very expensive workstations that use the Intel=92s new
Itanium processor.

The most important thing for most users is that Windows
XP is Microsoft=92s first fully 32 bit operating system
designed for home users.

Windows XP Home

Windows XP Home was designed from the ground up for
home users.  The difference between Home and Pro versions
is that the Pro has some additional features that are aimed
at business users.  The most important thing about Windows
XP Home is that it is based on the reliable Windows 2000 base.

Windows XP Pro

Windows XP Pro version is designed for businesses and or
power users.  It includes everything that is in the Home version plus
some additional features.  They are:

Better networking support:

Windows XP Pro has support for additional networking
features that allow it to participate in a Domain.  It also offers
offline folders which is a boon for laptop users.

Support for Dual Processors:

Windows XP Pro includes support for dual processor
workstations.   A Dual Processor Workstation is a PC with
2 CPUs.=A0

More security options:

Windows XP Pro has more file security options than
Windows XP Home.  Windows XP Home only allows 2 types of
users:  Administrators and Limited Users.  XP Pro offers
many more types of users and the ability to customize each type, much
like Windows 2000.

Remote Desktop:

Remote desktop is a way to access and control your desktop
from another PC, like Windows Terminal Services on Windows
2000 Server.

WHAT'S  GOOD

Photo Wizard

The new Photo Wizard is just cool.  If you have seen how Windows ME
handles pictures, then you have an idea of the way folders that contain
photos can be displayed.  With XP though, it goes further.  When you
plug in a supported digital camera, XP asks what you want to do with the
pictures: copy them, print them, e-mail them, or burn them to a CD.
Another feature of the photo wizard that I really like is the ability to
print pictures from a folder; you can select the size of the prints, the
layout on the page or print a contact sheet of all the pictures in the
folder.

CD Burning

Microsoft took a page from Apple on this one and for the
first time has included CD burning support into the OS.  The
CD burning features aren=92t a threat to third party vendors=85 yet. It
works, but you will have much more control and a better interface with a
more established product.

Networking

The new networking features in XP include built in support for Wireless
802.11b, Ethernet, Home PNA (phone line), and IEEE 1394.  If you have
more than one type of network installed on an XP PC, it automatically
becomes a bridge between the various segments.  If, during the set-up
process, Windows XP detects a live Internet connection, it will
automatically update itself to the latest version.

Remote Assistance

Remote Assistance lets you invite another person to access
your PC via a network or the Internet to fix your PC. The person
requesting help can control who accesses their PC and how long they have
to connect.

Robust

Since Windows XP is a fully 32 bit operating system (no more
DOS) it is as stable as Windows 2000.  The System Resource issues under
Windows 9X are gone. XP will also allow more than one version of a dll
to run side by side with a different version.  Another new feature is
device driver rollback, if you install a driver that makes your PC
unstable Windows XP makes it easy to go back to the previous version.

Compatible

Microsoft has done a good job of making Windows XP
compatible with most hardware and software.  XP includes a compatibility
wizard that will tell programs to run under an older version of Windows.

Fast User Switching

Fast User Switching allows you to log off from your Windows session,
leaving the programs you are using open, so that someone else can use
your computer.  Fast User Switching is available in both versions of
Windows XP, but cannot be implemented if you are in a Domain based
network environment.

Security

Windows 2000 users are already familiar with the level of security
offered by Win XP Pro.  Windows 9X users are in for a treat. For the
first time in a Microsoft consumer operating system, you can limit
access to certain files and folders. XP Home doesn=92t have the depth of
security that XP Pro does, but it should be adequate for most home
users.

Firewall

A first for Microsoft!  They have included a rudimentary firewall in
both versions of Windows XP.  Unfortunately, this may give people a
false sense of security, as the included firewall only blocks incoming
connections, and most good third party firewalls can block both incoming
and outgoing connections.

WHAT'S BAD

Product Activation

Windows Product Activation (WPA) is something Microsoft
has added to Windows and Office XP to prevent casual
copying and sharing of CDs.  Microsoft=92s End User License Agreement
(EULA) has always stated that you can only install Windows on a single
PC; however, many people  have been purchasing a single copy of Windows
and using it to upgrade all the PCs in their house.  They also haven=92t
thought twice about taking their Windows CD over to a neighbor's house
and allowing them to =93borrow=94 the it.  WPA is Microsoft=92s attempt =
to
combat this problem.=A0 The way WPA works is, when you first install
Windows XP, it looks at your computer and creates a =93hash=94.  The =
hash is
50 digits long and is madeup of information from various parts of your
computer.  Things like the processor serial number, motherboard
information, Video card, MAC address from your Network Interface Card
(NIC), hard drive serial number, etc.  The hash contains NO personally
identifying information.  When you activate your copy of Windows, the
hash is sent to Microsoft along with the product key that you entered
during the installation process. Microsoft then responds with a 40 digit
number that activates your copy of XP.  You can activate your copy of
Windows XP through the Internet or by calling Microsoft. If the hash
changes enough, then you must reactivate XP, therefore preventing you
from installing the same copy of XP on more than one computer (if the
hash varies too much). You can make up to 6 changes to your hardware, if
you make a seventh you will need to reactivate. In their infinite
generosity, Microsoft has decided that after 120 days you can make 6
more changes.  If you buy a new PC from a large manufacturer, they will
probably activate your copy of XP for you and also tie it the BIOS of
your motherboard, which makes it impossible to use your copy of XP on
another computer.=A0

Passport

If you have visited http://www.msn.com, you have probably
seen the option to sign in using a passport.  Microsoft has decided to
include its passport in Windows XP.  You have to have a Passport to use
the new MSN Messenger program to chat with your buddies.  Microsoft has
messages pop up in the taskbar (the area next to your clock) reminding
you to sign-up for a passport.  Some of the wizards you run will ask for
a passport to continue, i.e.; using the Photo Wizard to order prints
from one of Microsoft=92s preferred vendors.=A0=A0
Microsoft wants you to use your passport as an e-commerce wallet to
store your credit card and shipping information. With Microsoft=92s
*stellar* security record, you may want to think twice before giving
them your credit card information.=A0
Once you signup for a passport, Microsoft and its partners
can use it to track you whenever you visit a passport
partners web site.  I have to say though, that nothing will prevent you
from signing up for a passport using Bill G from Redmond, WA.

Open Sockets

Open sockets are kind of geeky, so please bear with me.
Open sockets are a new feature to the Windows 9X line. Basically what
Microsoft has done is bring their TCP/IP implementation into compliance
with the rest of the world. Open sockets in and of themselves are fine,
the danger comes from the way Microsoft implements user security. When
you log onto a Windows XP Home system, by default you have
Administrative access.  What this means is that you can modify anything
on your system.  The problem is that if you=92re logged on as
Administrator and a hacker accesses your system, then they also have
Administrator level access, which means they can modify your TCP/IP
settings so that your computer can participate in Distributed Denial OF
Service attack (DOS).=A0 This wouldn=92t be as much of a concern if =
standard
users didn=92t have so much power over the inner workings of the =
operating
system.  In most operating systems, UNIX, Linux, Windows 2000 or XP Pro,
standard users don=92t have enough permission to modify the operating
system to the extent they do under Windows XP Home.=A0=A0 There is an =
easy
way to overcome this security hole and that is to install a good third
party firewall.

WHAT IT'S LIKE

On the whole, Windows XP is very pretty. By default it uses a new start
menu; but just like they allowed you to use Program Manager in Windows
95, you can still use the old 95 style interface in XP.  With the
default =93clean desktop=94 look the Start Menu has taken on even more
importance, it now includes a shortcut to My Computer, Internet Explorer
and your e-mail program.  You can even right click on My Computer in the
start menu just like you could from the desktop in Windows 9X or 2000.
By default, the new Start Menu also contains your 6 most recently
accessed programs on the left side and you can choose to make programs
=93sticky=94 so that they stay on the menu.  The Program Menu is now at =
the
bottom left of the Start Menu.  Like Windows 2000 and ME, it uses
=93personalized menus=94 by default.
=A0
Windows XP is more task oriented than previous versions of Windows.
When you open a folder, there are task panes on the left side which
provide you with ways to do common tasks that vary by file type.  For
example, if you open a folder full of pictures, XP=92s task panes will =
let
you print them, print one, print a contact sheet, burn them to CD, post
them on the Internet, e-mail them, or view them in a slideshow.  At
first, it felt to me that the task panes were just taking up space, but
after a while I found that they were fairly helpful.

It took me a couple of weeks to get used to the new layout
of the Control Panel.  Like Windows ME, it appears to contain fewer
choices than it did in Windows 9X or 2000.  In reality, they are just
grouped icons under some common headings. All the old options are still
there, just slightly rearranged.

On the whole I like the new interface.

SHOULD I UPGRADE?

Now for the $64,000 question.  I don=92t have any definite answers for
this one, sorry, but I can only offer some common guidelines so you can
make your own decision.=A0

First, don=92t upgrade to Windows XP if the Windows Product Activation
and/or Passport Service bother you.=A0

I personally tested XP on a variety of machines and found
that it actually ran better on lower end hardware than I anticipated.
The slowest machine I ran it on was a AMD K6-2 350 with 64 MB RAM, it
ran OK on that machine, albeit with all the visual enhancements turned
off.  I found that XP runs well with enough horsepower under the hood;
at least a 700 MHz processor and at least 128 MB RAM, but with today=92s
RAM prices I would recommend at least 256 MB RAM.  XP
also takes a bunch of space on the Hard Drive.   Microsoft
recommends at least 1.5 GB free.=A0=A0

If you are happy with the operating system you are running, then don=92t
upgrade unless you have a compelling need for one or more of the new
features.  If you are running Windows 9X and experiencing out of memory
errors or other system instabilities, then you should seriously consider
it.  If you're running Windows 2000, don=92t bother, unless one of the =
new
features is a must-have for you.=A0

Before you consider XP for an existing machine, run the
upgrade advisor (you can get it here).
http://www.microsoft.com/WINDOWSXP/home/howtobuy/upgrading/advisor.asp

Microsoft did a good job trying to make XP compatible with
as much existing hardware and software as possible, but run t he upgrade
advisor before you buy XP.  It will let you know if your favorite
program is compatible with the new operating system.  There are quite a
few utilities that won=92t make the cut. Some vendors may offer free
updates and others will want you to purchase a new version.  You should
check Microsoft=92s upgrade chart to make sure what upgrade options are
available, based on your current operating system. The chart is
available here.=A0
http://www.microsoft.com/WINDOWSXP/home/howtobuy/upgrading/matrix.asp

I want to caution you though, I NEVER recommend that you upgrade an
operating system, I always prefer doing a clean install.  It keeps you
from bringing problems with you to the new operating system.  One more
thing: BACKUP your data before any kind of an operating system change.
There are just too many chances for something to go wrong.=A0

My Impressions of Windows XP
I wanted to play with XP on a machine that could let it fly,
so I put together new machine to test it, with the following
specs:

ABIT KG7 RAID Motherboard
AMD Athlon 1.4
(2) 256 MB Corsair CAS2 DDR RAM
(2) 40 GB IBM 60 GXP Hard Drives
TDK 24/10/40 CDRW
Pioneer 16X DVD
3.5 Floppy Drive
Visiontek GeForce 3
Sound Blaster Audigy Platinum
3Com 3C905B-TX
USR PCI Hardware d/f/v Modem
PC Power and Cooling Case
350 Watt Power Supply
MS Natural Keyboard
MS Intellimouse Pro
Samsung 570V 15=94 Flat Panel Monitor

Some Observations on What I Learned:

1. The Windows XP CD is bootable and it was very easy just to follow the
prompts to get it installed. 2. The Sound Blaster Audigy was too new so
XP didn=92t have drivers for it, but the Windows 2000 drivers installed
without a hitch. 3.  There are some issues with the Windows XP default
drivers for the nVidia GeForce cards. You will need to download the
latest drivers from nVidia. 4.  When the installation was complete, my
new PC was on the Internet. (I use a cable modem to connect my home
network to the Internet.) 5.  With a fast enough PC, XP is very pretty
with all the visual enhancements turned on. 6.  I like the clean desktop
so much that I=92m using the active desktop on my Windows 2000 laptop to
get the same effect. 7.  It plays games very well, and I am having fun
with Max Payne. 8.  I=92m also playing a couple of my old Need for Speed
games since I had to test them!=A0

Personally, I like Windows XP.  I don=92t have any major issues with the
Passport or Windows Product Activation.  My wife and kids like the look
of the new operating system and the new Photo Wizard.  Once I got the
video driver sorted out, it never crashed.  I pulled over 25 games and
various programs off the shelf and in almost all cases they just worked.
I find it easier to make things work in Windows XP than in Windows 2000.
It crashes much less than Windows 9X. Finally a Windows OS where standby
and hibernation just work without having to download patches or
specialized drivers. It won=92t be long until most of the PCs in our =
house
are running XP.=A0=A0

If you do decide to move to Windows XP or just want some
more information on it, I have created a Yahoo Group called WinXPHelp,
you can check it out here: http://groups.yahoo.com/group/WinXPHelp.

As always if you any questions or comments, please e-mail me at
abcomputers@xxxxxxxxxxxxx
***********************************************************
Hal Cardona, PC Sleuth, serves as tech support and/or offsite Sys Admin
for over 200 clients around the US. He designs, builds, and
troubleshoots networks and builds custom computer systems.
http://www.pcsleuth.com
**********************************************************
**********************************************************
(12.)  JACK'S INTERNET CONNECTION
~~Jack Teems, Neat Net Tricks
<<Jack's on vacation and should be back in a couple months>>
**********************************************************
NOTE FROM JACK:  I'm afraid that I will be unable to
regularly write for ABC through the next few months. I will be on the
road by mid-October through Iowa, Indiana, then through the Gulf states
and back through Houston, Dallas, and finally wintering in Mesa,
Arizona. If things lighten up a bit after November, I might be able to
dash something off to you, but I'm afraid to commit at this point
because my plate will be rather full.

NOTE FROM LINDA:  Have a great trip Jack...we sure hope
to see you again when you return!!
**********************************************************
Jack Teems has been publishing an ezine on the Internet for more than
five years.  Now with a circulation closing in on 100,000, =93Neat Net
Tricks=94 is read in more than 145 countries. You can subscribe FREE at
the Web site, http://www.NeatNetTricks.com .
**********************************************************
**********************************************************
EDITOR'S NOTE:  It is recommended that you read the online version of
the following article which includes pictures and might make this
clearer for you. http://www.personal-computer-tutor.com/parker6.htm
**********************************************************
**********************************************************
(13.)  PARKER'S MAILBOX
~~Parker Renaud, IT Manager, Colliers Keenan, Inc.

KEEPING YOUR OUTLOOK DATA SAFE

You have a PC at work that runs Outlook on your LAN. Where
is your data? On your hard drive? On the network drive?
On both? If you are going to back up your data to keep it safe, you need
to know exactly where it is stored.=A0

Generally, on a LAN, your Outlook data is stored in your Mailbox on the
Exchange Server. If you look at the top of the Folder List in Outlook,
you will see =93Mailbox =96 Your Name=94. There is a Mailbox on the =
Exchange
Server for everyone with a company e-mail address.

What is in your Mailbox?

All the folders you see in the Folder List, plus any Sub-Folders you
create. I have created many Sub-Folders in order to organize my incoming
e-mail. I use the Rules Wizard to automatically send the e-mail to the
proper Sub-Folder. I also have Sub-Folders under Contacts for =93Tech
Support=94 and =93Colliers IT Managers=94.=A0 =A0

Obviously, I have a lot of information, very important to me, in
Outlook. Even though I am the network administrator, and responsible for
the nightly backup, I back-up this information to my hard drive, and
from there to CD.=A0

Archive

There are several ways to do this. You can =93Archive=94 the folders to =
a
location on your hard drive. To do this:

1.     Click on File>Archive and the dialog box shown below
will open.
2.     Select the folder you wish to Archive.
3.     Select the =93Archive items older than:=94 date. This date
can be any date you wish. If you archive monthly, your
archive files are much smaller and more easily manageable.
4.     Select the location where you want the archive stored.
I have created a folder on my =93C=94 drive called =93Outlook =
Archives=94 so
they are easy to find.
5.     Name the archive something meaningful. I archive once
a month and name the archive =93Inbox 09-01=94 or =93Sent Items =
10-01=94.
Outlook will suggest you put it in the folder =93
C:\Windows\LocalSettings\ApplicationData\Microsoft\
Outlook\ and name it archive.pst.=A0

Next time you archive, Outlook will try to add the new information to
the old archive and the archive file will get larger and larger. I
recommend that you create a new archive name each time you archive.

AutoArchive

Another way to archive is to =93AutoArchive=94. You can set this
up in Outlook 2000 by:

1.     Click on Tools>Options>Other>AutoArchive.
2.     When the dialog box opens all but one box is grayed-out.
Put a check mark in the =93AutoArchive every:=94 box, and the
rest of the box will be available for customization.
3.     Set the parameters you wish to use. Each folder in
Outlook has default AutoArchive settings except for
Contacts, which will not Archive. (The default settings are described in
a table in the online version of this article.)
4.     You may change these settings by highlighting the
folder in the Folder List or the Outlook Bar, clicking on
Properties>AutoArchive and setting the parameters there.
5.     If you leave your PC and Outlook on all the time, it will
not AutoArchive. Outlook only checks to see if AutoArchive
is due when the program is opened.=A0

Export Data

Another way to back-up is to Export your data to a file.

1.     Click on File>Import and Export and the =93Import and
Export Wizard=94 will open.
2.     Select =93Export to a File=94 and click Next.
3.     Choose whichever type of file you wish to create. For
back-up purposes, select =93Personal Folder File (.pst)=94 and click =
Next.
4.     Select the Folder you wish to export from and check
=93Include sub-folders=94 if desired. Click Next. (Although =
=93Contacts=94
cannot be archived, it can be exported.)
5.     Enter the Path and Filename of the *.pst you wish to
create, select an option, and click Finish.
=A0
Personal Folders

An installation of the network version of Outlook does not install any
=93Personal Folders=94, so no data is stored on your PC=92s hard drive =
by
default. However, you can create your own Personal Folders.
1.     Click on Tools>Services, and the Services dialog box
will open.
2.     Click Add, and select Personal Folders from the =93Add
Service to Profile=94 box.
3.     Set the storage location, name the Personal Folder, set
the Encryption, enter a password, if desired, and click OK.
4.     The Folders List will now have a new folder named
whatever you named your Personal Folder.
5.     You can now copy data from your mailbox folders to
your Personal Folder. You will need to re-copy this information
periodically to keep it up-to-date since the Outlook synchronization
does not involve personal folders, but you can store a useful copy of
your data right in Outlook.=A0

Retrieving Archived or Exported Data

You can retrieve your Archived, AutoArchived, or Exported
data in three ways:

1.     Import the archived items into the same file from which
they were archived.
2.     Create a new Personal Folder file and import the
archived items into that.
3.     Click on File>Open>Personal Folder File (.pst) and
navigate to your archive file.=A0

If you decide you want to back up your Personal Folder
file to removable media, you will need a Zip, Jazz, writeable CD or a
re-writeable CD since Outlook Personal Folder files tend to get very
large. If you do back them up to a writeable CD, they will become
read-only files. Outlook requires read/write access to a Personal Folder
file, but a writeable CD provides read-only access. Therefore, you will
need to copy them to your hard drive and change the file properties from
read-only, before attempting to retrieve the data.

Archiving, AutoArchiving, Exporting, and creating Personal Folders, each
provide a way to back-up your data. If you use them, there is no reason
to ever lose any Outlook information.
**********************************************************
**********************************************************
Parker Renaud is the one-man IT department at Colliers Keenan where he
manages 90 PCs on 5 servers.
**********************************************************
**********************************************************
(14.)  CHAD'S MACRO MANIA
Chad K. Welch

ORGANIZING EXCEL SPREADSHEETS USING VBA

In the last several editions I=92ve discussed the fundamentals
of Visual Basic for Applications.  Let=92s take a different approach =
this
month and start getting into the meat of VBA.=A0

One of the most common requests that I get from clients is
an easy way to navigate their large Excel databases.  If you have ever
used a workbook with many worksheets you know the hassle of finding the
specific sheet that you need.  A simple VBA macro will add a table of
contents and provide an easy way to find the sheet you need.  Remember,
when pasting the following code remove the line numbers.

1:  Sub TableOfContents()
2:      Dim ws As Worksheet, wsTOC As Worksheet
3:      Dim r As Long
4:=A0=A0=A0=A0
5:      Application.ScreenUpdating =3D False
6:=A0=A0=A0=A0=A0
7:     =A0Set wsTOC =3D ActiveWorkbook.Worksheets.Add _
8:          (before:=3DActiveWorkbook.Sheets(1))
9:      wsTOC.Name =3D "Table of Contents"
10:=A0=A0=A0=A0
11:     wsTOC.Range("A1") =3D "Table of Contents"
12:     wsTOC.Range("A1").Font.Size =3D 18
13:=A0=A0=A0=A0
14:     r =3D 3
15:     For Each ws In ActiveWorkbook.Worksheets
16:         If ws.Name <> wsTOC.Name Then
17:             wsTOC.Hyperlinks.Add _
18:                 anchor:=3DwsTOC.Cells(r, 1), _
19:                 Address:=3D"", _
20:                 SubAddress:=3Dws.Name & "!A1", _
21:                 TextToDisplay:=3Dws.Name
22:             r =3D r + 1
23:         End If
24:     Next
25:=A0=A0=A0=A0
26:     Application.ScreenUpdating =3D True
27:=A0=A0=A0=A0
28: End Sub

Now lets analyze the lines and see what they do.=A0

Lines 1 and 28 begin and end the sub-procedure.=A0
1:  Sub TableOfContents()
28: End Sub

All sub procedures begin and end in the same way:
Sub MacroName() and End Sub.=A0

Lines 2 and 3 declare variables.=A0
2:      Dim ws As Worksheet, wsTOC As Worksheet
3:      Dim r As Long

We haven=92t talked about variables yet in this column, but they are
pretty easy to understand.  In Visual Basic you can have several
different types of variables.  In this case we declare two worksheet
variables (in this case our variables are objects, if you want to get
technical) and one number variable. The variable type =91Long=92 is =
short
for long integer.  There is also a variable type =91Integer,=92 but the
largest integer available is 32,767, Excel allows up to 65,536 rows so
we will declare the variable as a long integer.

Lines 5 and 26 turn screen updates off and then back on.
5:      Application.ScreenUpdating =3D False
26:     Application.ScreenUpdating =3D True

If the processor doesn=92t have to display every change made
by the macro until it is finished running, it will run faster. Remove
these lines if you want to watch what the macro is doing as it does =
it.=A0

Lines 7 and 8 add a worksheet.
7:      Set wsTOC =3D ActiveWorkbook.Worksheets.Add _
8:          (before:=3DActiveWorkbook.Sheets(1))

These lines are actually referred to as one line.  The last two
characters on line 7 (the space and underscore) mean that the statement
is continued on the following line.  This statement creates a new
worksheet, places it before the first sheet. It also creates a reference
to it and saves it to our variable wsTOC.  Because the variable is a
reference to an object, use the =91Set=92 keyword to set the reference =
to
the object.=A0

Line 9 renames the wsTOC worksheet.
9:      wsTOC.Name =3D "Table of Contents"

Once again, because our variable is an object, it has certain properties
and methods available only to it.  One property happens to be =
=91name=92.
It can be called using =91variable.property=92 notice the dot and lack =
of
spaces between the variable and the property.  wsTOC.Name
calls the Name property of wsTOC.    In this case we are
changing the name to =93Table of Contents.=94=A0
Lines 11 and 12 place the text =93Table of Contents=94 in cell A1 and =
change
the font size to 18.
11:     wsTOC.Range("A1") =3D "Table of Contents"
12:     wsTOC.Range("A1").Font.Size =3D 18=A0

Line 14 initializes our variable r.
14:     r =3D 3

This is the row number where the sheet listings will begin.=A0

Lines 15 and 24 begin and end a for next loop.
15:     For Each ws In ActiveWorkbook.Worksheets
24:     Next

This brings up another aspect of Visual Basic: Collections. Some objects
are a part of a collection.  In this case each worksheet is a part of
the WorkSheets collection.  Every iteration of the for loop will =
=91Set=92
the variable ws to the next worksheet in the collection.=A0

Lines 16 and 23 begin and end an if statement.
16:         If ws.Name <> wsTOC.Name Then
23:         End If

The structure of an If statement is:
If condition then
         =91statements
End If

In this case we are checking to see if the current
worksheet=92s (ws) name is the same as the Table of
Content=92s (wsTOC) name.  If it is, then that means that ws
is referring to the same worksheet as wsTOC.  We certainly don=92t need =
to
list the Table of Contents in the Table of Contents.  If the condition
is passed then lines 17 to 22 are executed.=A0

Lines 17 to 21 add a hyperlink to the table of contents.
17:             wsTOC.Hyperlinks.Add _
18:                 anchor:=3DwsTOC.Cells(r, 1), _
19:                 Address:=3D"", _
20:                 SubAddress:=3Dws.Name & "!A1", _
21:    =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0TextToDisplay:=3Dws.Name

Remember the space underscore means that the statement
is continued on the next line, so all five lines here are referred to as
1 line.  Stepping through the individual parts we get:

Anchor:=3DwsTOC.Cells(r, 1) The hyperlink will be placed in cell(r, 1), =
or
range Ar where r is the row number.

Address:=3D=94=94 Because our hyperlink is a local one (not to a =
location
outside of the workbook) the address is left blank.

SubAddress:=3Dws.Name & =93!A1=94  the sub-address is the
location in the workbook where the hyperlink will point to. This address
is referenced using SheetName!Range. In other words, cell A1 on sheet
Sheet1 is referenced by Sheet1!A1.

TextToDisplay:=3Dws.Name  We will display the sheet
name in the Table of Contents.=A0

Finally, line 22 increments r by 1.
22:             r =3D r + 1

We do this so that the next iteration through the loop will place the
hyperlink 1 line down.=A0

Next month we will look at ways to display the page numbers
on the table of contents when it is printed out.  Meanwhile,
if you enjoy a challenge, try doing it yourself.  Send me your code and
I=92ll credit you in the next issue (or if you=92d rather, I won=92t =
mention
your name.  It=92s up to you).
**********************************************************
**********************************************************
Chad K. Welch works as a technician/enabler in Utah.  He is available
for consulting or application programming with Microsoft Office and VBA.
Contact him directly for more information at chad@xxxxxxxxxxxxx
**********************************************************
**********************************************************
EDITOR'S NOTE:  It is recommended that you read the online version of
the following article which includes pictures and might make this
clearer for you. http://www.personal-computer-tutor.com/corey6.htm
**********************************************************
**********************************************************
(15.)  COREY'S NETWORK CORNER
Corey Seaton

TESTING YOUR HOME NETWORK

There's no way you'll get Internet sharing if your home
network isn't configured properly. A good way of testing the network is
to try to "ping" each computer from another one. A "ping" in computer
terms is a little piece of information sent over a network that
basically says "Hello? Are you there?" If the target computer is there,
it will respond saying, "Yep, here I am".

To ping a computer, open up an MS-DOS prompt (in Windows
95/98/ME) or a Command Prompt (in Windows 2000) and
simply type, "ping (target computer's IP address)". For example, if you
wanted to ping your server computer
(192.168.0.1) from your first client computer (192.168.0.2), you would
open up an MS-DOS prompt (or Command Prompt) on the client computer and
type "ping 192.168.0.1" (without the quotes).

If your network is not configured properly, the ping will
go unanswered.

Another way of testing your home network is to share a
folder on one computer and try to access it from another.
An example of sharing folders: on the server, choose a
folder that you'd like to share with other users. On my computer I
simply have a folder "C:\Phil Share". Right-click on this folder and
choose "Sharing".

Click on "Shared As" and select the options you want. I have "C:\Phil
Share" shared as "PHIL SHARE" with full access and no password.

Now put something in this folder. Now go to another
computer and go into Network Neighborhood. You should see
the names of all the computers in your network (if you don't, something
is wrong - do all the computers have the same Workgroup? If they do, you
should see them there. Try pressing F5 to refresh the view. If they
still don't appear, and don't appear after 10 or so seconds and a new
Refresh, then your network is not configured properly. Go over all the
steps in my previous article and see if you've made a simple mistake
somewhere). Now you should be able to double click on the computer with
the shared directory, open that directory and copy the file.

Cool eh?! If this all worked, you're in business - it's time to set up
your Internet sharing. If it didn't work, you'll need to go over the
steps above and make sure you did everything right - it's very easy to
make a simple mistake, and such mistakes can easily prevent your network
from functioning. Please don't try to install any Internet connection
sharing or firewall software until you can at least ping every computer
from the others - keep it simple!

By the way, you can easily share a printer using roughly the same
technique - go into the Printer Control Panel on the c omputer connected
to the printer, right-click on the printer name and choose "Sharing" and
then click on "Shared As:" and then "OK". Then go into the Printer
Control Panel on a client computer, double-click on "Add Printer", click
"Next", choose "Network Printer", click "Browse" to find the printer,
etc - it's not very hard and it's beyond the scope of this tutorial so I
won't explain it all here.

Happy Networking!
**********************************************************
Corey Seaton is a Systems Support Officer with Queensland Health.  He
also moderates an email group on Home Networking. Why don't you join and
talk to others who are networking their home PCs?
http://groups.yahoo.com/group/networkinghelp
**********************************************************
******************STATION BREAK********************
**********************************************************
Are you into Video Computing?

VIDEOMAKER is the world's most popular monthly consumer video production
publication and covers the use of digital video editing, camcorders,
cameras, and desktop video and audio production for novice and expert
enthusiasts alike. Its articles  teach production techniques, survey and
review the latest equipment, and explain the newest technological
advances.

Published monthly, and is available on select newsstands and to
subscribers.

In addition, you receive a password giving you full access to Club VId,
Videomaker's vast online resource of information about making video.

And the best part is, it's CHEAP!  Only $14.97 for 13 issues!
http://www.angelfire.com/rnb/vxdoin/VideoMaker.html
**********************************************************
**********************************************************
(16.)  VIC'S REGISTRY ROUNDUP & DOS DEN
~~ Vic Ferri, Windows Tips & Tricks

FASTEST WAY TO EXTRACT CAB FILES
Windows 95\98\98se

This=A0is=A0my most popular bat file=A0-  the fastest, easiest way
to extract cab files in Windows 95 or 98.  I've been using
this method to=A0search and=A0extract=A0cab files for years and
I have yet to see=A0any easier, faster=A0or more=A0efficient=A0way
to=A0do this without the need for any=A0outside utility or program.

Why would you want to extract cab files?  Well, when one of your Windows
files is corrupt or missing, this is where they are located on your
Windows CD.

I=A0will try to make this easy to=A0understand for even the novice, by
giving a step by step=A0guide.

In this demo,=A0I=A0am assuming that your cab files are located
on your CD in D:\Win98se.  Make sure to=A0substitute with
the path of your own Windows cab files or Windows CD,
if different from in the=A0demo.
=A0
Ok, here's what to do, step by step.

1.  Open up a new Notepad document  or any other text editor and copy
and paste these commands into it.  Once pasted, remember to subsitute
the path.

@echo off
md c:\windows\desktop\WinFiles
if "%1"=3D=3D"" goto error
CLS
c:
cd c:\windows\desktop\WinFiles
for %%i in (D:\Win98se\*.CAB) do extract %%i %1
ECHO.
IF EXIST %1 ECHO %1 successfully extracted.
IF NOT EXIST %1 ECHO %1 not found
goto end
:error
echo.
echo Syntax: CabX file-to-extract
echo Example: CabX Control.exe
echo.
:end

Save the file as CabX.bat in your C:\Windows directory.
(make sure you use the .bat extension and not the .txt extension that
you would normally use in a text editor such as Notepad)=A0
=A0
2.  Now create  a shortcut to CabX.bat by right click and dragging it
from your Windows folder to your Desktop and choosing "New Shortcut
Here" from the context menu that pops up when you release the mouse
button.
=A0
3.  Right click your new desktop shortcut and go to
Properties.  Click the Program tab. Enter a space
and a ? mark at the end of the command line,
ie: C:\Windows\cabx.bat ?=A0

4.  Click Apply and then click Change Icon to choose a more friendly
icon.  Finally, rename the shortcut to CabExtract or whatever you
prefer.
=A0
You now have a desktop shortcut that will almost instantly extract any
cab file from your Windows CD by just entering the name. The file will
be extracted to a a folder named
WinFiles, on your desktop.   Test it out.

Click the shortcut and enter explorer.exe and click ok.
Within seconds, you should have explorer.exe extracted=A0
to the newly created WinFiles folder.

Another benefit of this method is that you can see where any cab file is
located. You don't have to go looking for it. Therefore it searches,
finds and extracts all in one shot.

TIP: If the scrolling is too fast and you need to know the location of a
particular cab file,  extract the file and then enter the name again to
extract it a second time. This will cause DOS to stop at the location of
the cab file to ask you if you want to overwrite the one you already
extracted, and thus give you a clear view of the location of the cab
file. Once you note the location, click No.=A0

You can also enter wildcards and partial names if you're not sure of the
name of  a file you need.  For example, say the file you need is
comctld32.dll but you're not sure of the spelling. Just enter something
like com*.dll  and it will extract all dll files that begin with com.
=A0
Or if you don't know the extension either, simply enter
com*.* and ALL files that begin with com regardless of extension, will
be extracted.
=A0
You can also extract multiple files.

Say you want to back up all your dll files. Just enter *.dll and every
single dll file will be extracted.
=A0
Say you want to backup ALL your Windows cab files.  Just
enter *.* and every single file from every single cab file will be
extracted.
=A0
You can also run the actual bat file (not the shortcut) in native DOS or
at the Runbox by entering the name of the bat file followed by the name
of the file you  want to extract.

For example:
cabx kernl32.dll would extract kernl32.dll.

Note that you don't have to enter the extension of the bat file. cabx is
all you have to enter, not cabx.bat.=A0

Note: If=A0you are a newbie when it comes=A0to DOS and would
like an easy to understand book that will teach you DOS in plain
English, there are two books in the popular Dummy series I would
recommend -  Dos For Dummies and Dos For Dummies=A0Quick =
Reference.=A0=A0Both
are excellent and very thorough.  Find out more at my DOS Books page.
http://www.angelfire.com/on3/vxdoin2/dosbooks.html
**********************************************************
**********************************************************
Vic Ferri owns the very popular
WinTips and Tricks email group
http://groups.yahoo.com/group/WinTips-Tricks
and his website which accompanies it.
http://www.angelfire.com/on3/vxdoin2/windows.html
He is also in charge of the Printing Tips page at
Linda's Computer Stop.
http://www.personal-computer-tutor.com/printing.htm
ans also the Registry Tips page.
http://www.personal-computer-tutor.com/vic4.htm
**********************************************************
**********************************************************
(17.)  ANNA'S SAFETY BELT
~~ Anna Morvee

<<Anna had major computer problems and was unable to get this month's
article to me.  Hopefully she will be back with us next month.>>
**********************************************************
**********************************************************
Anna Morvee has been researching computer viruses and other Internet
safety issues for over five years.  She now spends most of her time
educating the public about these things.  She is also the Co-Founder and
Managing Editor of A Peace of Life, a site devoted to helping those that
have suffered any kind of abuse. http://www.apeaceoflife.com
**********************************************************
******************STATION BREAK***********************
**********************************************************
NOTE FROM THE EDITOR:  On my Windows page at Linda's
Computer Stop, I list many email groups that deal with Windows and other
related PC issues.....one of my favorites is PCTechTalk, a great group
for newbies and techies alike.  It's run by a guy named Guitar Man and
he does a fantastic job.

http://groups.yahoo.com/group/PCTechTalk

G Man runs a free, 24-hour-a-day email tech list where you
can submit any questions you have about computer hardware
& software. You can request fixes for specific problems
you're having with your computer or just sit back and learn from the
conversations of the other members. This list is one of the only PC
Groups I've found that truly caters to newbies and nerds alike, so you
can be assured that your questions will be taken seriously. To join,
either click on the PCTechTalk link above, or send a blank email to
PCTechTalk-subscribe@xxxxxxxxxxxxxxx

@@@@@@@

 (18.)   OUTLOOK EXPRESS TIP
~~PCTechTalk's Guitar Man

ORGANIZING YOUR INBOX

Now that we've discussed how to back up your all-important Address Book
and all of those email accounts you've managed to accumulate (I
currently use 8 of them), let's focus our attention on cleaning things
up a bit and getting better organized.=A0=A0

When you first bring home a new computer (or just after a reformat and
reinstall of Windows), chances are very good that Outlook Express is
already installed on the system. Actually, I've never seen a Windows
system that lacked this highly versatile email/newsletter program.
Unfortunately, it doesn't know anything about you or your interests.
When you first set up your email accounts, all of the messages you
receive will be unceremoniously dumped into your Inbox and you'll need
to go through them one at a time while deciding which ones are
important, which ones can be deleted and which ones you might even want
to save for future reference.=A0
If you receive a lot of email, this can get quite tedious.=A0

The first step to gaining some semblance of control over
this chaos is to create some new subfolders to keep your messages better
organized. To help you with this, here is the easiest method I've found
along with some organizational suggestions.

With your mouse cursor hovering directly above the Inbox folder, right
click and a context menu will appear. Choose "New Folder" from this menu
and a window will pop open. Type in an appropriate name such as
"Friends" and then click on the OK button at the bottom of the window.
Immediately, a new folder called Friends will appear as a subfolder of
your Inbox. This would be all you need if you only have one friend who
sends you email.  However, that's rarely the case,  so let's create some
additional subfolders to keep our friends messages separate from each
other.=A0

Following the same procedure above, right click directly on
the Friends folder, choose New Folder from the menu and
give the folder the name of one of your friends.  Repeat the process
until you've given all of your current email-sending friends their own
special folder.

Now that you have all of these folders set up, go back to
your inbox and move their messages into the appropriate folders. You'll
find it much easier to do this if you click on the thin "From" bar along
the very top of the Preview pane (where you actually read the messages
they send) since this groups all of the messages by the sender's name in
alphabetical order.  Click it again to reverse the order if you prefer.
Now, click once on the top message from one of your friends to highlight
it. Hold down the Shift key on your keyboard while you click once on the
last message from the same person. This procedure will select ALL of the
message from that person.  Now, it's just a simple matter of using the
left mouse button to grab and drag any of that person's messages to the
proper subfolder. If done correctly, you'll see that you've actually
moved ALL of that person's messages at once. Now, go and do the same
thing for all of your other friends' emails.

After cleaning up stuff you've received from your friends,
you can make other folders under the Inbox to help you
organize stuff ranging from email lists (such as my
PCTechTalk group) to newsletters to jokes to whatever else
you need.   Just remember that even if you make a mistake,
you can always Rename a folder or even Move it to another location after
it's been created.

Next month, we'll discuss how to set up Message Rules so
that new email will automatically filter into the folders you decide to
create.

@@@@@@@
EDITOR'S NOTE:  ABC is building an archive of G Man's OE Tips
http://www.personal-computer-tutor.com/gman.htm
@@@@@@@

The group's motto of "The only dumb questions are the ones that are
never asked." reflects their philosophy that ALL questions are important
and they sure do treat them that way.  Also, if you've ever been a
member of an email list, you'll appreciate that this list's moderators
do not  allow Spamming, flaming, cursing, etc.. To sign up, just send a
blank email message to

PCTechTalk-subscribe@xxxxxxxxxxxxxxxx
**********************************************************
**********************************************************
(19).  NIGHTSNEAK'S SNOOP SCOOP
~~Links For Finding Missing People ~
from "Master Links 4 Master Investigators"

PROTECTING YOUR PRIVACY ON THE INTERNET
=A0
A hot topic these days, and one that is causing serious discussions and
new legislation around the world. There are very good reasons for people
to protect their privacy, such as protection from SPAMmers, protection
for your children, i dentity theft and any number of other reasons. Here
are some sites to find out what you need to know to protect yourself on
the Internet.

An excellent tutorial on all aspects of computer privacy is
put out by All Nettools.
Practical Privacy Guide
http://www.all-nettools.com/privacy/=A0

One of the premier sites for computer security and privacy, Infosyssec
has links to articles, news, newslists, tools, organizations, and
information both for the US and Internationally, both for the
technically minded and the newbie. Infosyssec--Security Portal for
Information System Security Professionals
http://www.infosyssec.com/infosyssec/anon1.htm

EPIC is a public interest research center in Washington, D.C. It was
established in 1994 to focus public attention on emerging civil
liberties issues and to protect privacy, the First Amendment, and
constitutional values. Get the latest news and legislation on privacy
issues. Electronic Privacy Information Center http://www.epic.org/

You can keep information from going out from your
computers with this list of Firewalls, Cleaners, Blockers,
and more from Privacy.net
Privacy-Related Software
http://www.privacy.net/software/

Here is a site that has a searchable database on current and pending law
suits on privacy issues. The Privacy Foundation=92s Legal Database =
Search
http://www.privacyfoundation.org/legal/index.asp

Hide your true identity by using a Remailer service. These systems
either give you an anonymous address, to which other people can send you
mail, which is then forwarded to your real address, or they post or mail
your message without any trace of the sender's name or address.
Anonymity and Privacy on the Internet=97Remailers
http://www.stack.nl/~galactus/remailers/index-anon.html

This site has a privacy web surfing option right on the home page. Just
enter the URL of the web site that you don=92t want to be identified on,
and Anonymizer.com will take you there anonymously. They also have free
and paid versions of software for your computer. This is one of the last
free Anonymous services available on the Internet.=A0 Anonymizer.com
http://www.anonymizer.com/

This site below has a one-time fee that gives you unlimited access to
the service for Life. They don=92t say whose life though.=A0
Ultimate Anonymity--Anonymous web surfing, newsgroups,
e-mail, IRC, web based chat rooms and more.
http://www.ultimate-anonymity.com/
**********************************************************
Find these and more links at our easily-searchable site of over  15,000
links. Subscribers to this newslist will be given a free trial period.
E-mail me at the below address for access.

nightsneak
Master Links 4 Master Investigators
http://www.ml4mi.com/
info@xxxxxxxxx
**********************************************************
******************STATION BREAK***********************
**********************************************************
Dear Readers,

In searching the internet looking for marketing ideas, have
you ever thought, I wish their was just one website that
was uncluttered and gave me simple, concise, alphabetically listed ways
of increasing web traffic and nothing else? A website that has nothing
on web design, hosting, guru's, secret books, just decent information
and resource's for the average person trying to build a successful
business? Well its finally here and about time.

This site is a really great resource centre no matter what
your marketing needs, because simply put "it's relevant and user
friendly". Please take a look and by all means if you have any
suggestion's or comments don't hesitate to send me an email, all is
welcome.

Best wishes.     Chris Taylor

Contact Details:
http://www.thewebtrafficco.com
christiantaylor1@xxxxxxxxxxxxxx
**********************************************************
**********************************************************
(20.)  GUEST ARTICLE

AFFILIATE PROGRAMS
What They Are & How They Work
by Christian Taylor
The Ultimate Web Traffic Resource Centre http://www.thewebtrafficco.com

Affiliate programs allow other people (third parties) to advertise your
product on their website usually via text or banner links which you have
supplied. Interested customers then click on one of these links and are
brought to your website to view your product or products. If one of
these customers purchases a product, the third party is then paid a
commission due to the fact the customer originated from their website.
The larger number of affiliates you have in a program, the more exposure
you get over the internet.

To start an affiliate program you can use an affiliate management
company (example: Commission Junction) or run it yourself. To do this
you will need the appropriate software which will sign up new members,
hold banners, tracks hits, sales etc.

If you wish to sell other peoples' products, you can of
course join affiliate programs yourself. Some programs will even give
you a free site/page based on their product which usually includes your
name and email address. This is quite handy if you don't have your own
web site.

When joining programs the most important aspect is the
product. If you choose a bad product, it won't sell and, worst of all,
it will be bad for your site's reputation. Customers go back to sites
where they received good products, service and value. A few other things
to look for are:

- the program should be free to join
- commission payments should be paid monthly
- must be able to track people coming from your site
- decent text link and banners supplied

If you are thinking of joining a number of affiliate programs, I would
advise strongly in purchasing affiliate manager software which will save
you much time and hassle. For more information on affiliate programs,
please visit my web site and go to the Ultimate Resource Links page.
http://www.thewebtrafficco.com/Ultimate%20Resource%20Links.htm

Christian Taylor
The Ultimate Web Traffic Resource Centre http://www.thewebtrafficco.com
**********************************************************
**********************************************************
Well, gang.....that's about it for this edition of ABC ~ All 'Bout
Computers.  I sure hope you enjoyed it!  If any of it was over your head
and you need some clarification from one of the Fleet, just send me an
email at ABComputers-owner@xxxxxxxxxxxxxxx and I will pass it on to
them.  Remember that they do this in their spare time on a voluntary
basis, so you might have to wait for an answer.  To make all things work
more quickly, include as many details as you can in your email and make
your questions as specific as possible.  Also, feel free to write to me
and let us know what you want the Fleet to teach you.  This is YOUR
newsletter!

Happy computing, my friends!

Linda Johnson
http://www.personal-computer-tutor.com
ABComputers-owner@xxxxxxxxxxxxxxx

**********************************************************
READ THIS CAREFULLY!
**********************************************************
-------------------------------------
(21.)  SUBSCRIPTION MANAGEMENT
-------------------------------------
In order to get what you want, you must send your email to the right
place. These are the correct addresses to use:
Subscribe: ABComputers-subscribe@xxxxxxxxxxxxxxx
Unsubscribe: ABComputers-unsubscribe@xxxxxxxxxxxxxxx
Ezine owner: ABComputers-owner@xxxxxxxxxxxxxxx
Or, you can go to the homepage for this newsletter and change any of
your subscription preferences: http://groups.yahoo.com/group/ABComputers
This FREE publication is sent ONLY to people who have requested it.
Note: My subscriber list is NOT made available to other companies. I
value every subscriber and respect your privacy. Do you know anyone who
might be interested in receiving this newsletter? Please feel free to
forward it on to them and invite them to subscribe.
-------------------------------------
(22.)  CONTACT INFORMATION
-------------------------------------
Routine Disclaimer: Although I make an effort to check out every
advertisement and link, I cannot assume responsibility for the actions
of my advertisers, or the availability of links. You use the information
provided at your own risk, it is always wise to back up your data before
editing.All advice given in this newsletter/ezine or at Linda's Computer
Stop is given with the best of intentions and should only be taken as a
suggestion and not a definite fix to a problem. ABC ~ All 'Bout
Computers and Linda's Computer Stop are the property of Linda F.
Johnson. The views expressed by readers or contributors are not
necessarily those of Linda F. Johnson and, as editor, she reserves the
right to deny inclusion of any contributions if she feels they could be
harmful to someone's computer. However, just because she allows it to be
included, does not mean she is responsible if it causes problems. ALL
READERS ARE RESPONSIBLE FOR THEIR OWN COMPUTERS! Please help promote
ABComputers by linking to my sites.
http://www.personal-computer-tutor.com
http://www.personal-computer-tutor.com/ABC.htm
or, click on these links to become an affiliate under me and you will
earn money if you sell any of my ebooks (or any other books published by
these companies, for that matter):
http://newbieclub.com/cgi-bin/sgx/d.cgi?affiliate-buntah
http://intellectua.com/cgi-bin/sgx/d.cgi?affiliates-10456

Thank you for reading "ABC ~ All 'Bout Computers".
(Copyright) 2001 - ABC ~ All 'Bout Computers, Linda F. Johnson, MA. ABC
may only be redistributed in its unedited form. Written permission from
the editor must be obtained to reprint or cite the information contained
within this newsletter. Please feel free to forward this newsletter to
any of your associates who might benefit from this information. If you
are receiving this issue as a forward, and would like to get your own
free subscription, please see subscription management above, or visit
http://www.personal-computer-tutor.com/abcomputersarchives.htm
to see back issues.

Thank you and I hope to continue to bring you a newsletter that you will
actually want to read.

Linda Johnson
http://www.personal-computer-tutor.com
ABComputers-owner@xxxxxxxxxxxxxxx










Other related posts:

  • » [abcomputers] ABC~All 'Bout Computers, Vol. 6: Access Queries Explained,Hal's Review of Windows XP, and Lots More!