Friday, January 31, 2014

View Related Fields

The whole thing


When designing a query, you'll often find the need to temporarily view fields beyond the ones you want shown in the final result.

To do so, you probably drag the relevant fields to the design grid and then delete them when you're done. However, there's an easier way to view the data that you typically want excluded in the query.

To do so:
  1. Open the query in Design view.
  2. Display the query's Properties sheet
  3. Set the Output All Fields property setting to Yes
  4. Run the query
Data from all of the underlying tables' fields will be displayed in addition to the fields you specified in the QBE grid. To change the query so that it only displays the fields explicitly selected in the QBE grid, simply
reset the Output All Fields property to No.


 



See all Topics

Thursday, January 30, 2014

Delete Fast

No waiting


Unfortunately, Outlook does not allow you to use CTRL or Shift to select multiple folders at a time to delete them. Also the process slows down as the contents are deleted and then the folder. A quick way to get rid of them is to drag them to the Deleted Items folder.

The same is true of emails destined for the garbage bin.

Outlook-Tips.net:
Delete Folders



See all Topics

Wednesday, January 29, 2014

CSS Links

Some of the Best


If you have an interest in Cascading Style sheets, look at a few of these tutorials and downloads.


"CSS Creator site is a place for you to learn about and create CSS, Cascading Style Sheets. The CSS Forum is a place where you can discuss CSS page layouts, positioning, bugs and just about anything related to cascading style sheets.
The forum is new, free and most of all needs people like you to create a community. Talk about CSS, ask questions, find solutions, and help each other learn at the CSS Forum."


CSS Creator.com has a collection of links to valuable Web design information.



See all Topics

Tuesday, January 28, 2014

Work that Menu

List of project docs


A collection of tips including:

Word (pre-07) allows you to add a menu to the toolbar that can keep a list of papers you're working on:


  1. Go to Tools>Customize.
  2. Click the Commands tab.
  3. Under the list of Categories, click Built-in menus.
  4. Under the list of Commands, locate and drag the Work menu to your toolbar.
  5. Click Close

Work Menu

In Word 2007+, you can see a list of 50 recently used documents when you click the Office logo. If you don't want them to drop off the list, they can be pinned.



See all Topics

Monday, January 27, 2014

Custom Lists

Your Way



At times, you will want to enter the same information repeatedly in a spreadsheet.
It could be employee names, products or State names.

Here is a way to produce the information when needed.

Make a list of the items.
Enter the data in, say, A1, B1, C1 etc.
Be sure to enter in the right order; maybe Supervisor and then team members in alphabetic order.

Select all of the cells.
Go to Tools>Options and choose the Custom lists tab.
Click Import.
OK your way out.

Now you can delete the entries on the spreadsheet.

Choose any cell and type one of the items that are on your Custom List.
Click and drag on the fill handle; the tiny square at the bottom right corner of the selected cell.
As you pull, Excel will duplicate your list.

(In Excel 2007+, go to the Office Logo. Choose Excel Options. Edit Custom Lists will be on the Popular page.)

Also see:

The First Shall Be Last
by Dick Kusleika

Sorting by Color
by Chip Pearson



See all Topics

Sunday, January 26, 2014

Secure Windows

Protection suggestions


Here is a collection of security measures you might consider installing.
Included is a way to require a stronger password.
Also good for Windows+.)


Use alpha-numeric passwords:

A normal password can be hacked easily. Hence, experts always recommend including alphabets, and numbers in the password.
Unfortunately, this limitation is not available in the password rules of Windows XP Operating System.
However, you can force the password to be alpha-numeric. Change the following registry entry:

HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion\Policies\Network


Double-click AlphanumPwds key and change the value to 1.

NOTE: If this key does not exist, you may need to create this key.


Make your Windows PC more secured



See all Topics

Saturday, January 25, 2014

PowerPoint Screed

WSJ on slide shows


Here is another article trying to rein in the PP overkill.
It is easier to put together a PowerPoint show than it is to write an intriguing speech; Six bullet points vs. 6 pages of text.

Why is it the that polite audience members congratulate even the worse presentations?


"But the civility has some self-interest. Larry Chung, a software developer, doesn't criticize fellow presenters, he says, "because I know the tables could be turned a few weeks later."
To him, PowerPoint presentations are like corporate karaoke. "For the most part, it's tough to listen to," he says. "We all applaud each other even though we know how bad it stinks."


Go Easy on the Text



See all Topics

Friday, January 24, 2014

Calendar Templates

New days


Here are calendars that you can produce using Word, PowerPoint, or even Visio.

Calendars

Also see
Make a Calendar

"For each month of each year featured, there are a variety of printable calendar pages for you to choose from. You can print out calendar pages that include coloring pages, selected craft projects, and special days to celebrate. "



See all Topics

Thursday, January 23, 2014

Progress Bar for Forms

Show movement


You can display computer time by using the Microsoft Progress Bar Control. In earlier versions of Access, it can be found by using the "More Controls icon in the Toolbox. In Access 2007 it's under "Insert Active X Control".



Here are the instructions from FunctionX.com:
Progress Clock



See all Topics

Wednesday, January 22, 2014

Calendar Printing Assistant

Printing help for 2007+


Some of the things you can do:


  • You can print and compare calendars in a variety of views:
  • Personalize your calendars with notes, images, colors, and designs:
  • Adjust information to changing views
  • Display information the way you need it:
  • Forecast your activities. The Calendar Printing Assistant has tools to display and organize long-range calendar
Calendar Printing Assistant

Also see Slipstick.com:
Printing Tools


See all Topics

Tuesday, January 21, 2014

Shoelaces

What's to know?


Fun, fashion & science in this quirky site about shoelaces. Whether you want to learn to lace shoes, tie shoelaces, stop shoelaces from coming undone, calculate shoelace lengths or even repair aglets, Ian's Shoelace Site has the answer!
Fieggen.com



See all Topics

Monday, January 20, 2014

Template Videos

See how it's done

Access 2010 template videos available.

"Access 2010 ships with five Web database templates, each of which does a great job of showing off the new features. We've created videos about how to use each template, as well as a sixth video showing you how to modify a template by adding a field."

Blogs.MSDN.com



See all Topics

Sunday, January 19, 2014

Spell Checker Update

Word 2007+

A discussion of how Spell Checker works and how it has improved over the years.

Office.Microsoft.com



See all Topics

Saturday, January 18, 2014

Friday, January 17, 2014

Montage in PPT

No need for Photoshop


Fill a picture with a gradient - or another picture in PowerPoint? Have you wanted to blend two pictures in PowerPoint to create a montage?

Transparent montages in PowerPoint



See all Topics

Thursday, January 16, 2014

Open Calendar

First thing

"If you want Outlook to start in the Calendar folder, go to Tools, Options, Other tab, Advanced and select the calendar in the Start up in this folder field. If the folder you want to use isn’t listed you can create a shortcut using the /select switch: "
outlook /select "outlook:calendar\subcalendar"

Outlook-Tips.net



See all Topics

Wednesday, January 15, 2014

Video Without Sidebar

Avoid collateral references

Sometime the appropriate video has inappropriate links next to it. Here's how to embed just what you want

AskDaveTaylor.com



See all Topics

Tuesday, January 14, 2014

Control Sort

Your choice

You can determine how Excel sorts your data.

ExcelTips



See all Topics

Monday, January 13, 2014

Find Commands

Ribbon seeker

MS has a download that can be used to search for those old toolbar commands on the new Ribbon.

OfficeLabs.com



See all Topics

Sunday, January 12, 2014

SS Zip Numbers

Excel to Access

Social Security Numbers and ZIP Codes can present special challenges when importing them into Access from Excel. This tip explains how you can prepare the data for the smoothest transition possible.
ExcelRibbon.Tips.net



See all Topics

Saturday, January 11, 2014

Set the Table

Descriptions

Tables in Word are more than just boxes.
This link describes and demonstrates other uses and formatting.

Blogs.MSDN.com



See all Topics

Friday, January 10, 2014

Command Line

Control Line

"The Windows command line is a mainstay for systems administrators and power users but is relatively unknown to many PC users. The purpose of this site is to make the power and utility of the command line more familiar to a wider community of computer users. Also under-appreciated are the related resources of batch files and scripts and these will be discussed as well."

CommandWindows.com



See all Topics

Thursday, January 09, 2014

Sound Throughout

Background

You can set up sound to run throughout your show, music or narration.
(Included on this link is a list of free music locations)

Indezine.com



See all Topics

Wednesday, January 08, 2014

Signature Tutorial

Sign it

"Create your own signatures using text, hyperlinks, pictures, or even an Electronic Business Card.
Use your signature in every message or just when you want to.
Create different signatures for your different roles or e-mail accounts and switch between them to suit your needs."

Office.Microsoft.com



See all Topics

Tuesday, January 07, 2014

CSS Basics

Tutorial

Cascading Style Sheets can help to unify site design.
Here are some tips:

HTMLGoodies.com



See all Topics

Monday, January 06, 2014

Stacked Columns

On on another

Instructions how to put one column on top of another in a chart.



People.stfx.ca



See all Topics