Tuesday, September 30, 2014

Links to Excel

Spokes of the web


There's a lot of information out there. The problem is how to find it.
Here is a site that contains links to Excel information arranged in topics:

  • Excel Add-ins

  • Excel Help

  • Excel Password Recovery

  • Excel Templates

  • Excel Tips & Tricks

  • Excel Tutorials

  • Excel VBA

  • Free Excel Add Ins

  • Spreadsheet Research
Excel Links



See all Topics

Monday, September 29, 2014

How Many Die

Hospital scorecard


All right, you need that old appendix ripped out; or maybe a hip replacement.

Where do you go if you have a choice?

Here is a collection of hospital performance nationwide that you may find useful.

It will tell you how many patient deaths there are in any one hospital, as well as how well patients are reimbursed.

DartmouthAtlas



See all Topics

Sunday, September 28, 2014

Access Developers Extentions

No cost tool


"The Access Developer Extensions include the following components:

  • Save As Template
    Enables you to create database templates (ACCDTs) that can be featured in the Access 2007 Getting Started screen.

  • Package Solution Wizard
    A wizard that creates a Windows Installer Package (MSI) to install your database and any supporting files and optionally includes the Access 2007 Runtime, or prompts the user to download the Access 2007 Runtime.


  • Source Code Control
    Integration with Microsoft Visual SourceSafe or other source code control systems to allow check-in/check-out of queries, forms, reports, macros, modules, and data. You can also see the differences that have been made to your checked out objects."
 Developers Extensions



See all Topics

Saturday, September 27, 2014

Find Found Things

Where'd it go?



A Research Project of the Information School
at the University of Washington


Keeping Found Things Found™

"What is KFTF?

The classic problem of information retrieval, simply put, is to help people find the relatively small number of things they are looking for (books, articles, web pages, CDs, etc.) from a very large set of possibilities. This classic problem has been studied in many variations and has been addressed through a rich diversity of information retrieval tools and techniques.

A follow-on problem also exists which has received relatively less study: Once found, how are things organized for re-access and re-use later on? What can be done to avoid the need to repeat the process by which the information was found in the first place? (If, indeed, it is possible to repeat this process.) We refer to this as the problem of Keeping Found Things Found™ or KFTF."




See all Topics

Friday, September 26, 2014

Send Access to Word

Reformat reports


Not everyone has Access installed on his or her machine.
Access is not the most versatile instrument for complex formatting.

If you wish to share your findings, Access does have the ability to re-format Reports into Word documents.

Open the Report in Access and go to Tools>Office Links.
One of the choices is to "Publish It with Microsoft Word."
Here's the command in 2007+:



When the data is sent to Word, you will be asked to confirm that you wish to convert the file to "Rich Text Format (RTF)" Click OK.

(RTF is a "universal" format. The Report can be re-saved as a Word "DOC" or "DOCX" file.)

Microsoft KB:
How to send the current record to Word with automation


Use a table or query as a mail-merge data source (2007+)



See all Topics

Thursday, September 25, 2014

Make Your Calendar Your Own

Match your own schedule


". . . did you know that the views in your calendar are fully customizable? For example, you can view your days and weeks in increments of 5 minutes, 60 minutes, and a variety of periods in between.

You can adjust the view of your calendar according to your work week and work day; for instance, you can display Sunday through Thursday and show a normal day as being 11 in the morning to 7 in the evening if you like.

Use different color schemes, and show more or less detail in your calendar. Watch the demo to see how to do all this and more."


Customize your O'07-10 calendar



See all Topics

Wednesday, September 24, 2014

Guide to CSS

Map through the forest


Dustin Diaz:
"OK. Let's set the record straight. There is no official guide for each and every CSS shorthand property value. So let's work together and put one together shall we?

OK. Straight to the business. Anytime I've ran into a specification (besides the confusing mess at the W3C), it turns into showing off a couple of examples and you're supposed to be set on your way.

Well well. Over the years, I've found quite some interesting unknown quirky facts about these shorthands. . . hence this Guide was born."



CSS Guide



See all Topics

Tuesday, September 23, 2014

Chopsticks 101

No need to starve


Little kids eat with chopsticks, surely you can learn how.

Here's a link to seven easy steps.

Chopsticks in Seven Steps

Also:
How to Eat with Chopsticks


Chopstick Kids



See all Topics

Monday, September 22, 2014

First Look at Word 2007-2013

We all have to start somewhere


Here is a 30 minute course:

After completing this course you will be able to:

  • Create and save a document.
  • Accept or reject suggested revisions for spelling and grammar as you type.
  • Change page margins.
  • Adjust spacing by deleting any extra spaces between words or extra lines between paragraphs.
Create your first document in Word

First look at Word 2010

First Look at Word 2013



See all Topics

Sunday, September 21, 2014

Nickname List

Call me Ishmael


How to Reset the Nickname and Automatic Completion Cache


Microsoft Outlook maintains a nickname list that is used by both the automatic name checking and the automatic completion features. The nickname list is automatically generated as you use Outlook.
If the nickname cache is corrupted, Outlook may not be able to identify recipients, may offer incorrect recipients when automatically completing the e-mail address, or may send the message to the wrong person. You may also, just want to reset the whole list.

  1. Quit Outlook.
  2. Start Windows Explorer.
  3. On the Tools menu, click Folder Options, and then click the View tab.
  4. Under Advanced Settings, click to select the Show hidden files and folders check box.
  5. Click OK.
  6. Click Start, point to Search, and then click For Files or Folders.
  7. In the Search for Files or Folders box, type *.NK2 in the File Name box.
  8. In the Look In box, click to select your local hard disk.
  9. Click Search Now.
  10. Right-click the .NK2 file with the name of the profile that you want to reset, and then click Rename.
  11. Rename the file to yourname.bak, and then press ENTER.
  12. Quit Windows Explorer.
  13. Restart Outlook.
Outlook will generate a new nickname cache:
Knowlegebase Article 287623

Slipstick.com:
Name Resolution



See all Topics

Saturday, September 20, 2014

Zip Code Spy

Who's living in your neighborhood?


ZIPSkinny
displays US Census data for any selected Zip code .

You can find out how old your neighbors are and how much money they make.

Find out how many graduated from high school and how many are single.

Here's part of the information available about someone's vacation home.



ZIPSkinny.com



See all Topics

Friday, September 19, 2014

Update Data to Default

Just a keystroke away


You probably know that you can set up a default value for Access to enter into a field when a new record is created. This can be done in the Design view for a table or form by setting the Default Value property.

Unfortunately, you sometimes may set a default value after you've already entered records into the database. When you do so, the existing records aren't automatically updated to equal the new default.

However, if you're editing a record and you want to update the field to the current default, you can do so with a keystroke shortcut. To do so, simply select the appropriate field and press
[Ctrl][Alt][Spacebar]




See all Topics

Thursday, September 18, 2014

Function Toolbar

F what?



In Word 2007+, you can see the shortcut keys by pressing the ALT key.

Word (2002-2003) has a rarely seen "toolbar" that lets you use your mouse to perform function key actions. In addition, when you press Shift you'll see what the Shift + function key combinations do, press Ctrl and you'll see those shortcuts, and so on.

The toolbar is automatically placed at the bottom of the screen (underneath the document area; right above the status bar); like any toolbar, you can drag it and dock to it any side of the screen, or let it float. To display the Function Key Display toolbar:

  1. Go to Tools>Customize.
  2. Select the Toolbars tab, then check Function Key Display
  3. Click the Close button.
Press the Ctrl, Alt, or Shift keys to see the toolbar buttons (shortcut hints) change. Click on the buttons and the appropriate action will be performed.

See:
Allen Wyatt's Word Tips



See all Topics

Wednesday, September 17, 2014

Blog, Wha's a Blog?

Is it Samuel Pepys or Robert Scoble?





Samuel Pepys:
You can subscribe to an RSS feed of daily entries from Pepys' 1660 diary at The Diary of Samuel Pepys.
A new entry written by Pepys will be published each day; 1 January 1660 was published on 1 January 2003.
Robert Scoble, former Microsoft Evangelizer, former blog:
Scobleizer

How your blog will get discovered

Here are some references to Web Logs

MSDN Magazine:

"Q - What is blogging all about?

A - First, "blog" is short for Web log. It's a medium in which an author writes a journal-style Web site with provisions for readers to respond. These Web logs are becoming quite valuable in the software community for sharing ideas."

All About Blogs and RSS

Wikipedia definition




More on RSS (Really Simple Syndication):
RSS News you choose

Also:
Light and Power



See all Topics

Tuesday, September 16, 2014

Data Tables

Up one side; down another



Data tables are a neat Excel feature that has not been emphasized.

If you are looking at, for instance, a home loan with a number of interest rates and different loan periods, a Data table can lay out the results with a minimum of fluff and formulas.

Dick Kusleika, Microsoft MVP, has a description on his excellent Daily Dose of Excel blog.
Data Table Basics

J K Pieterse:
Excel 2007, 2010, 2013 tables

Microsoft:
How to Use Microsoft Excel Data Tables to Analyze Information in a Database
How to Create and Use One-Input Data Tables in Microsoft Excel
How to Create and Use Two-Input Data Tables in Microsoft Excel

Overview of Data Tables - 2003 and 2007

TechRepublic.com:
Teach two-variable Excel data tables with real-life examples



See all Topics

Monday, September 15, 2014

Move the Line

Animate charts


PowerPoint has the ability to present elements of a graph one at a time for dramatic effect.

Here's one take from PPTWorkBench.com:
Complex Animations



This tutorial is an example of making PowerPoint do things that can't normally be done. In this case, we will tweak some chart animations that don't exist under normal circumstances.
  1. Create a chart with data,
  2. Ungroup the chart into individual pieces,
  3. Insert pictures that relate to the data,
  4. Do some grouping + animation.
Also:

Microsoft:
 Animate Chart Elements in Microsoft PowerPoint 

Internet4classrooms.com:
Animating a Chart - Using Ungrouping

Ungroup in 2007+  



See all Topics

Sunday, September 14, 2014

Homepage(s)

Easy links


Sure you have Favorites and you might have shortcuts on your desktop, but you really only use about a dozen sites on a regular basis.

Try out Only2Clicks. You can set up your home page to show graphic links to your major sites and be able to group them by purpose.



Only2Clicks.com



See all Topics

Saturday, September 13, 2014

Photoshop Beginings

Who started it all


"In the fall of 1987, Thomas Knoll, a doctoral candidate in computer vision, was trying to write computer code to display grayscale images on a black-white bitmap monitor.
Knoll thought it had limited value at best. The code was called Display. Knoll wrote it on his Mac Plus computer at home.
Little did he know that this initial code would be the very beginning of the phenomenon that would be known as Photoshop.

Thomas' program caught the attention of his brother, John, who worked at Industrial Light and Magic (the visual effects arm of Lucasfilm, the famous motion picture company founded by George Lucas.
With the release of Star Wars, Lucas had proved that really cool special effects, combined with heroic characters and a "shoot-em up script," could produce a blockbuster motion picture.
To that end, John was experimenting with computers to create special effects. He asked his brother Thomas to help him program a computer to process digital image files, and Display was a great starting point. So began their collaboration."

Photoshop profile

History of Photoshop



See all Topics

Friday, September 12, 2014

Print Raw Data

From reports and forms


Sometimes, you may not want to go to the effort of creating a report; you just need a quick hardcopy of data.

In such cases, you can simply print the Form view of your data. However, doing so also prints the background and shading associated with the form.

If you just need a quick data reference, you probably don't want to waste the resources and time to print such a detailed view. Fortunately, Access has a feature that lets you quickly print just the data from a form or report.

To do so, view the data you want to print in the form or report.

Then, choose:

Office button>Print>Print Preview (File >Page Setup)

select the Print Data Only check box

and click OK.

Doing so hides any graphics, lines, control borders, and label controls so that the print out simply contains data.





See all Topics

Thursday, September 11, 2014

Foxy or Ipsum

=rand(p,s)


In Word 2007+, =rand() produces a selection from the Help file.

=lorem() displays:


Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Maecenas porttitor congue massa. Fusce posuere, magna sed pulvinar ultricies, purus lectus malesuada libero, sit amet commodo magna eros quis urna.
Nunc viverra imperdiet enim. Fusce est. Vivamus a tellus.
Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Proin pharetra nonummy pede. Mauris et orci.


If you want some history, try Lipsum.com



Pre 2007:

To insert practice text in the document, type:
=rand()
and hit the ENTER key.

The whole equation would be:
=rand(p,s)
"p"is for p>aragraphs. "s" is for s>entences.

=rand(2,3)
would produce 2 paragraphs containing 3 sentences each.


It is said that:

The Italian edition of Microsoft Word 2000 produces:
"Cantami o Diva del pelide Achille l'ira funesta."

This is the first line of the Italian translation of Homer's Iliad.

In Spanish it's:
"El veloz murciélago hindú comía feliz cardillo y kiwi."

"The quick Hindu bat ate happy golden thistle and kiwi."

In French it's:
"Servez à ce monsieur une bière et des kiwis."

"Serve this gentleman a beer and some kiwis."

Other Panagrams

Choose Your Ipsum



See all Topics