Thursday, December 31, 2015

Free Assistance

Worth a lot more than you pay for it


Here is a site that gives presentation hints. Also, free clip art, free templates, a forum, and quotations.
"There are always three speeches, for every one you actually gave. The one you practiced, the one you gave, and the one you wish you gave."
-- Dale Carnegie



PresentationMagazine.com:
Presentation Magazine



See all Topics

Wednesday, December 30, 2015

Hip Replacement

Do it yourself


Well, not exactly.

The Northwest has a great PBS radio station in KUOW.

Here is a story about how surgeons work, including a blow by blow description of a hip replacement operation.
. . . "this hour: the surgeon's hands. How do surgeons keep their hands healthy? What kind of training do they go through to keep their fingers tactile and sensitive? How important is touch to successful surgery? Are the hands of surgeons gifted? Over the past month, we've been talking with people who use their head and their hands in their work. Our 'How To' series continues today with surgeons.

Guests

Richard Ellenbogen, M.D. chairman of neurological surgery at the University of Washington School of Medicine, the Theodore S. Roberts Endowed Chair in Neurological Surgery, the Chief of Neurological Surgery at Harborview Medical Center

Eric Froines, M.D., F.A.C.S. chief of general surgery, Capitol Hill Specialty Center Group Health Permanente"

How to Operate


For more information, here is a link to the University of Washington:

What is Hip Replacement?
A Review of Total Hip Arthroplasty, Hip Resurfacing, and Minimally-Invasive Hip Surgery.






See all Topics

Tuesday, December 29, 2015

New Default Access Form Template

Set new standards



You can change Access's default form.

To set up a custom template,
  1. Create your template form by specifying all the properties you want to maintain from form to form.
  2. Then, save the form using any name.
  3. Next, select Tools>Options from the menu bar and select the Forms/Reports tab.
  4. Enter your template's name in the Form Template box to replace the Access default (Normal) and click OK.
The next time you create a form, Access will base it on your form template rather than the typical Normal template.

In Access 2007-10, click the Office button in the upper left corner and the click Access Options.
The design options are located under Object Designers: Forms/Reports.
The same thing can be done with Reports.

 

 (The settings are saved in the Access workgroup information file, not in a particular data base)

Also: MeadinKent.co.uk: Making a report template



See all Topics

Sunday, December 27, 2015

History of the Internet

Time passes quickly


You can defend the Internet beginning in the early or late 60's. This link follows the history back to the invention of the "computer" in the 1700's to today.

Netcraft survey reports there are more than 74 million web sites online, while in 1993 only 130 web sites existed online.

A Computer History of the Internet Timeline

Also:
Here's a nice site:
The Living Internet

The Internet SOCiety:
History of the Internet

Also:
Internet History



See all Topics

E-Mail Headers

How to read the code


Spam is as ubiquitous in email as it is in an Hawaiian restaurant.

These links may help you distinguish pork shoulder from the other stuff.


"This document is intended to provide a comprehensive introduction to the behavior of email headers.

It is primarily intended to help victims of unsolicited email ("email spam") attempting to determine the real source of the (generally forged) email that plagues them; it should also help in attempts to understand any other forged email.
It may also be beneficial to readers interested in a general-purpose introduction to mail transfer on the Internet. "


StopSpam.org:
E-mail Headers


"The ability to read and decipher email headers is a useful skill to learn for tracing messages to their original source and diagnosing many other problems. Headers may contain a lot of information but the most important information will always be contained in every email header."




See all Topics

Saturday, December 26, 2015

Web Queries

Do You Question the Web?


This feature can make data acquisition a lot easier than Copy-Paste-Reformat-Try again.

"Generally, though, people tend to overlook the option of using the Web as a data source for Excel, be that source the Internet, an intranet, an extranet, or a Web Service. But they shouldn't. Web queries are an easy, yet remarkably flexible and predictable way of bringing data into Microsoft Excel from anywhere on the Web. You can point a Web query at any HTML document that resides on any Web server - or even on a file server, for that matter - and pull part or all of the contents back into your spreadsheet...When you start using Excel's Web queries, you will realize they are almost as limitless as the Web is.

Well Kept Secret

On the menu bar, go to Data>Import External Data. (In 2007-10, Data>Get Extrnal Data>From Web). Then, select Import Data to use an existing Web query or select New Web Query to build a new one.

Web Query

Also see:
Vertex42.com:
Excel Web Query Secrets Revealed

Integrate Far-Flung Data into Your Spreadsheets with the Help of Web Services

And:
Web Queries and Dynamic Chart Data



See all Topics

Friday, December 25, 2015

Insert>Fields

Tiny code snippets


Microsoft has included a number of code pieces that you can use without having to haul out the VBA editor. These codes handle such things as page numbers, Table of Contents, Merge data and more.

"Some 80-plus fields are built into Word that provide information about the file and the user; store, display, and manipulate reference information; and link the document to other applications - all without a bit of code."


Automate Word Documents with Minimal Code
By Cindy Meister


Cindy Meister is a Word MVP.

She also works with bobbin-lace. Here is a sample of a Honiton lace butterfly.

Also:

AddBalance.com:
Using { Fields } in Microsoft Word

GMayor.com
Formatting Word Fields with Switches

In 2007-10 you can use the =(Formula) field.
On the Insert tab look for Quick Parts:





See all Topics

Thursday, December 24, 2015

Frame that Slide

More PP bling

Face it; we've seen every graphic in ClipArt and every background color combination. Putting a frame around an ordinary object can make it pop.

Here is a link to instructions about how to frame your pictures. There is also a download for extra frames.





Create Picture Frames in PowerPoint
by Geetesh Bajaj



See all Topics

Wednesday, December 23, 2015

GIF Editor

Free tool


Here is an online GIF image editor. You can create animated GIF files and save them to your site or your machine.

There is nothing to download. All the work is done on line.





"Create your own special effects with any GIF -- even animated ones! Resize it, colorize it, optimize it, and jazzercise it -- then save it and take it with you. You name it and you can do it!

It's simple! Using the easy-to-use pull down menus. Simply follow the instructions to load any GIF and then manipulate the image using the GIFMagic menus. It's that easy."


GIFMagic



See all Topics

Tuesday, December 22, 2015

Change Properties in Form View

Alterations on the run


As you work with a form, you will, sometimes, find controls would benefit from minor tweaking. You may want to change the color of a text box, change the font that's used, or remove scroll bars.

You may have been told switch to Design view to make changes. However, you can display the property sheets for a control while you're in Form view.

To do so, click the Properties on the View menu, Right-click, or press [Alt][Enter].
As in Design view, the displayed properties relate to the control that is selected on the form. The property changes you make are reflected on the fly.
You will be prompted to resave your form when you close it.



See all Topics

Monday, December 21, 2015

Seniors Surf Too

No Internet age limit


You don't have to show a drivers license (expired or not) to wander through cyber space,but. . .





As the oldest Baby Boomers turn 60, marketers and the media are waking up to the power of older consumers. Unlike today's seniors, Boomers are dedicated Internet users and broadband fans. As they approach the next phase of their lives, they will challenge companies to keep up with their ever-demanding ways, both online and off.

Also see:
King County Seniors on line

Pierce County Seniors



See all Topics

Sunday, December 20, 2015

Control Panel

Be empowered


"Control Panel provides a set of special-purpose administrative tools so that users can configure the Windows, applications, and services environment. It includes default items in Control Panel for common tasks, for example, Display and Add Hardware. User-installed applications and services can also insert their own icons into Control Panel.

There are two view options for Control Panel: Category View and Classic View.

Category View displays Control Panel icons according to the type of task that the user wants to perform.

Classic View displays Control Panel icons in a view that is familiar to users of previous versions of Windows."


  1. Click Start, and then Settings

  2. Click Control Panel.

  3. Click Appearance and Themes, and then click Folder Options.

  4. Open Folder Options.

  5. Under Tasks, click "Show common tasks in folders", and then click OK.

  6. In the Control Panel box in the upper-left corner of Control Panel, click "Switch to Category" or "Switch to Classic View".
Go to View and choose how you want the contents to be displayed. "Icons" is the Classic view, but details will show the purpose of each entry. For more information about Control Panel icons, see:
  • Accessibility Options
  • Add Hardware
  • Add or Remove Programs
  • Administrative Tools
  • Date and Time
  • Display
  • Folder Options
  • Fonts
  • Game Controllers
  • Internet Options
  • Keyboard
  • Licensing
  • Mouse
  • Network Connections
  • Phone and Modem Options
  • Power Options
  • Printers and Faxes
  • Regional and Language Options
  • Scanners and Cameras
  • Scheduled Tasks
  • Sounds and Audio Devices
  • Stored User Names and Passwords
  • Speech
  • System
Microsoft Product Documentation:
Control Panel



See all Topics

Saturday, December 19, 2015

Make a List

How to check it


January is the month that bird watchers try to find as many birds as they can.

This is only one kind of list. This link helps you create a list of 453 Washington state birds and more.

There's also a list for a motorcycle first aid kit.

Checklists for Motorcyclists


Also see:
Pack Light

And read this book to get yourself ready. (Maybe next year.)

The Big Year : A Tale of Man, Nature, and Fowl Obsession



See all Topics

Friday, December 18, 2015

Big Year, The

A Tale of Man, Nature, and Fowl Obsession


By Mark Obmascik
ISBN 0743245458
Free Press; (February 4, 2004)



About the Author
Mark Obmascik was the winner of the 2003 National Press Club Award for environmental journalism. He has a story tellers ability to, not only describe the setting, but to draw the reader into the adventure.

Book Description
2.4 million people keep what is called a "life list" of birds they have seen. In the USA, some 50 million people lay claim to being bird-watchers or 'birders,' spending billions of dollars on birding-related travel and membership fees every year. A few compete in one of the world's quirkiest contests — the race to spot the most species in North America in a single year. And 1998 wasn't just a big year. It was to become the greatest birding year of all time.

Quote

"Every year on January 1, a quirky crowd of adventurers storms out across North America for a spectacularly competitive event called a Big Year — a grand, grueling, expensive, and occasionally vicious, "extreme" 365-day marathon of birdwatching.

For three men in particular, 1998 would be a whirlwind, a winner-takes-nothing battle for a new North American birding record. In frenetic pilgrimages for once-in-a-lifetime rarities that can make or break their lead, the birders race each other from Del Rio, Texas, in search of the rufous-capped warbler, to Gibsons, British Columbia, on a quest for Xantus's hummingbird, to Cape May, New Jersey, seeking the offshore great skua. Bouncing from coast to coast on their potholed road to glory, they brave broiling deserts, roiling oceans, bug-infested swamps, a charge by a disgruntled mountain lion, and some of the lumpiest motel mattresses known to man. "

Conversation: 'The Big Year'
(with streaming video interview)



See all Topics

Thursday, December 17, 2015

Animate Window Size

So cool!


The following macro has little or no practical computing value, but it can add a "way cool" element when a worksheet is unhidden.
There are three states that a worksheet can be in; Minimized, Maximized, and Normal.

This macro will gradually resize a worksheet from small to Maximized. The worksheet appears to be growing:

Sub SheetGrow()
Dim x As Integer
With ActiveWindow
.WindowState = xlNormal
.Top = 1
.Left = 1
.Height = 50
.Width = 50

For x = 50 To Application.UsableHeight
.Height = x
Next x

For x = 50 To Application.UsableWidth
.Width = x
Next x

.WindowState = xlMaximized
End With
End Sub


From AutomateExcel.com:
ActiveWindow.WindowState
(By Mark William Wielgus)




Also fun:

Sub SheetGrow()

Dim x As Integer, xmax As Integer

With ActiveWindow

.WindowState = xlNormal

.Top = 1

.Left = 1

.Height = 50

.Width = 50



If Application.UsableHeight > Application.UsableWidth Then

xmax = Application.UsableHeight

Else

xmax = Application.UsableWidth

End If

For x = 50 To xmax

If x <= Application.UsableHeight Then .Height = x

If x <= Application.UsableWidth Then .Width = x

Next x

.WindowState = xlMaximized

End With

End Sub



# posted by Joerd



See all Topics

Wednesday, December 16, 2015

Hot Spot in Your Pocket

Or at least nearby


It'll cost about $1,000, but think about the bragging rights!

"I love the fact that more and more devices are sporting built-in Wi-Fi. The lone hitch: Wi-Fi is useless without a hotspot.

What if you could marry the short-range power of Wi-Fi with the huge coverage areas of high-speed cellular services such as EV-DO to create a portable hotspot?
Since EV-DO works at freeway speeds, you could even give Internet access to an entire road-trip caravan.

Now I can surf for as long as three hours without being tethered to anything but a cell signal. The project isn't cheap, but prices for the components and service are sure to come down in the next year or so. In the meantime, you can find me in the hills around Southern California. I'll be the one surrounded by PSP-packing hikers."





Popular Science:
Be Your Own Hotspot
By Mike Outmesguine



See all Topics

Tuesday, December 15, 2015

Animate Chart

Make data more moving


Wipe away the drool that develops when looking at Office 2007 formatting and deal with what we've got.

When you try to animate the chart be aware that not all of the animations work. "Fly in" does not work. "Box" does.

"You can add some animation to your chart for dramatic effect. You can animate the chart as a whole or animate elements of the chart."

  1. In normal view, display the slide that has the chart you want, and then select the chart.

  2. On the Slide Show menu, click Custom Animation to open the Custom Animation task pane.

  3. In the Custom Animation task pane, click the Add Effect down arrow, point to Entrance, and then click an effect.

  4. In the Custom Animation task pane, select the animation you applied to the chart, click the down arrow, and then click Effect Options.

  5. On the Chart Animation tab, in the Group Chart list, click By element in series.

  6. Click OK.

  7. Now, if you click Slide Show and click through the presentation, you’ll see the animation in real time.
Office.Microsoft.com:
Present sales reports in PowerPoint

Also see:
Ungroup and Animate

Ellen Finkelstein:
Animate Tables



See all Topics

Monday, December 14, 2015

Parameter Queries Deux

Another look at parameters

The ability to use dynamic criteria in a Query makes Access even more valuable.

Access Parameter Query Tutorial video that walks the viewer gently through the process.


(Parameter queries are also referenced here:
Parameter v. Form)

How to create a parameter query

Using Parameter Queries



See all Topics

Sunday, December 13, 2015

Yeah, Sure, That's My Email

A lie will set you free


Dodgeit.com allows you to create throwaway email addresses. It then delivers the email that comes into the resulting mailbox as an RSS feed that you and everyone else who can guess at your throwaway email address can read.

Pick a throwaway address, say: NotMyAddress@dodgeit.com Give that address out to inconsequential sites.

Check NotMyAddress from homepage of Dodgeit.com.

Subscribe to an RSS feed to keep an eye on the mailbox.

Also see:
Protect Your Address



See all Topics

Saturday, December 12, 2015

Justify Clean Up

Minimize white space


When a document is formatted with columns, the text is often Justified. This can lead to a messy layout of words and letters.
"When justifying text in Microsoft Word use the hyphenation feature to improve the look of your page. (Without hyphens). . . unnecessary 'white space' is distributed throughout. When hyphenation is turned on the overall typographic color of the page is much more even. To enable this feature in Microsoft Word do the following: After you have justified the columns in your document, choose from the "Tools menu" > Language > then from the dropdown menu, choose "Hyphenation", then choose "Automatically hyphenate document"





FontBlog:
Typography Tip #2


BTW, this goes along with one space after punctuation.
Bill Hill - There is only one space after a period



See all Topics

Friday, December 11, 2015

Hide Digets

Simple obfuscation


The kid said,
"Daddy, I know the secret password!
It's star, star, star, star!"
****
You can use functions to hide parts of sensitive data.

Social Security Number 555-55-5555

=CONCATENATE("***-**-", RIGHT(B2,4))

Combines the last four digits of the SSN with the "***-**-" text string

(***-**-5555)



Credit Card Number 5555-5555-5555-5555

=CONCATENATE(REPT("****-",3), RIGHT(B3,4))

Repeats the "****-" text string three times and combines the result with the last four digits of the credit card number

(****-****-****-5555)

Microsoft Office Online:
Display only the last four digits of identification numbers



See all Topics

Thursday, December 10, 2015

Form Design

Fancy functionals


Here is a discussion about how to design a form for use on the web.

"Computers are supposed to make our lives easier, not more difficult. As usability-conscious designers, we can make our users' lives easier by thinking about the way people interact with our websites, providing clear direction, and then putting the burden of sorting out the details in the hands of the computers—not the users.

It's that last part that we're going to focus on here. We've all heard and read about big usability mistakes time and time again: "Don't use images or flash for navigation," "Don't use Javascript for links," and I certainly hope we're all applying those lessons in our work. It's often the smallest usability quirks, however, that create the biggest annoyances for users, especially when it comes to HTML forms. Follow these guidelines, and you'll be off to a good start."

  • Use the right field for the task
  • Give them room to type
  • Shorten your forms and question "mandatory" fields
  • Mark mandatory fields clearly
  • Provide descriptive labels for all of your fields
  • Let the computer, not the user, handle information formatting
  • Use informative error messages
  • Don't return users to an altered form
Sensible Forms
Brian Crescimanno



See all Topics

Wednesday, December 09, 2015

Stars on Your Desktop

Space image wallpaper


NASA is wandering around space snapping photos with an advanced form of a Brownie SureShot.

Here is a collection of interstellar portraits and space art the can be used as wallpaper to be viewed as you warp thought the Internet.



Veil nebula

SpaceWallpapers.net



See all Topics

Tuesday, December 08, 2015

Troubleshoot PowerPoint

Live on tape


On occasion, Microsoft presents Webcasts on interesting subjects.


  • Unfortunately they are usually offered at inconvenient times for people with real jobs.

  • Fortunately they are offered in a form that you can download or watch "on-demand".
Here's one on how to find and fix problems with PowerPoint presentations.
"This Support WebCast will define troubleshooting issues in Microsoft PowerPoint and provide an overview of when and how to use available resources such as product Help and Microsoft Knowledge Base articles. We will also discuss how to determine where a problem is occurring and how to troubleshoot specific issues such as printing, opening a file, installation, movies, and starting the program."
Troubleshooting fundamentals i n Microsoft PowerPoint

Here is a list of available downloadable webcasts

On-demand Webcasts



See all Topics

Monday, December 07, 2015

Where in the World is

Your spy dollars at work


The World Factbook

The World Factbook provides a 'snapshot' of the world.

The online Factbook is updated regularly - generally weekly - throughout the year.

A 46 Meg zipped version is also available.


The World Factbook is in the public domain and may be used freely by anyone at anytime without seeking permission. However, US Code prohibits use of the CIA seal in a manner which implies that the CIA approved, endorsed, or authorized such use."


When you find yourself worrying about the local car wash spilling drainage into the storm sewer, look at some of these environmental concerns:

Azerbaijan
Local scientists consider the Abseron Yasaqligi (Apsheron Peninsula) (including Baku and Sumqayit) and the Caspian Sea to be the ecologically most devastated area in the world because of severe air, soil, and water pollution; soil pollution results from oil spills, from the use of DDT as a pesticide, and from toxic defoliants used in the production of cotton


www.CIA.gov



See all Topics

Sunday, December 06, 2015

Access on Line

Free Basic Instruction


Microsoft has developed a very good collection of tutorials and samples for Office applications. They're located at Office.Microsoft.com

Even if you haven't upgraded to, these suggestions will work with most earlier versions.

For Access look at:
Access

If you have avoided Access in the past, a least glance at "Getting started with Access and Database applications"
Also:

AccessTraining Modules

These are 30 to 55 minute demonstrations.


"When you click Practice in Access at the bottom of this page, a practice database will download to your computer and open in Access, and a separate window with practice instructions will appear alongside."





See all Topics

Saturday, December 05, 2015

Protect Your Address

Keep the bots at bay


"Spam is an incredible problem and it is getting worse - your e-mail address is a commodity and if you put it on a web page, it WILL eventually be found, spammed and sold to other spammers. The problem is that you have a web page and you need to make it possible for people to send you e-mail from your page but you don't want to get bombarded with spam - what can you do?

First you need to understand what is likely to happen. The most likely scenario is that an e-mail harvesting robot will find your page and look though it trying to find e-mail addresses. This robot may be programmed to look for a particular list of possible characters on either side of the @ in your e-mail address or it may look for the "mailto:" in your e-mail link or any number of other tricks."


MailMe
PHP Form Mailer With Spam Blocking


<script language="JavaScript">
<!-- Begin user = "myaddress"; domain = "mydomain"; document.write('<a href="\">');
document.write(user + '@' + domain + '</a>');
// End -->
</script>
<noscript>
Here goes some text that can be seen if Javascript is disabled.
</noscript>

Also:

Software Listing: Mailto
Mailcrawlers and protectors



See all Topics

Friday, December 04, 2015

Score Templates

Free business advice


SCORE is a nonprofit organization providing small business advice and training.

SCORE's 10,500 volunteers have more than 600 business skills. Volunteers share their wisdom and lessons learned in business. Our volunteers are working/retired business owners, executives and corporate leaders.
  • SCORE offers Ask SCORE email advice online.
  • Face-to-face small business counseling at 389 chapter offices.
  • Low-cost workshops at 389 chapter offices nationwide.
  • "How to" articles and business templates
Here are some of the available templates:
A Business Plan for a Start-up Business
Microsoft Word
A Business Plan for an Established Business
Microsoft Word
Bank Loan Request for Small Business
Microsoft Word
Break-Even Analysis
Excel
Competitive Analysis
Microsoft Word
Financial History & Ratios
Excel
Loan Amortization Schedule
Excel
Opening Day Balance Sheet
Excel
Personal Financial Statement
Excel

Projected Balance Sheet
Excel
Start-up Expenses
Excel
4-Year Profit Projection
Excel
12-Month Cash Flow Statement
Excel
12-Month Profit and Loss Projection
Excel
12-Month Sales Forecast
Excel

SCORE Template Gallery



See all Topics

Thursday, December 03, 2015

RSS with Your Web Site

Roll your own

If you like the idea of building your own RSS feed, read on.

"Learn about RSS and how to programmatically create an RSS file for your FrontPage 2003 Web site. The download that accompanies this article contains a VBA project and an XSLT file that you can use to generate and display RSS feeds.

If you spend any time on the Internet, you have probably heard of RSS, and you may decide that you need an RSS feed for your Web site. An RSS feed is an Extensible Markup Language (XML) file that people can use to keep up to date with the content on a Web site. RSS feeds are frequently associated with weblogs (blogs), but you can use them for any Web site.

If you have a Web site that contains content that you frequently update, such as articles or stories, you may want an RSS feed to help your customers keep up with your updates. This article explains the XML behind RSS and provides a Microsoft Office FrontPage 2003 Visual Basic for Applications (VBA) project that you can use to programmatically generate an RSS feed for your FrontPage Web site. The download for this article includes an Extensible Stylesheet Language Transformation (XSLT) file that you can use to display the RSS XML file in a browser."

Microsoft Developers Network:
Creating an RSS Feed for Your Web Site



See all Topics

Wednesday, December 02, 2015

Glossary

What does it all mean

We live in a world based on jargon and acronyms. For a little relief, try this site.

Microsoft Office, Microsoft Windows, and Microsoft Windows Mobile-based devices are covered and more.
  • Security Glossaries
  • Multimedia Glossaries
  • Partner and Business Glossaries
  • Technical Glossaries
  • Non-English Language Glossaries
Microsoft Glossary Information Center



See all Topics

Tuesday, December 01, 2015

If We're in Trouble

It's Probably Because People No Longer Really Listen


Yes, now we can add Iraq to the evils perpetuated by PowerPoint.



"Not only is it easier to throw together a stack of PowerPoint slides than it is to write that 10,000-word document, it is much easier to leave out or gloss over parts of the project that might not survive close scrutiny if they were described in complete sentences. Can you say "weapons of mass destruction?" If we cut to the heart of this current controversy about whether Iraq really had WMD, whether the U.S. honestly believed Iraq had WMD, and who got it wrong, I'm sure we'll end up with a guilty PowerPoint stack. In that stack, you'll find a slide containing the words "Iraq" and "WMD" but taken out of context, there is no way of knowing what the presenter even intended the slide to mean. Thus, we have plausible deniability through PowerPoint."



For eight years from 1987-95, Robert X. Cringely wrote the Notes From the Field column in InfoWorld, a weekly computer trade newspaper. He is also the author of the best-selling book Accidental Empires: How the Boys of Silicon Valley Make Their Millions, Battle Foreign Competition, and Still Can't Get a Date.
Most recently, Cringely is the host and writer of the hit PBS-TV miniseries "Electric Money."


If We're in Trouble

Robert X. Cringely 
(http://www.cringely.com)



See all Topics

Monday, November 30, 2015

Dictionary means - never having to say huh?

Google dictionary


"To see a definition for a word or phrase, simply type the word "define," then a space, and then the word(s) you want defined. If Google has seen a definition for the word or phrase on the Web, it will retrieve that information and display it at the top of your search results.

You can also get a list of definitions by including the special operator "define:" with no space between it and the term you want defined. For example, the search [define:World Wide Web] will show you a list of definitions for "World Wide Web" gathered from various online sources."

Also check out http://wordweb.info/



"WordWeb Pro is a quick and powerful international English thesaurus and dictionary for Windows. It can be used to lookup words from almost any Windows program, showing definitions, synonyms and related words. There are also many proper nouns and usage examples. You can search for words matching a pattern, find and solve anagrams, and optionally search a large number of extra word lists."




See all Topics

Sunday, November 29, 2015

Data Modeling

Data bits and pieces

While a few of us may be guilty of constructing databases on the run, and then trying to clean up the mess later, the wise ones plan ahead.

What information will you need in the future? What reports are going to be requested? If you're the bean counter, do you need to count all the legumes?


"Data modeling is probably the most labor intensive and time consuming part of the development process. Why bother especially if you are pressed for time? A common response by practitioners who write on the subject is that you should no more build a database without a model than you should build a house without blueprints.

The goal of the data model is to make sure that the all data objects required by the database are completely and accurately represented. Because the data model uses easily understood notations and natural language, it can be reviewed and verified as correct by the end-users.

The data model is also detailed enough to be used by the database developers to use as a "blueprint" for building the physical database. The information contained in the data model will be used to define the relational tables, primary and foreign keys, stored procedures, and triggers. A poorly designed database will require more time in the long-term. Without careful planning you may create a database that omits data required to create critical reports, produces results that are incorrect or inconsistent, and is unable to accommodate changes in the user's requirements."


AgileData.org:
Data Modeling 101



See all Topics

Saturday, November 28, 2015

Digitally Sign

Messages

If you have a need to protect the contents of your email messages, these links should point you in the right direction.


Outlook supports the following features for cryptographic messaging:
Digitally sign an e-mail message. Digital signing provides nonrepudiation and verification of contents (the message contains what the person sent, with no changes).

Encrypt an e-mail message. Encryption helps to ensure privacy by making the message unreadable to anyone other than the intended recipient.

There are additional features that can be configured for Outlook 2003 for security-enhanced messaging, if your organization chooses to provide support for them, including:

Sending an e-mail message with an S/MIME receipt request. This helps to verify that the recipient is validating your digital signature (the certificate you applied to a message).

Adding a security label to an e-mail message. Your organization can create a customized S/MIME V3 security policy which can add labels to messages. An S/MIME V3 security policy is code that you add to Outlook that runs automatically to add information to the message header about the sensitivity of the message content. For example, an Internal Use Only label might be applied to mail that should not be sent or forwarded outside of your company.



Overview of Cryptography


Free digital ids

Slipstick.com:
Encryption and Message Security Tools

TheTechGap.com:
Digital IDs in Outlook

Adobe:
Digital IDs



See all Topics

Friday, November 27, 2015

Page Numbers

A baker's dozen of ideas


Here is a collection of tips about how to display information in Headers and Footers.

Field codes are demonstrated. Remember that the brackets {} must be inserted with Ctrl+F9, not directly from the key board.

Here's one suggestion:

Display the word "more" at the bottom of every page except the last page.

Insert an "if" field into the footer.

The field in this case will be a compound entity that consists of two fields nested within a third field.

{ IF { PAGE } = { NUMPAGES } "" "more" }
  1. Position cursor where you want the field.
  2. Press Ctrl+F9 to insert the field braces.
  3. Type the field expression as it appears below, using Ctrl+F9 and arrow keys as needed to keep text within the various braces as you type.
    { IF { PAGE } = { NUMPAGES } "" "more" }
  4. Select the entire expression.
  5. Right-click the selection and choose Toggle Field Codes.
    (or use Alt+F9)
Headers and footers and page numbers



See all Topics

Thursday, November 26, 2015

Dynamic AutoShape Link

Show the star

Here's a hint that I had forgotten about.

You can tie the result of a cell to an AutoShape.

This displays the value in a more dramatic manner.
  1. Create an AutoShape on the Worksheet
  2. With the shape selected, type an equal sign in the formula bar.
  3. Enter the address of the linking cell (or click the cell)
  4. Hit Enter


Thanks to AutomateExcel.com for the reminder.



See all Topics

Wednesday, November 25, 2015

Photo Gallery

A CSS exercise


FrontPage had a Photo gallery template, and you can also save a PowerPoint show as a web page.

For another take on the problem, here are the instructions needed to create a gallery using CSS.

Click here to see what it might look like:



How to Create a Photographic Gallery Using CSS
By Stu Nicholls



See all Topics

Tuesday, November 24, 2015

Zapf Your Own Dingbat

Private Character Editor


Windows has its own, hidden, character creator, called the Private Character Creator .


Using Private Character Editor (PCE), you can create up to 6,400 unique characters (such as special letters and logos) for use in your font library. PCE contains basic tools for creating and editing characters, along with more advanced options.

If you want to create a new private character using an existing character as your model, you can copy the existing character to the Edit grid and then modify it to suit your needs, or you can display the existing character in a Reference window alongside your Edit grid for use as a visual reference. You can use any character from any font that is installed on your computer.


The Private Character Editor is accessed at Start>Run and enter "Eudcedit" without the quotes.
After you have constructed and saved the design of your choosing, you can access it from the Character Map by selecting Start>Run "Charmap".

Drop the Font selection list down and choose All Fonts (Private Characters), then click on the character you have created, copying and pasting it into any document.

Hermann Zapf designed some of the 20th century's most important fonts, including Palatino and Optima. He also produced a collection of decorative symbols called "dingbats", modeled after the accidental lead drippings collected by old style typesetters.

Also:
Private Character Editor — Eudcedit
By Vic Laurie

Keyboard Utilities for Windows
Alan Woods



See all Topics

Monday, November 23, 2015

Can We Serve Multiple Masters?

Dual Masters and more schemes


Earlier versions of PowerPoint were restricted to only one master design scheme per show. We strained to get around that by linking shows and pasting backgrounds over the designs.

PowerPoint 2002+ changed that by allowing more than one design scheme.

A PowerPoint master with the first name of "Echo", runs a nice tutorial site named EchosVoice.com.

She has written a step-by-step tutorial to create Multiple Masters for PPT 2002 and beyond.

Makes you want to dance. (Echo's own image)
Echo Dancer



See all Topics

Sunday, November 22, 2015

Rewind DVDs

Speed the process


Sometimes one finds a solution to a problem that is not seeking an answer.

"Guaranteed Lowest Price on the Internet for DVD Rewinding
No More Embarrassing Fines or Hassles at your Video Rental Store !!!
No Fuss — No Waiting — Do It Online — Do It Now!
Rewind your DVDs


Digital Velocity



DVD Rewinder



See all Topics

Saturday, November 21, 2015

Other Right Clicks

A couple overlooked


Right-clicking on objects, such as Tables, Reports or Queries, gives you the opportunity to print, copy, and work with them.

There are other options revealed by right-clicking on the Database window itself.
Right-click on the empty white space of the Database window can lead to Relationships.



If you right-click on the edge of the window, you'll find a link to Access database properties, startup activity for the current database, or open a new database.

Right-clicking on the Database window also lets you configure the items in the Groups bar.



See all Topics

Thursday, November 19, 2015

Automate Word Tables

VBA examples and instructions


The Microsoft Developer's Network has a pretty comprehensive article on programmatically working with data and Word tables.

"You can look at the world as split into applications that store data (databases) and applications that present information, such as Microsoft Office Word 2003 and Microsoft Office PowerPoint 2003. Increasingly, the end user demands to display database content in documents and presentations.

While Word does provide some tools for displaying tables from databases in its documents, these are somewhat rudimentary, they require a basic understanding of how the database is built, and using them involves a number of steps. In addition, there may also be security and access issues involved, requiring additional layers of protection.

The developer is therefore increasingly confronted with the task of transferring data into Word, whether in the form of tables, or as part of the document text. This article considers some of the major aspects of using the Word object model to work with tables."


  • Introduction to Automating Tables
  • Creating Tables Programmatically in Word
  • Populating Word Tables with Data
  • Adding Linking in Word Tables Programmatically
  • Extracting Data from Word Tables Programmatically
A downloadable document is also available for those of us still addicted to paper. Automating Word Tables for Data Insertion and Extraction.



See all Topics

Wednesday, November 18, 2015

Internet 099

Basics and Beyond


A San Francisco company called Learn the Net has produced a basic on-line tutorial about the Internet.

If you need a fundamental primer, this might be a place to look.

It is not a series of scaled down "baby talk" lessons. You can drill down though the meaning of 403/404 error codes and links to WW3 Generic URI Syntax (RFC 2396) standards.

That is if you know how to drill down.

"Throughout Learn the Net--in fact on most web pages--you will see words that are in color and often underlined. By clicking on these words, known as hypertext, you jump to other places on the page, to other pages on the site, or to other resources on the Internet."


www.LearntheNet.com



See all Topics

Tuesday, November 17, 2015

Don't Display

Logon, Logoff, Startup and Shutdown Status Messages


To turn these off:

Start Regedit
Go to

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\policies\system
If it is not already there, create a DWORD value named DisableStatusMessages

Give it a value of 1

To turn on:

Locate and then click the following registry key:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Policies\System
On the Edit menu, point to New, and then click DWORD Value.

Type verbosestatus, and then press ENTER.

Double-click the new key that you created, type 1 in the Value data box, and then click OK.

Quit Registry Editor.

NOTE: Windows does not display status messages if the following key is present and the value is set to 1:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Policies\System\DisableStatusMessages

Verbose Status Messages



See all Topics

Monday, November 16, 2015

Kürzungen für jeder

Accessibility Shortcuts


Several resources are available to help increase speed and effectiveness for keyboard users. Here are keyboard shortcuts for leading Microsoft products that help save time and effort and provide an essential tool for some people with mobility impairments.

  • Internet Explorer (11/10/9/8/7/6)
  • Office (2013/2010/2007/2003)
  • PowerPoint
  • Publisher
  • Windows (8/7/Vista/2003/XP/2000)
  • Windows Media Player
Microsoft.com Keyboard Assistance.



See all Topics

Sunday, November 15, 2015

Free Excel Templates

Financial enlightenment


Matt H. Evans CPA. CMA, CFM has complied a list of 117 free Excel spreadsheets devoted to financial matters.

Here are a few of the entries:
Time Value (xls)
Introduction to time value concepts, such as present value, internal rate of return, etc.
Lease or Buy a Car (xls)
Basic spreadsheet for deciding to buy or lease a car.
Top Five NPV & IRR (xls
Explains Internal Rate of Return, compares projects, etc.
Statements (xls)
Generate a set of financial statements using two input sheets - operational data and financial data.
Business Financial Analysis Template
for start-up businesses from Small Business Technology Center
Income Statement
What If Analysis
Assessment Templates
Set of templates for assessing an organization based on the Malcolm Baldrige Quality Model.


ExInfrm.com



See all Topics

Saturday, November 14, 2015

Sort Forms

Create a sorting function

Here is one way to provide your users with a means to reorder fields in forms.

"Chris Weber develops a solution that allows users to sort the data in their forms (or subforms) that you can add to your application easily.

  • The sorting interface should be generic to any form in any database.

  • It should also work with subforms.

  • It needs to be implemented as expediently as possible to fulfill the bid, and be easily maintained in the future.

  • It should be intuitive or reminiscent of other interfaces in Access and Windows.
Let Your Users Sort it Out



Scroll down to the bottom of the page. There is a file that can be downloaded with the code.



See all Topics

Friday, November 13, 2015

More Tips on Presentations

From another point of view


"Holding the honorary title of "Microsoft Regional Director" for Chennai over the last 6 years, I have delivered hundreds of presentations and lectures. Doing this, I have learned that doing successful presentations is an Art, which can be acquired only over time and by practice."

Venkatarangan, Chennai, India


There are 3 basic ways to learn this art:
  1. Listen to great speakers: Attend as many programs of great speakers as possible. Subject spoken is immaterial here, what you are learning is the "Master's" way of doing it.

  2. Read about doing presentations: There are now plenty of books on doing effective presentations and Internet has numerous pages on this. Read them.

  3. Keep Doing it: Get on stage as many times as you can and just do it. As they say, your mistakes teach you more than anyone. So as you keep doing more and more presentations, you will learn on your mistakes and improve.
Also:
  • General Tips:
  • Health/Life Style Tips:
  • Doing Technical Presentations:
  • Authoring Power Point Slide-Decks:
  • Laptops, Audio-Video & Systems:
  • Sharing the stage:
  • Answering Questions — Q & A:
Venkatarangan's Blog



See all Topics

Thursday, November 12, 2015

Mail Merge Page Printing

One big page


After completing a merge to a new document, the status bar may indicate that the insertion point is located on page 1 of 38 pages. This is a bit of mis-information.

If you turn on Show/Hide and look at the merged document in Normal view, you'll see that the merged document has section breaks rather than page breaks.

If you try to print what should be Page 1, the entire document will print.

To print just the first section, use "s1" in the Print dialog box.



Another way to handle it is to go to Edit>Replace and replace

"^b" (section break)

With

"^m" (manual page break)



From Office.Microsoft.com:
In the Pages box, type instructions to print one of the following:

Noncontiguous pages

Type the page numbers with commas between them. Type the range of pages with a hyphen between the starting and ending numbers in the range. For example, to print pages 2, 4, 5, 6, and 8, type 2,4-6,8
A range of pages within a section

Type p page number s section number. For example, to print pages 5 through 7 in section 3, type p5s3-p7s3
An entire section

Type s section number. For example, type s3
Noncontiguous sections

Type the section numbers with commas between them. For example, type s3,s5
A range of pages across sections

Type a range of page numbers and the sections that contain them with a hyphen between the starting and ending numbers in the range. For example, type p2s2-p3s5




See all Topics

Wednesday, November 11, 2015

Graphics from the '50s

Remember it the way you want to


Original fifties clipart? Just in time for the holidays, some Ozzie and Harriet style pics.



"Most communities in the fifties had small town print shops that doubled as printers of local news and advertising papers. These printers could not afford graphic artists so they used stock clipart supplied by large companies who distributed common graphics for use in advertising sections of the papers. They were provided for the printer in lots of categories to meet any advertiser's needs."

Retrographix.com



See all Topics

Tuesday, November 10, 2015

EMail Substitute Icons

Foil the spoilers


If you include an email address it can be read be the evil robot of the web.
Nexodyne.com will create a free email icon graphic to be used in place of a mail hyperlink.



You could also use this piece of Javascript to avoid R2D2.

(user in this case would be "MyJunkMail.Place"
mydomain would be "Gmail.com")


<script language="JavaScript">
<!-- Begin
user = "myaddress";
domain = "mydomain";
document.write('<a href=\"mai' + 'lto:' + user + '@' + domain + '\">');
document.write(user + '@' + domain + '</a>');
// End -->
</script>
<noscript>
Here goes some text that can be seen if Javascript is disabled.
</noscript>


(from SB Projects.com)



See all Topics

Monday, November 09, 2015

Better PowerPoint Presentations

More suggestions


There are never enough tips for successfully communicating information.

Michael Hyatt has these guidelines:

I like the first rule. The purpose of the meeting is to communicate information, not to demonstrate your prowess with a piece of software.

Rule #1:
Don't give PowerPoint center stage.
Rule #2:
Create a logical flow to your presentation.
Rule #3:
Make your presentation readable.
Rule #4:
Remember, less is more.
Rule #5:
Distribute a handout.


Michael Hyatt is the President and Chief Operating Officer of Thomas Nelson Publishers, the largest Christian publishing company in the world and the ninth largest publishing company of any kind.

Five Rules for Better PowerPoint Presentations



See all Topics

Sunday, November 08, 2015

Java and All That Jazz

Free code


One way to jazz up a boring web site is to use scripting to present random images or create interesting menus. You could learn to do it yourself, or borrow from the stars.

JavaScript-2.com is a source for free JavaScript Codes.

Find FREE JavaScript codes quickly and easily with the only search engine that searches all the top Java Script libraries, offering a total of over 8,000 free JavaScripts.



See all Topics

Saturday, November 07, 2015

Sudoku

CrossNumber puzzles


I have to admit that I have not caught the fever that these puzzles seem to have generated.

Most every newspaper in the world has started publishing these brain teasers.


"Sudoku , sometimes spelled Su Doku, is a logic based placement puzzle, also known as Number Place in the United States. The aim of the canonical puzzle is to enter a numerical digit from 1 through 9 in each cell of a 9x9 grid made up of 3x3 subgrids (called "regions"), starting with various digits given in some cells (the "givens"). Each row, column, and region must contain only one instance of each numeral.
Completing the puzzle requires patience and logical ability. Its grid layout is reminiscent of other newspaper puzzles like crosswords and chess problems.
Although first published in 1979, Sudoku initially became popular in Japan in 1986 and attained international popularity in 2005."


Wikipedia — Sudoku

Here is a download that will construct as many of these puzzles as you might be Jonesing for.

Andy Pope Su Doku


Also:

Web Su Doku



See all Topics

Friday, November 06, 2015

Dvorak Anyone?

Alternative Keyboard Layouts

"Free keyboard layouts - called Dvorak layouts - are available for people who type with one hand or finger. These layouts make the most frequently typed characters on a keyboard more accessible to people who have difficulty using the standard keyboard layout (called the "QWERTY" layout).

Dvorak keyboard layouts reduce the amount of motion required to type common English text. Use of these layouts may also help avoid some types of repetitive strain injuries associated with typing.

Studies have also shown an increase in typing speed and accuracy when using the Dvorak layout for two hands. The left-hand or right-hand keyboard layouts can also be useful for people who type with a wand."


You do not need to modify your hardware keyboard to use these layouts, but you will need to change your keyboard settings to use the Dvorak layouts.

(A keyboard layout is a map or a definition of how keys are laid out on your keyboard. The keyboard layout you use is determined by software in your computer. The letters on your keys indicate the standard layout for your keyboard.)

Tutorials and downloads


Dvorak layouts

Introducing the Dvorak Keyboard
By Marcus Brooks

A Brief Primer
by Randy Cassingham



See all Topics

Thursday, November 05, 2015

Merge Pictures

Different picture to every letter in a mail merge



A variation of this technique could also be used with an IF statement to display different pictures based on some criteria, such as Zip code.
  1. Open the Excel worksheet that you use as the mail merge data source.

  2. Insert a new column that has a column heading such as Picture.

  3. For each row of the Excel worksheet, insert in the Picture column the path and the file name of the picture that you want to use for that record of the data source. Additionally, enclose the path and the file name in quotation marks (").

    For example, copy the path and the file name of the picture in Windows Explorer. Then, paste the path and file name into the Excel worksheet.

    Note The path and the file name of each picture in the Picture column will appear similar to the following example:


    "C:\Documents and Settings\username\My Documents\My Pictures\foldername\filename.jpg"

  4. On the Edit menu, click Replace. Then, replace each instance of a single slash mark (\) with double slash marks (\\) in each path.

    For example, each path should now look similar to the following example:

    "C:\\Documents and Settings\\username\\My Documents\\My Pictures\\foldername\\filename.jpg"

  5. Save and then close the Excel worksheet. Then, quit Excel.
In Word, follow these steps:
  1. Open the mail merge main document.

  2. If the Excel data source is not attached, attach the data source. To do this, go to Step 3 of 6 in the Mail Merge task pane. Click Browse, and then attach the Excel data source.

  3. Click Next: Write your letter.

  4. In the mail merge main document, move the insertion point to the location where you want the picture to appear.

  5. On the Insert menu, click Field.

  6. In the Field dialog box, click IncludePicture under Field names, and then click OK.

    Note You may receive the following error message:

    Error! Filename not specified

  7. Press ALT+F9 to display the field codes in the mail merge main document. You will see a field that is similar to the following field:

    { INCLUDEPICTURE \* MERGEFORMAT }

  8. Move the insertion point into the field immediately following INCLUDEPICTURE.

  9. Press the SPACEBAR, and then click More items on the Mail Merge task pane.

  10. In the Insert Merge Field dialog box, click the picture merge field, such as Picture, and then click Insert.

  11. Click Close to close the Insert Merge Field dialog box.

    The INCLUDEPICTURE field should now look similar to the following field:

    { INCLUDEPICTURE { MERGEFIELD "Picture" } \* MERGEFORMAT }

  12. Press ALT+F9 to hide the field codes in the mail merge main


  13. Click Next: Preview your letters.


  14. Click Next: Complete the merge.

  15. In the Mail Merge task pane, click Edit individual letters.

  16. In the Merge to New Document dialog box, click OK.

  17. On the Edit menu in the merged document, click Select All.

  18. Press F9 to update the fields in the merged document.
    (Word mail merges are not dynamic)

  19. To print your letters from the merged document, click Print on the File menu. Each printed letter will contain the picture that you specified in the Excel data source.
Knowledgebase #909132:
Different picture to every letter in a mail merge



See all Topics

Wednesday, November 04, 2015

Normalization

Designing an efficient database

Here is an understandable article about how to put together a normalized database.

One topic covered is what should be used for a Primary or foreign key.
"In general, a key field should have these characteristics:

Should be One Field

It is possible to define multiple fields as the key fields of a table, but a single field is preferable. ...Far better to have a CustomerID number than a combination of other fields to define a customer.
Should be Numeric

Access offers an AutoNumber field that is a Long Integer which is ideal for key fields. These values are automatically unique for each record and supports multi-user data entry as well.
Should Not Change Over Time

A key field should not change over time. Once identified, like a social security number, it should never change.
Should be Meaningless
To ensure a key field doesn’t change over time, it should have no meaning and therefore no reason to change over time.


Here are a few of the other topic headings:

Understanding Your Data
  • What Data Do You Need?
  • What Are You Going to Do with the Data?
  • How Is Your Data Related to Each Other?
  • What Is Going to Happen to the Data Over Time?
  • Learn How to Use Queries
Database Normalization Tips By Luke Chung, Founder and CEO of FMS Inc
Also see: Knowledgebase #283878:
Description of the database normalization basics
and:
Normalization Model



See all Topics

Tuesday, November 03, 2015

How to Burn Out Your Audiance

Audience antagonizers


What are the three most annoying things about bad PowerPoint presentations?

"According to the survey, conducted on the CommunicateUsingTechnology.com web site, the most common complaints are:
  • Speakers reading their slides to the audience (71.7% of respondents cited this item),
  • Text on the slides is too small to be readable (47.7%)
  • Visuals too complex (36.9%) and
  • Full sentences were used instead of bullet points (48.6%).
  •  
    This survey is one of the first to investigate how presentations are seen from the audience point of view. Of those respondents who see 100 or more presentations per year, more than half said that 50% or more of the presentations they see suffer from one or more of the annoying traits. The costs of poor presentations are in the time wasted by those who attended and in the extra work that must be done to communicate the intended message again since it was not done properly the first time."
CommunicateUsingTechnology.com:
Annoying PowerPoint Survey



See all Topics

Monday, November 02, 2015

Light Up Where You Live

A nation's porch light


"Ben Fry is a doctoral candidate at the MIT Media Laboratory. His research focuses on methods of visualizing large amounts of data from dynamic information sources. This work is currently directed towards "Genomic Cartography" which is a study into new methods to represent the data found in the human genome."

He has a fascinating demonstration of data display technique:



Zip Code Demonstrator.

Type in a zip code one number at a time to see how zip codes are distributed in the US.



See all Topics

Sunday, November 01, 2015

Spreadsheet Design

Make it work and look good


Timothy Miller uses the nom de screen of "Jethro" (Moses' Father-in-Law).

His SpyJournal.biz site/blog gives some tips on how to present an Excel solution


Design and layout

One of the easiest ways to set up spreadsheets that calculate or generate results that need to be reported is to separate the function from the form. Just like a shiny exterior on a car hides the internal engine and wiring. I always create my reports and front end menus to look good and generate results and calculations in more functional sheets.
Hiding unnecessary sections

If you must have calculations and working sections visible, then hide the unnecessary bits. Hiding a row or column is only one way of doing this. Using the group function you can rollup whole rows of information, e.g. components that add to a subtotal or constants and variables such as exchange rates, interest rates, and other indexes.
Use of colour and graphics

I like to use the company logo or other graphic as a design element in my spreadsheet. Sometimes I do this by using the corporate colours, other times by using the graphic itself. If I have a spreadsheet with a lot of macro buttons, I may use command objects and use the logo as a picture on the button.
Removing excel components

There are a number of excel components that you can turn off. Menu screens and reports screens may not need horizontal or vertical scroll bars, sheet tabs or row and column headings. Using macro buttons to return to a menu can overcome the need for sheet tabs. Not displaying gridlines will give a clean uncluttered look to a layout, and then using borders as necessary can create emphasis in the right areas.

You'll find the complete text here:
Design Presentation Tips

Also see:
The Art of the Spreadsheet



See all Topics

Saturday, October 31, 2015

Almost All You Need to Know

Collection of Word explanations



Shauna Kelly is a Microsoft Word MVP.

She has compiled a gathering of important Word how to's and whys.
For new users of Microsoft Word
Basic concepts - Introduction
Styles in Microsoft Word
Tips for understanding styles
Formatting
How the Styles and Formatting pane works
Numbering, Bullets, Headings, Outlines
How to control bullets
Templates
What is the relationship between a Word document and its template?
Layout
How to keep a figure on the same page as its caption
Sharing Microsoft Word documents
What happens when I send my document to someone else?


Making the most of Word in your business:
Microsoft Word FAQ



See all Topics

Friday, October 30, 2015

Calculator Plus

Add, subtract, convert

Another free prize offered by Microsoft to reward users of legitimate Windows, is a neat calculator.

Besides all of the features of the built in calculator, both basic and scientific, this tool converts measurements and currency.


Microsoft Calculator Plus download.




[Edited entry from 11/9/2005]



See all Topics

Thursday, October 29, 2015

PayPal - Phishing

A tutorial


As part of a series on Identity Protection Resources, PayPal has a section on Spoofing or Phishing.

"Many spoof emails look very real. While there are some telltale signs, it can often be difficult to identify fake emails. Whenever you get an email about your PayPal account, the safest and easiest course of action is to open your browser and log in to your PayPal account directly without clicking any links in the email.

Warning signs that an email about your PayPal account are fake include a generic greeting, a false sense of urgency, and links that don't include:
"https://www.paypal.com" immediately before the first "/".


Spoof Tutorial

[Edited entry from 11/7/2005]



See all Topics

Wednesday, October 28, 2015

John Titor - 2036

The future came back


Why speculate about the future, when we've already been visited by a representative?
"A tale that disturbed me, concerned me, made me wonder if our world as we know it has less than 15 years left.

It is the tale of John Titor, a self-proclaimed time traveler from the year 2036.

Okay, it sounds crazy. It's not crazy, though . . .it's simply a hoax. It's a compelling hoax, so I decided to write my take on it. After some initial 'what if' excitement about it, the reality set in that this wasn't what it appeared to be. In this piece, I hope to prove relatively clearly that his claims are false both in theory and in fact. He seemed to know enough about physics to pass amongst laymen, but unfortunately he skipped philosophy and economics while he was reading all those physics books.

Since this story just won't seem to die and there is evidence that the same perpetrator is now claiming to be an alien on various boards across the web, I felt it was worth sitting down and analyzing."


Tackling John Titor, Time Traveler



Wikipedia:
John Titor

"John Titor was the name of a purported time traveler from the year 2036. He posted on several time travel-related Internet bulletin boards during 2000/2001, making many vague and seemingly falsifiable predictions about events in the near future and giving an explicit, detailed account of his supposed native time period. Whether or not John Titor was a hoax is a topic of controversy on web-based paranormal discussion boards."

John Ttior's Story

"Someone using the assumed name of John Titor and claiming to be a soldier on a mission from 2036 presented a considerable amount of information on the Web beginning around November 2000 about his mission and time travel machine, his perspective on our society, how our society is going wrong, and how society as we know it will end in a very short but massive global nuclear war in 2015. He's gone now, back to 2036 he said he was going in his last posting on March 24, 2001, and the threads he left across the Web in his five months with us have been slowly evaporating since then."



AboveTopSecret.com:
The John Titor Project

"Although many find it easy to dismiss all this as either science fiction or an elaborate extended hoax, there are those who still read his information and agree that there is something very troubling about John Titor and what he had to say."


Answers.com:
John Titor

" He claimed his time machine — a "C204 time displacement" machine-was created by General Electric. Supposedly, he transported it in a standard motor vehicle (a black, model-year 1966 Chevrolet Corvette Convertible shown in the photographs he provided), and the car also served as his vessel whilst traveling through time (it remained stationary throughout with the engine off). He claimed that the public is fully aware of time travel in his time period, although the extreme skeptics of his day do not believe it exists."




See all Topics

Tuesday, October 27, 2015

Graph Data and Shapes

Statistical collection


Betty C Jung has put together a serious collection of tutorials, links, and data sources.

Here are some of the topics:
  • Charting Data
  • Data Presentation
  • Cumulative Frequencies
  • Fishbone Diagram
  • Flowcharts
  • Frequency Distributions
  • Gantt; PERT Charts
  • Graphing With Excel
  • Analyzing and Plotting Data with Excel
  • Organizational Charts/Mapping
  • Social Network Analysis
Graphing & Presenting Data



See all Topics

Monday, October 26, 2015

Send the Viewer on Their Way

Move on


If you have an old site that people still address, or a web page that has been moved, see this code and the explanations.

<html>

<head>
<meta http-equiv="REFRESH" content="3; URL=http://WWW.MiniByteTech.com">
</head>

<body bgcolor="#FFFFFF" text="#000000">


The operative line is:

<meta http-equiv="REFRESH" content="3; URL=http://WWW.MiniByteTech.com">


The value of content is in seconds.
The new location for this web site is WWW.MiniByteTech.com! You will automatically be redirected in 3 seconds. If your browser doesn't automatically load, click <a href="http://WWW.MiniByteTech.com">HERE</a>.

</body>
</html

PCMag.com:
Routing Your Web Site Visitors

Help2Go.com:
Redirecting a Web page

ISiteBuild.com:
How to Redirect a Web Page Using a 301 Redirect

This tools help you determine if the redirect you have created is Search Engine Friendly:

WebConfs.com:
Redirect Checker



See all Topics

Sunday, October 25, 2015

An Obsession with Butterflies

Quote



"Architecture is a plant's first defense. Once a caterpillar begins to eat, compounds in its saliva can be recognized by the leaf as a form of attack. Whang, whang, whang. The entire plant goes on alert. A hormonal burst starts a second defense system, a counter attack that may include rushing newly produced toxins to the damaged leaf, as well as compounds that slow a caterpillar's ability to digest the plant as food."


About the Author

Sharman Apt Russell teaches writing at Western New Mexico University. She is also the author of Anatomy of a Rose, Kill the Cowboy and Songs of the Fluteplayer.
She has a unique voice. Inherently complex topics are made enjoyable.

Book Description

From the beastly horned caterpillar, whose blood helps it count time, to the peacock butterfly, with wings that hiss like a snake, Russell traces the butterflies through their life cycles, exploring the creatures' own obsessions with eating, mating, and migrating. In this way, she reveals the logic behind our endless fascination with butterflies as well as the driving passion of such legendary collectors as the tragic Eleanor Glanville, whose children declared her mad because of her compulsive butterfly collecting, and the brilliant Henry Walter Bates, whose collections from the Amazon in 1858 helped develop his theory of mimicry in nature. Russell also takes us inside some of the world's most prestigious natural history museums, where scientists painstakingly catalogue and categorize new species of Lepidoptera, hoping to shed light on insect genetics and evolution.

>



By Sharman Apt Russell
ISBN 0-7382-0699-7
Perseus Publishing 2003


Also see:
The North American Butterfly Association (NABA)

and,
AmazingButterflies.com:
A Talk with Sharman Apt Russell



See all Topics